title: Alter DEFINER for specific stored procedure in place?
body: <p>I've seen a few places where it's shown how to alter the definer for multiple stored procedures. I have one SP 'this_stored_procedure' that I want to change the definer from what it's set to now to something different. </p>
  
  <pre><code>UPDATE `mysql`.`proc` p SET definer = 'YournewDefiner' WHERE definer='OldDefinerShownBefore'
  </code></pre>
  
  <p>I tried this command and it altered the definer for any procedure that had the old user. I want to be able just to change the definer for one SP without changing the others. Is there a way to isolate the above query?</p>