Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist

mysql> grant all privileges on *.* to root@"%" identified by "PASSWORD";
Query OK, 0 rows affected

mysql> flush privileges;
Query OK, 0 rows affected

mysql>

 

Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist

标签：java   query   ges   bsp   row   mysql   授权   log   user