当在mySQL数据库中进行查询时,出现错误提示:HY400 The user specified as a definer (‘root’@’%’) does not exist;
连接mySQL命令行,输入密码,登陆成功后,然后执行下面两条命令:
grant all privileges on . to root@"%" identified by “.”;
出现:Query OK, 0 rows affected (0.00 sec),说明命令执行成功;
flush privileges;
出现:Query OK, 0 rows affected (0.00 sec),说明命令执行成功;