The newly installed MySQL 5.7 runs the springboot project today, completes a new operation, and reports the following error
The user specified as a definer (‘root’@’%’) does not exist
After consulting a lot of data, it is concluded that this error is mainly caused by accessing the view file (without permission)
Therefore, database authorization is required. The specific operations are as follows:
1. Open CMD and log in to MySQL [MySQL – uroot – P password]. If you are in the database visualizer, skip the first step
2. Execute statement: grant all privileges on *. * to root @ “%” identified by “.”;
3. Refresh: flush privileges;
4. Complete
Similar Posts:
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- mysql 1449 The user specified as a definer does not exist
- [Solved] MYSQL Remote Connect Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449
- When Navicat connects to a database on a server, there is an error prompt: 1130 ‘* *’ host is not allowed to connect to this MySQL server
- [Solved] Access denied for user ‘ODBC’@’localhost’ (using password: NO)
- mysql ERROR 1044 (42000): Access denied for user ‘
- mysql 1142 – SELECT command denied to user ‘root_ssm’@’localhost’ for table …
- The user specified as a definer (root@’%’) does not exist [How to Solve]