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.

Similar Posts:

• [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
• ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
• When Navicat connects to a database on a server, there is an error prompt: 1130 ‘* *’ host is not allowed to connect to this MySQL server
• The user specified as a definer (‘root’@’%’) does not exist
• [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
• mysql ERROR 1044 (42000): Access denied for user ‘
• mysql 1449 The user specified as a definer does not exist
• [Solved] MYSQL ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mys…
• [Solved] MYSQL Error: The user specified as a definer (‘root’@’%’) does not exist
• Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449