How to solve the 1449 error when deleting a user in navicat

Related recommendations: "Navicat for mysql graphic tutorial"

1449 exception occurs when connecting to MySQL

mysql 1449 ： The user specified as a definer ('root'@'%') does not exist

Permission problem, grant all sql permissions to root;

mysql> grant all privileges on *.* to root@"%" identified by ".";
SQLException: The user specified as a definer ('ebook'@'%') does not exist：

Solution:

grant all privileges on *.* to ebook@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
#Mysql

The above is the detailed content of How to solve the 1449 error when deleting a user in navicat. For more information, please follow other related articles on the PHP Chinese website!