数据库报错:
The user specified as a definer (‘root’@’%’) does not exist
权限问题,授权 给 root 所有sql 权限
进入mysql命令:mysql -uroot -p密码
mysql> grant all privileges on . to root@"%" identified by “.”;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
迁移数据库后,调用存储过程出错了
Error: ER_NO_SUCH_USER: The user specified as a definer (‘root’@’%%’) does not exist
先创建root@"%%“账户:mysql> create user root@”%%";
Query OK, 1 row affected (0.06 sec)
之后再调用存储过程报错:
Error: ER_PROCACCESS_DENIED_ERROR: execute command denied to user ‘root’@’%%’ for routine ‘hgtdatabase.resetPsw’
给root@"%%"权限,mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%%’;
Query OK, 0 rows affected (0.01 sec)。