mysqldump error “insufficent privileges to SHOW CREATE PROCEDURE”
Haven’t found this documented anywhere so here it is: A user reported today that while trying to dump his database, his mysqldump command was reporting this error: testdev has insufficent privileges to SHOW CREATE PROCEDURE Turns out the problem is that user testdev has all permissions in it’s own database, but no permissions in the mysql database. […]