If you get the following error, it means that when
mysqld was started or when it reloaded the
grant tables, it found an account in the user
table that had an invalid password.
Found wrong password for user
'some_user'@'some_host';
ignoring user
As a result, the account is simply ignored by the permission
system.
The following list indicates possible causes of and fixes for
this problem:
You may be running a new version of
mysqld with an old
user table. You can check this by
executing mysqlshow mysql user to see
whether the Password column is shorter
than 16 characters. If so, you can correct this condition by
running the scripts/add_long_password
script.
The account has an old password (eight characters long) and
you didn't start mysqld with the
--old-protocol option. Update the account
in the user table to have a new password
or restart mysqld with the
--old-protocol option.
-
You have specified a password in the user
table without using the PASSWORD()
function. Use mysql to update the account
in the user table with a new password,
making sure to use the PASSWORD()
function:
mysql> UPDATE user SET Password=PASSWORD('newpwd')
-> WHERE User='some_user' AND Host='some_host';
