title: mysql Stored procedures can be seen but cannot be executed by authorised user
body: <p>I have created a small DB (MariaDB, in a XAMPP environment) for my group, and we are currently using phpmyadmin to interact with the DB. I have created users and given them different permissions depending on their specific usage needs; and this works fine for tables and views. However something seems wrong with stored procedures. I need to give the user Global SELECT and EXECUTE privileges in order for them to run them. If I do it at the database level procedures can be seen but cannot be executed.</p>
  
  <p>I normally create the procedures from mysql workbench, and the look like this:</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `proc_name`()
  BEGIN
  ...
  END
  </code></pre>
  
  <p>And users are like:<code>user1@%</code> although I have also tried creating user like <code>user1@localhost</code> but it doesn't help.</p>
  
  <p>Any idea why this is happening? Does it have to do with the DEFINER?
  Many thanks in advance!</p>