MySQL "The user specified as a definer (" @ '% ') does not exist "problem resolution

"The user specified as a definer (" [email protected] '% ') does not exist "issue occurred when the 2017-12-27,mysql storage was called.

After the online check, are prompt user permissions are not enough, such as: http://blog.handone.com/index.php/archives/137.

But our production environment users are root, there should be no user rights issues. Later inadvertently found that the definition of storage is "[email protected]%", rather than "[email protected]%".

Later confirmed with the colleague, found that he used navicat transmission of two Zhang Xinqu, the storage is also transmitted over the cover, but the test environment our storage new user is "test" user, so manually remove these several storage manually rebuild is no problem.

So, record it and remind yourself that storage does not use the Navicat transfer feature.

MySQL "The user specified as a definer (" @ '% ') does not exist "problem resolution