title: Mysql: execute command denied to user ''@'localhost' for routine error
body: <p>i got some problem during open my old website. My dataTable show:</p>
  
  <pre><code>DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
  </code></pre>
  
  <p>After that, I tried to debug my script and found error in mysql:</p>
  
  <pre><code>Error occuered during query execution: 
  (&lt;small&gt;SELECT SQL_CALC_FOUND_ROWS ID,name,remark,avrusepmonth 
          , CONCAT('&amp;lt;input type=''checkbox''id=''cb' , ID ,''' name=''check[]''                
          value=''',ID,''' &amp;gt;','&amp;lt;label class=''lbcb'' for=''cb', 
          ID,'''&amp;gt;&amp;lt;=update=&amp;lt;/label&amp;gt;') as checkb 
          ,monthavrage(ID,12) as latestavr , moq, leadtime 
          FROM test_media  WHERE nowuse=1 and monthavrage(ID,12)  &amp;gt; 0  ORDER BY  name
          desc, ID
          LIMIT 0, 10&lt;/small&gt;):
   execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'
  </code></pre>
  
  <p>Then I tried to googling for <code>execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'</code> and some sites said that I must do some <code>GRANT</code>:</p>
  
  <pre><code>GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'
  </code></pre>
  
  <p>but I got:</p>
  
  <pre><code>#1370 - execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'
  </code></pre>
  
  <p>could you tell me how should I do for solving this?</p>