MySQL的:执行命令拒绝用户“ @\'本地主机”的例行错误

|| 我在打开旧网站时遇到了一些问题。我的数据表显示:
DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
之后,我尝试调试脚本并在mysql中发现错误:
Error occuered during query execution: 
(<small>SELECT SQL_CALC_FOUND_ROWS ID,name,remark,avrusepmonth 
        , CONCAT(\'&lt;input type=\'\'checkbox\'\'id=\'\'cb\' , ID ,\'\'\' name=\'\'check[]\'\'                
        value=\'\'\',ID,\'\'\' &gt;\',\'&lt;label class=\'\'lbcb\'\' for=\'\'cb\', 
        ID,\'\'\'&gt;&lt;=update=&lt;/label&gt;\') as checkb 
        ,monthavrage(ID,12) as latestavr , moq, leadtime 
        FROM test_media  WHERE nowuse=1 and monthavrage(ID,12)  &gt; 0  ORDER BY  name
        desc, ID
        LIMIT 0, 10</small>):
 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\'
你能告诉我如何解决这个问题吗?     
已邀请:
        有用..... 我尝试在ѭ6中授予此特权。 以
root
身份登录
GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO \'jeinqa\'@\'localhost\'
flush privileges;
    
        很晚也要去聚会尝试一下。
GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO \'jeinqa\'@\'%\';
flush privileges;
另外,尝试将PROCEDURE替换为FUNCTION。     
        几个小时前,我在phpMyAdmin中遇到了这个问题,当时我执行了一个存储过程,并认为该错误将被检测为语法错误。 我在字段名称和计算字段之间缺少逗号,这给了我同样的错误消息。     

要回复问题请先登录注册