Mysql-Change Definer In Stored Procedure

Created from SR 3-7760169791

Applies to: MySQL Server - Version 5.0 and later Goal Change the definer of a stored procedure   Solution It is possible to change the definer of a procedure by editing the mysql.proc table directly: UPDATE mysql.proc SET definer = 'new_user@new_host' WHERE definer = 'old_user@old_host'; It may be necessary to log off and back on to see the effect in a SHOW CREATE PROCEDURE statement. However, direct modification of the system tables is generally not advised - MySQL does not guarantee that those tables will retain the same format in future versions. Instead, use SHOW CREATE PROCEDURE to get the entire syntax necessary to recreate the procedure, modify the DEFINER section, then DROP PROCEDURE and recreate it with the new definition.