MySQL的:执行命令拒绝用户``@'本地主机''的例行错误 [英] Mysql: execute command denied to user ''@'localhost' for routine error

问题描述

我在打开旧网站时遇到了一些问题.我的数据表显示:

i got some problem during open my old website. My dataTable show:

DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

之后，我尝试调试脚本并在mysql中发现错误:

After that, I tried to debug my script and found error in 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:

Then I tried to googling for execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage' and some sites said that I must do some GRANT:

GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'

但是我得到了

#1370 - execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'

你能告诉我如何解决这个问题吗?

could you tell me how should I do for solving this?

推荐答案

它有效... 我尝试在root中授予此特权.

It works..... I try to grant this priviledge in root.

1. 以root
登录
2. GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'
3. flush privileges;

1. log in as root
2. GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'
3. flush privileges;

这篇关于MySQL的:执行命令拒绝用户``@'本地主机''的例行错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！