Change the stored procedure definer

To see the definers:

show procedure status;

You can change them like this:

UPDATE `mysql`.`proc` p SET definer="YournewDefiner" WHERE definer="OldDefinerShownBefore"

For example:

 UPDATE `mysql`.`proc` p SET definer="user@%" WHERE definer="root@%"

Be careful, because this will change all the definers for all databases.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)