B.4.2.14 Ignoring user
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_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
usertable. Check whether the
Passwordcolumn of that table is shorter than 16 characters. If so, correct this condition by running mysql_upgrade.
The account has an old password (eight characters long). Update the account in the
usertable to have a new password.
You have specified a password in the
usertable without using the
PASSWORD()function. Use mysql to update the account in the
usertable with a new password, making sure to use the
mysql> UPDATE user SET Password=PASSWORD('new_password') -> WHERE User='some_user' AND Host='some_host';