title: Is `definer` required when creating a stored procedure?
body: <p>I've written all of MySQL procedures as <code>root@localhost</code>:</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `p_add_user`(...)
  </code></pre>
  
  <p>Trouble is, when deploying to another server, I have to replace <code>root</code> with current user and replace <code>localhost</code> with current IP, which is annoying.</p>
  
  <p>Is there any way to write procedures so that someone who wants to use my database and procedures would not have to modify the definer of each procedure?</p>