Incorrect solution for stored procedures and functions in MySQL Import database

Incorrect solution for stored procedures and functions in MySQL Import database

Call a remote copy of the local MySQL storage process

Error: [ERR] 1449-the user specified as a definer (' repl ' @ ' 192.168.1.% ') does not exist

Solution Ideas:

With the "email protected" error that you have seen before, assign all permissions to root:

Grant all privileges on * * to [e-mail protected] "%" identified by ".";

Flush privileges;

Invalid discovery.

cause : The database may not have this user:

Select User,host from Mysql.user;

Result: The user was not found, but the error occurred.

Workaround:  

SELECT Definer,type from Mysql.proc GROUP by Definer,type;

UPDATE mysql.proc SET definer= ' [email protected] ' WHERE definer = ' [email protected]% ';

Restart the database, OK

This article is from the "7240173" blog, please be sure to keep this source http://wwdyl.blog.51cto.com/7240173/1639788

Incorrect solution for stored procedures and functions in MySQL Import database