Resolving the phenomenon of ignoring users in MySQL

If you encounter the following error, the account that has an illegal password is found in the user table when you start mysqld or reload the authorization table.

User ' Some_user ' @ ' some_host ' password error found: Ignore user.

As a result, the licensing system will simply ignore the account.

In the following introduction, the possible causes and corrective actions for the problem are indicated:

1. Perhaps, you are planning to run the new version of Mysqld with the old user table. The mysqlshow MySQL user checks whether the password (password) column is shorter than 16 characters, in this way you can check the problem. If the result is yes, run the script/add_long_password script to correct the problem.

2. The account has an old password (8 characters) and does not use the "--old-protocol" option to start the mysqld. Update the account in the user's table so that it has a new password, or restart the mysqld using the--old-protocol option.

3. The password is not specified in the user table using the password () function. Use MySQL to update the accounts in the user table with the new password, be sure to use the password () function:

4.

mysql> Update user SET Password=password (' newpwd ')

5.

-> where user= ' Some_user ' and host= ' some_host ';