>
>When I attempted to change the MySQL root user with the command "mysqladmin
>-u root -p password 'new-password' " I received the following error:
>"Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the
>socket; '/var/lib/mysql/mysql.sock' exists!"
>I checked the directory stated for the mysql.sock and it does exist, but
>when checking the status of mysqld using 'service mysqld status' I received
>the following: "mysqld dead but subsys locked."
- delete the lock file (as root)
- restart mysql
- look at the logs (mysql.err)
- make sure the directory /var/lib/mysql/ has the right permissions!!
("chmod o+rx /var/lib/mysql/").
hgs
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
