MySQL Error: The user specified as a definer (xxx@xxx) does not exist

Today due to the replacement of the server, re-local backup of the database, trial run program error, as follows:

MySQL Error: The user specified as a definer ([email protected]) does not exist

This means that the definition of a database object (i.e. [email protected]) does not exist.

The reason is that when the database is exported and restored, the definition of the view is still the original user,

However, the local database does not have a corresponding user.

Workaround: Copy the view statement, replace the user information, that is (XXX@XXX) marked red place, and then delete the original view, regenerate it.

MySQL Error: The user specified as a definer ([email protected]) does not exist