On Tue, 10 Apr 2001, Simon Detheridge wrote:
Hi.
I'm a linux newbie, so no flames please ;) - I've just installed SuSE 7.1 to get an apache webserver running with PHP and MySQL... I installed the MySQL packages but it won't start.
I will definately not flame you, because I did the exact same thing. Fortunately for you, because this is the reason I know how to fix it.
I ran /usr/bin/mysql_install_db as root, and set start_mysql = "yes" in the RC-Config editor, using the YaST2 control center... Then restarted, but MySQL comes up as 'failed' during boot.
What am I not doing?
Actually you did too much - just like I did. You should not have run /usr/bin/mysql_install_db as root, because this installs MySQL's files as root-owned, but the MySQL daemon runs as the user mysql and is not allowed to read the newly installed files. The solution is (as root) to cd to /var/lib/mysql and delete everything here: all the linux-bin.* files and the mysql and test directories. Then issue the command: rcmysql start When this script starts up, if there are no mysql-databases, it will automatically run /usr/bin/mysql_install_db as user mysql. Hope this helps Regards Ole