List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 3 2001 2:36am
Subject:Re: How to start mysql server as user mysql
View as plain text  
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
>mysql?
>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.
>
>mysql:*:88:88::0:0:MySQL
>Daemon:/var/db/mysql:/sbin/nologin

Put a user line in the [mysqld] group of the /etc/my.cnf option
file, like this:

[mysqld]
user=mysql

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
Thread
How to start mysql server as user mysqlmysql list3 Jun
  • Re: How to start mysql server as user mysqlPaul DuBois3 Jun
  • RE: How to start mysql server as user mysqlDon Read3 Jun