10.2 and mysql errors

markb658 · 07-07-2006, 08:24 PM

i did a fresh install of slackware, and everythings workin except mysql, i did the usual "su mysql" mysql_install_db and that all worked fine, but now i try to start the server i get errors, if i use

cd /usr ; /usr/bin/mysqld_safe &

i get the error

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/taes.pid
060707 15:40:20 mysqld ended

and if i user /etc/rc.d/rc.mysqld start

bash just hangs on

Starting mysqld daemon with databases from /var/lib/mysql

Any ideas? Cause this is holdin back some sites i need to get up and running again.

Cheers
Mark

willysr · 07-07-2006, 08:48 PM

you should run mysql_install_db as mysql user, not root user
the solution is to change the owner of /var/lib/mysql into mysql:mysql by using

Code:

chown -R mysql:mysql /var/lib/mysql

markb658 · 07-07-2006, 08:54 PM

Did the job, cheers!