I have a very simple question about starting mysql. I start manually the server under the unix account "mysql" with the following: /seqweb/mysql4/bin/mysqld_safe --user=mysql & in order to get the unix user "mysql" to run the process. I get the following with "ps -ef | grep mysql": mysql 29527 29506 0 08:19:53 pts/4 0:04 /seqweb/mysql-4.1.7/libexec/mysqld --basedir=/seqweb/mysql-4.1.7 --datadir=/hom mysql 29506 29366 0 08:19:53 pts/4 0:00 /bin/sh /seqweb/mysql4/bin/mysqld_safe --user=mysql
Now I would like the unix "root" to do the same. The unix user "root" does the Unix backup so it must stop the bd and, after backup completion, start it. If I use root to start the bd with "/seqweb/mysql4/bin/mysqld_safe --user=mysql &" then I have : root 29459 1 0 08:16:59 ? 0:00 /bin/sh /seqweb/mysql4/bin/mysqld_safe --user=mysql mysql 29482 29459 0 08:16:59 ? 0:02 /seqweb/mysql-4.1.7/libexec/mysqld --basedir=/seqweb/mysql-4.1.7 --datadir=/hom... Same thing for the startup of the sun server. How can I do so that both process are owned by the unix user "mysql"? What exactly does each process. I know that mysql_safe is a wrapper for mysqld but why does mysqld_safe stay as a process and what is the impact of running it as a root. I could not find anything in the doc. Thank you in advance. Johanne Duhaime [EMAIL PROTECTED]
