mysql1449 the user specified as a definer (' root ' @ '% ') does not exist solution

Migrating from a database data to a local localhost program in the call to the database view times wrong, directly in the database open the view also error, similar to: MySQL 1449:the user specified as a definer (' long ' @ '% ') does Not exist is a permission problem, solution: Run: Grant all privileges on * * to [email protected] "%" identified by ";  When the view is opened, no error is raised and the program call does not error. Explanation of Source Address:

Permissions issue, Grant root all SQL permissions

Mysql> Grant all privileges on * * to [e-mail protected] "%" identified by ".";
Query OK, 0 rows Affected (0.00 sec)


mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)

mysql1449 the user specified as a definer (' root ' @ '% ') does not exist solution