MySQL root permissions are controlled and cannot be authorized

A Environment:

MariaDB [(None)]> select version ();

+----------------+

| Version () |

+----------------+

| 5.5.50-|

+----------------+

Two. Engineer feedback Unable to create account

Three Problem Locator

View the user table to determine if an exception exists

No exception, the user exists, root privileges are also in. To view root whitelist permissions by command:

Root permissions are controlled on the MySQL database. Compare the root privileges of the normal library:

It is clear that Root is being charged only on the MySQL library, and the problem of lifting this limitation should be resolved.

Four. Problem Solving Solutions

View Mysql.db and find records of MySQL library

The original idea was to change MySQL to a wildcard%. Compare the soundness with the normal library:

The DB table in the normal library is not a record of the MySQL library. Ok, delete the MySQL record in the DB that appears in the problem library ( don't forget to do the backup before deleting it). after restarting the database, root privileges are restored .

MySQL root permissions are controlled and cannot be authorized