The Mysql root user cannot use the grant

Using the root user

Perform:

Grant Select,insert,update,delete on projects.* to ' test ' @ ' percent ' identified by ' test ';

Results:

ERROR 1044 (42000): Access denied for user ' root ' @ '% ' to database ' XXXXX '

Workaround:

User MySQL;

SELECT * from user where user= ' root '

Look at the permission column there is not the option of Y, looked at, Grant_priv not y, decisive update, into Y.

Flush privileges;

Surprised, again execution is still rejected.

Look Back:select * from user where user= ' root ' found there are two of data, where the first data of the host column is a very strange value, regardless of it, directly update to% (all hosts can log in use), and then execute

flush Privileges;

Halo, Grant is still wrong, okay. Restart MySQL

Service MySQL Restart

Yes! This time, good! I'm dizzy!

The Mysql root user cannot use the grant