title: execute command denied to user readonlyuser
body: <p>Although localhost has execute permission, I'm getting error below when I run query in my web application. What I did normally solves problem of other users in this and other forums but for some reason doesn't solve mine unless I'm missing something.</p>
  
  <p>Note: When I run same query in navicat or anywhere else, it works fine.</p>
  
  <p>Is there anything else to solve this problem?</p>
  
  <p>Thanks</p>
  
  <p><strong>QUERY:</strong></p>
  
  <pre><code>SELECT
  get_balance('$deadline', '$id') AS Balance,
  allow_submission('$id', '$term') AS Over
  FROM dual
  </code></pre>
  
  <p><strong>ERROR:</strong></p>
  
  <pre><code>execute command denied to user 'readonlyuser'@'localhost' for routine 'mydb.allow_submission'
  </code></pre>
  
  <p><strong>WHAT I DID:</strong> <em>In Navicat GUI and Linux terminal as <code>root</code> and <code>superuser</code>.</em></p>
  
  <pre><code>GRANT EXECUTE ON PROCEDURE mydb.allow_submission TO 'readonlyuser'@'localhost';
  </code></pre>