Create correct user privileges / grant to use for mysqldump
MySQL
Create correct user privileges / grant to use for mysqldump
To make sure you have the correct user permissions for the backup user that you will use for dumping mysql databases for backup
mysql> GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'backup'@'localhost'; mysql> GRANT LOCK TABLES ON *.* TO 'backup'@'localhost';
Thanks to this post for the help