423,851 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,851 IT Pros & Developers. It's quick & easy.

Strange access denied problem

P: n/a

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
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.