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 then 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 this 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
--
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
pgpmcOCgg0iAY.pgp
Description: PGP signature
