Starting MySQL automatically on Slackware 10 on system startup

abtimoteo · 09-21-2007, 09:22 PM

How do you run MySQL on Slackware 10 on system startup? I already changed permissions for rc.mysqld to 755. Also, I ran mysql_install_db. On system startup, I get the following error message:

STOPPING server from pid file /var/run/mysql/mysql.pid

tronayne · 09-22-2007, 06:50 AM

If you have not done the initial setup of MySQL like this (or with sudo, your choice):

Code:

su -
enter root password
mysql_install_db --user=mysql

you'll get that (the important one is the "--user=mysql").

If you did not do as above, and you do not have any data bases in /var/lib/mysql, you can remove that directory, run mysql_install_db as shown and you'll probably be OK.

You can manually start the MySQL daemon with:

Code:

su -
password
/etc/rc.d/rc.mysqld start

abtimoteo · 09-24-2007, 01:40 AM

Since MySQL could not write to /var/run/mysql, I changed its ownership.

chown -R mysql /var/lib/mysql

Then, I re-ran mysql_install_db.