Re: show create procedure fails after move to different server

[Charlie Farrow]

marin djendjinovic Wrote:
-------------------------------------------------------
> Thanks. I tried that, mysql_upgrade worked fine,
> gave no errors. Still procedures
> cannot be called from php scripts and "show create
> procedure" fails.


I am also having exactly the same problem!

Moved all the data from the old server to the new server and ran mysql_upgrade with no issues. I now cannot access the proceedures and my web application cannot run them. They are all listed in the mysql.proc table, but none of them work correctly.

Help!