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(\'<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</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\'
你能告诉我如何解决这个问题吗?
没有找到相关结果
已邀请:
3 个回复
癸痊醒
身份登录
邵酮
和
另外,尝试将PROCEDURE替换为FUNCTION。
磨标烫徽啪