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 mysql512 May 11 11:51 mysql
drwx-- 2 mysql mysql512 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, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php