Update MySQL Stored Procedure Definers on shared environment
SUGGESTION #1

If you login as root@localhost, you can change the definer in mysql.proc

In your case, you would do

UPDATE mysql.proc SET DEFINER = 'dbname@localhost';
SELECT name,type,definer FROM information_schema.routines;


I am not sure if the stored procedures load automatically into INFORMATION_SCHEMA.ROUTINES

If not, run these

FLUSH PRIVILEGES;
FLUSH TABLES;
SELECT name,type,definer FROM information_schema.routines;


SUGGESTION #2

Based on my old post Modify DEFINER on Many Views, you can do the following


You may have to mysqldump the stored procedures into a test file
Edit the definer user to 'dbname@localhost' in the text file
Then, reload the stored procedures


GIVE IT A TRY !!!