The user specified as a definer ('root' @ '%') does not exist, specifieddefiner
Zookeeper is generally because the root user has no access permission to the global host. Therefore, you only need to add an access permission to the root user.
Solution:
Log on to mysql and run
Mysql-u root-pPasswd
Mysql> grant all privileges on *. * to root @ "%" identified by "Passwd"
Mysql> flush privileges
Mysql user table operation permissions (java)
That's because there is a delete trigger in your database. The trigger is defined by admin,
Solution;
1. Delete the trigger.
2. Add the admin @ localhost user.
2 or 1;
Note that it must be admin @ localhost, not admin @ % or admin@127.0.01
Create definer = 'root' @ 'localhost' TRIGGER 'wl _ db' 'tbl _ dispatch_trigger 'before delete on 'wl _ db'
There seems to be no errors in the visual syntax.
What is the error message?