Hi,
Yesterday I signed up for another dedicated linux server with the hosting
company I use and I am having problems getting MySQL 4.1.3 working on it.
I've tried just about everything I can think of to login via the MySQL
client but get a variation of the following error every time:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
I put skip-grant-tables in to my.cnf and restarted the mysqld service and
logged in to the client as root no problem. I manually cleaned up the User
table by resetting all the passwords using:
UPDATE mysql.user SET Password=PASSWORD('mynewpass');
FLUSH PRIVILEGES;
and granting all priveleges to all users. My User table now looks like this:
+-----------------------+------------+------------------+
| host | user | password |
+-----------------------+------------+------------------+
| localhost | root | *EAA2B914CE13E7B |
| srv01.mysite.net | root | *EAA2B914CE13E7B |
| localhost | wpphpadmin | *EAA2B914CE13E7B |
| localhost | myuser | *EAA2B914CE13E7B |
| localhost.localdomain | myuser | *EAA2B914CE13E7B |
| 127.0.0.1 | myuser | *EAA2B914CE13E7B |
+-----------------------+------------+------------------+
I've cut off the priveleges for readability but they are all set to Y apart
from Grant_Priv which only root has.
When I remove the skip-grant-tables from the my.cnf file and restart the
service I get the following errors when I try to login:
mysql -u root -p
Enter password: mynewpass
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
mysql -h 127.0.0.1 -u root -p
Enter password: mynewpass
ERROR 1045 (28000): Access denied for user 'root'@'localhost.localdomain'
(using password: YES)
mysql -h srv01.mysite.net -u root -p
Enter password: mynewpass
ERROR 1045 (28000): Access denied for user 'root'@'srv01.mysite.net' (using
password: YES)
mysql -h localhost -u root -p
Enter password: mynewpass
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
mysql -u wpphpadmin -p
Enter password: mynewpass
ERROR 1045 (28000): Access denied for user 'wpphpadmin'@'localhost' (using
password: YES)
etc.
The same goes for the myuser user as well. None of them seem to work.
My setup is:
Redhat Linux 2.4.21-4.0.1
Apache 2.0.46
PHP 4.3.2
MySQL 4.1.3
Ensim WEBppliance Pro 4.0.0-14
Any help you can give me would be much appreciated.
Thanks
Steve
