Date: Tue, 8 Jun 2004 22:42:30 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: RazorOnFreeBSD <yann.luppo@attglobal.net> Cc: freebsd-questions@freebsd.org Subject: Re: mysql user Message-ID: <20040608214230.GA7575@happy-idiot-talk.infracaninophile.co.uk> In-Reply-To: <00ca01c44d6b$b4887e20$0f01a8c0@razor> References: <00ca01c44d6b$b4887e20$0f01a8c0@razor>
next in thread | previous in thread | raw e-mail | index | archive | help
--gKMricLos+KVdGMg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Tue, Jun 08, 2004 at 05:15:51PM +0200, RazorOnFreeBSD wrote:
> I maybe didn't see something, for sure it's a dumb problem....
> I installed MySQL 4.0.20 from sources downloaded on MySQL website and the=
n I checked before adding my "mysql" user on the box if there was one .... =
I never installed MySQL before and I already have a mysql user but I don't =
know his password.....
> What should I do ? Uninstall / ReInstall MySQL ? Delete user "mysql" and =
create another one ? or is there an obvious first password to change I didn=
't get ?
> I'm a little bit lost there... even if it's not an obligation to have thi=
s user named "mysql", it's easy to use everyday!
A mysql user will be created if you install mysql (any version) from
ports. Even if you are strange enough to decide not to use ports, the
way the mysql user is set up by the port would be a good thing to
copy:
mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin
Where UID 88 and group 88 are reserved for MySQL:
http://www.freebsd.org/doc/en_US.ISO8859-1/books/porters-handbook/dads-=
uid.html
This account is designed to be the owner of the MySQL processes and
nothing more. Specifically, it has a locked password (the '*' in the
second field) and the shell set to /sbin/nologin -- a small program
that prints "This account is currently not available." and exits
immediately. The home directory shown (/var/db/mysql) is the default,
and the location where MySQL keeps its data files. You can override
that when installing the port.
Note that you never need to login as the mysql user. MySQL has it's
own set of user IDs and it's own passwords /within/ the database which
are separate from the passwd database on your server.
Cheers,
Matthew
--=20
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
Savill Way
PGP: http://www.infracaninophile.co.uk/pgpkey Marlow
Tel: +44 1628 476614 Bucks., SL7 1TH UK
--gKMricLos+KVdGMg
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFAxjLGiD657aJF7eIRAogBAJ9ba9FCdLwCr6XQda5djgUkAPoRIACfU6rS
R21GKAHeszA0cHVaS4UKfVI=
=zk0A
-----END PGP SIGNATURE-----
--gKMricLos+KVdGMg--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040608214230.GA7575>