Hi Per, On Friday 28 Jan 2011 10:46:44 Per Jessen wrote:
:)
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting -permissions-unix
Many thanks for the Google tips. I had already done similar searches and found similar resources. 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 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 chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory failed IOW, it is looking in /var/run not /var/lib /var/run/mysql contains a 22B file called tmpdir Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.3 64-bit, Kernel 2.6.36.90-desktop, KDE 4.5.3 Intel Core2 Quad Q9400 2.66GHz, 8GB DDR RAM, nVidia GeForce 9600GT -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org