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. It’s sufficient in this case to grant the user just select on the mysql.proc table:
GRANT SELECT ON mysql.proc TO 'testdev'@'%';
And that fixed it.