1. The MySQL database on the project connection server is OK, and there is a problem connecting to the local database:
The user specified as a definer (' root ' @ '% ') does not exist
2.
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)
The execution of these two statements is to go to the mysql5.5 installation directory, locate the bin, then enter Mysql-u root-p in the cmd window, enter the password, and go to the MySQL command to execute.
The two statements can also be executed directly in the MySQL foreground tool, just as effectively.
Project Add server on the database is OK, add local database problem (the user specified as a definer (' root ' @ '% ') does not exist)