1,在mysql执行某条sql语句的时候报错代码如下:The user specified as a definer (‘root’@‘127.0.0.1’)
2,这是权限问题,只要授权 给 root 所有sql 权限就可以了
3,于是解决方法如下:
mysql> grant all privileges on . to root@“127.0.0.1” identified by “.”;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)