1. Find XXX user and find that it does not exist

select user,host from mysql. user;

The XXX user who created the view before has been deleted

2. Find these views and modify the definer information

select concat(“alter_definer=`root`@`%` view “, table_name, ” as “, view_definition, “;”)
from information_ schema. views
where table_schema='< Your database name> ‘;

The above SQL will generate a statement to modify the definer, which can be executed

Similar Posts:

• ERROR 1044 (42000): Access denied for user ‘root’@’localhost’ to database ‘in…
• 12 Methods of SQL Error Injection [How to Inject]
• Mysqldump common error reports and Solutions
• mysql 1142 – SELECT command denied to user ‘root_ssm’@’localhost’ for table …
• [Solved] Deploying Tomcat connection in Linux Navicat reports error 2059 – authentication plugin ‘caching_sha2_Password ‘cannot be loaded: + Xi input 9 g
• [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 unknown table ‘column_statistics’
• mysql ERROR 1044 (42000): Access denied for user ‘