mysqldump insufficent privileges to SHOW CREATE PROCEDURE
short description
When a app tries to dump its database with the routines it gets an error: insufficent privileges to SHOW CREATE PROCEDURE
correct behaviour
Since the user has full access on a database and can create routines it should be able to dump them.
environment
Server OS: (debian)
Server OS version: (jessie)
ISPConfig version: (3.1.8p1)
proposed fix
According to stackoverflow additional grant should be added of select on mysql.proc https://stackoverflow.com/questions/30841351/mysqldump-insufficient-privileges-to-show-create-function-funcation-name
GRANT SELECT ON mysql.proc to 'your-mysqldump-user';