This error message means that the account root @ ‘%’ does not exist. The view creation account corresponding to root user does not exist or has been deleted. It needs to be re created and given permission to use the view normally
grant all privileges on *.* to root@”%” identified by “.”;
flush privileges;
Similar Posts:
- [Solved] MYSQL8.0 Error: the user specified as a definer (‘root’@’%’) does not exist
- ERROR 1044 (42000): Access denied for user ‘root’@’localhost’
- mysql 1449 The user specified as a definer does not exist
- [Solved] MYSQL Error: The user specified as a definer (‘root’@’%’) does not exist
- The user specified as a definer (‘root’@’%’) does not exist
- 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
- Mysqldump backup problems got error: 1045, error 1045 (28000), got error: 1449
- [Solved] MYSQL Remote Connect Error: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- mysql 1142 – SELECT command denied to user ‘root_ssm’@’localhost’ for table …
- mysql ERROR 1044 (42000): Access denied for user ‘