The role of the definition in MySQL (definer)

Phenomenon: After the database migration, the call function error, indicating that Definer does not exist.

Looked at, found that functions and stored procedures and the like, the call itself is not the concept of permission.

Definer This value does not limit the permissions that functions and stored procedures are called, but it restricts the access of functions and stored procedures to the database.

Functions and stored procedures gain access to the database for the Definer user when accessing the database.

Because after the relocation of the library, the Definer value has not been modified, the original database of the user in the new library does not exist, so error, modify the Definer value can be

The role of the definition in MySQL (definer)