title: How to create a stored routine that is editable from everywhere
body: <p>I am practising creating MySQL stored routines and am having problems editing them from different areas. If I create it in HeidiSQL, the definer is saved with the IP address so can only edit them in HeidiSQL from the same IP. If I create them in phpMyAdmin, it is only editable from phyMyAdmin, not HeidiSQL.</p>
  
  <p>When you bear in mind that I can edit the actual table data (create, delete, drop, etc) from anywhere (if I have added the IP address), it seems ludicrous that these limitations occur with what is essentially a simple function.</p>
  
  <p>Is there any way, when creating a stored routine, I can set the definer so that it is accessible from whatever program and IP address I am using?</p>