Bob Williams wrote:
My problem is getting the server to start. The reset password instructions say to stop the server by ...
--quote-- Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, host name, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the file name has an extension of .pid and begins with either mysqld or your system's host name.
You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the path name of the .pid file in the following command:
shell> kill `cat /mysql-data-directory/host_name.pid` --end quote--
I found the pid in /var/lib/mysql/localhost.pid
Hi Bob, hmm, I would have expected to find it in: /var/run/mysql/mysqld.pid
but if I try to restart the server (as root), I get
barrowhillfarm:~ # /etc/init.d/mysql start Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds
Check the mysqld log file - probably in /var/log/mysql/mysqld.log or /var/lib/mysql/mysqld.log I would guess something isn't quite right in /etc/my.cnf -- Per Jessen, Zürich (0.6°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org