Create correct user privileges / grant to use for mysqldump

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *