1:mysql版本 5.7.11
2:首先你得有root账户,用root登录授权,查看root是否有grant权限
SELECT HOST,USER,Grant_priv,Super_priv FROM mysql.user;
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
退出,重新登录
查看账户权限SHOW GRANTS FOR mdtest;
3,授予存储过程的权限:
mysql> grant create routine on test.* to 'mdtest'@'%';
Query OK, 0 rows affected (0.08 sec)
mysql> grant execute on procedure test.myproc to 'mdtest'@'%';
Query OK, 0 rows affected (0.04 sec)
这个语句有些版本不适用,换用 GRANT EXECUTE ON md_fund_new_db2.* TO 'mdtest'@'%';
执行刷新 FLUSH PRIVILEGES;
问题得到解决!