At 7:05 PM -0700 6/2/01, mysql list wrote:
>In my UNIX (FreeBSD) system the database directories
>shows up as below.
>drwx------ 2 mysql mysql 512 May 11 11:51 mysql
>drwx------ 2 mysql mysql 512 May 11 22:40 test
>I guess this means I should only start mysql server by
>being the user mysql. But how can I become the user
>The user/group mysql was created automatically during
>install and mysql is actually a system process, thus
>it has no password, the password database shows this
>listing for the user mysql.
Put a user line in the [mysqld] group of the /etc/my.cnf option
file, like this:
Then start the server as root (safe_mysqld, mysql.server, etc.).
The server will notice the user line in the [mysqld] group
and change its user id to that of the mysql account.
Paul DuBois, paul@stripped