title: Mysql Stored Procedure SQLYog issue
body: <p>I have setup my site in a way that I develop on <code>localhost</code> and then just updates it and all is good to go then but, there is a problem with the <code>Stored Procedures</code>.</p>
  
  <p>When I create a stored procedure on localhost and then <strong>using sqlyog copy that to live server then its copied normally but, am not able to alter it on live</strong>. To do so I have to create another one with some dummy name and then manually copy &amp; paste the code of SP on live and execute to create it.</p>
  
  <p>Any idea what might be the issue here?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I just found its issue with definer I think because executing the SP results in this error:</p>
  
  <pre><code>The user specified as a definer ('root'@'localhost') does not exist
  </code></pre>
  
  <p>I wan't expecting this problem because I removed the <code>definer</code> before copying the procedure but, its their. seems like </p>
  
  <blockquote>
    <p>sqlyog adds it by force maybe</p>
  </blockquote>
  
  <p>. Any idea to fix this?</p>