Computing Magazine

Creating a Read-only Backup User for Mysqldump

Posted on the 21 March 2016 by Hean Hong Leong @hongster
Creating a read-only backup user for mysqldump:

TL;DR

GRANT LOCK TABLES, SELECT ON *.* TO 'BACKUPUSER'@'%' IDENTIFIED BY 'PASSWORD';

Minimal permissions required for mysqldump are ‘LOCK TABLES’, and 'SELECT’.


Back to Featured Articles on Logo Paperblog