mysql 跑存储过程没有权限的问题

1.赋予权限

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";

2.刷新权限

FLUSH PRIVILEGES;