mysqlerror1370解决办法_MySQL

调用存储过程时报了下面的错误
ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseName.spName'

解决办法
对该账户授予执行存储过程的权限
mysql> grant execute on procedure databaseName.spName to 'backupAccount'@'localhost';

mysql> flush privileges;