Archive for March 2015

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. […]