This problem is related to another issue that I am having, but basically I’m trying to find a way of updating the ‘definer’ field in mysql.proc as I’d like to make the definer the same value for all routines that have been created on a particular database.
Basically, due to a bug in mysqldump, backing up stored routines using mysqldump won’t work unless the definer of the routines is the same as the user doing the backup. However, I’ve created routines with different IP addresses (as a result of using different computers) and this is now causing a problem e.g. email@example.com is different to firstname.lastname@example.org.
To resolve this, I need to update the definer in mysql.proc to be the same user @ the same IP address and then run mysqldump under this same account (which should all be fairly simple):
SET definer = 'email@example.com’
WHERE db = ‘mydb’ AND definer LIKE ‘username@%’;[/font]
However, even though I’m on MySQL PS, I don’t seem to have access to update this table. Is this permission not allowed under MySQL PS?