The solution to the 1449 error caused by deleting users from navicat

Editor to share with you the solution to the 1449 error caused by navicat deletion users, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

1449 exception occurred while 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 and above are all the contents of this article entitled "solution to the 1449 error caused by navicat deletion users". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!