title: Change the stored procedure definer
body: <p>I have a around one hundred stored routines in my MySQL database with with most of them have 'root' as the definer.</p>
  
  <p>I have another mysql account named 'abc', how to change the definer of all routines to 'abc'.</p>
  
  <p>Is it possible to do the same if I have access to MySQL server only as 'abc' user and not as 'root'</p>