Mailinglist Archive: opensuse (887 mails)

[Bob Williams <linux@xxxxxxxxxxxxxxxxxxxxx>]

Hi Per,

On Friday 28 Jan 2011 10:46:44 Per Jessen wrote:
> http://lmgtfy.com/?q=mysql+server+password+reset
:)

> 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@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx