Tag Archives: MySQL.ERROR 1133 (42000): Can’t find any matching row in the user table

[Solved] MySQL ERROR 1133 (42000): Can’t find any matching row in the user table

ERROR 1133 (42000): Can’t find any matching row in the user table

Today, after executing grant all privileges on cache_cloud.* to ‘cachecloud’@’%’; an error message appears: ERROR 1133 (42000): Can’t find any matching row in the user table.

As follows:

Solution.

Execute the statement.flush privileges;

Execute the statement again: grant all privileges on cache_cloud.* to ‘cachecloud’@’%’; Success.

The overall execution statement is as follows.