mysql例行性检查_Mysql：对用户'''localhost'执行命令被拒绝，用于例行错误

我在打开我的旧网站时遇到了一些问题。我的dataTable显示：

DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.之后，我试图调试我的脚本并在mysql中发现错误：

Error occuered during query execution:

(SELECT SQL_CALC_FOUND_ROWS ID,name,remark,avrusepmonth

, CONCAT('<input type=''checkbox''id=''cb' , ID ,''' name=''check[]''

value=''',ID,''' >','<label class=''lbcb'' for=''cb',

ID,'''><=update=</label>') as checkb

,monthavrage(ID,12) as latestavr , moq, leadtime

FROM test_media WHERE nowuse=1 and monthavrage(ID,12) > 0 ORDER BY name

desc, ID

LIMIT 0, 10):

execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'然后我试图搜索execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'，有些网站说我必须做一些GRANT：

GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'但我得到了：

#1370 - execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'你能告诉我该如何解决这个问题？