i see. there is an option in my.cnf which says which user to run mysqld as. change this to mysql. make sure that mysql is a real user on your system. also, be sure to set the full path to the basedir and datadir in the my.cnf
user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data or whatever your paths are. -----Original Message----- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: RE: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! Thank you for pointing that our. I never edited the my.cnf file, and those two variables were way off. I edited them to their correct values and here is the result: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql & [1] 4774 [root@cofr3 mysql]# Starting mysqld daemon with databases from /mysql/data 021122 15:57:25 mysqld ended [1]+ Done ./bin/safe_mysqld --user=mysql ---------------------------------------------------------------------------- -- I believe that this change is certainly a step in the right direction. However, the original error is quite persistant: [root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 021122 16:00:58 Aborting 021122 16:00:58 ./bin/mysqld: Shutdown Complete Regards, Ken Illingsworth >>> Shon Stephens <[EMAIL PROTECTED]> 11/22/02 03:40PM >>> you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql trying to start with databases from /var/lib/mysql. check your startup script for basedir and datadir settings. -----Original Message----- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 3:30 PM To: < Subject: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql & and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
