MySQL backup user
To create a backup user for MySQL you need at least the following privileges (to use mysqldump):
GRANT SELECT, SHOW VIEW, LOCK TABLES ON *.* TO 'backup'@'localhost';
To create a backup user for MySQL you need at least the following privileges (to use mysqldump):
GRANT SELECT, SHOW VIEW, LOCK TABLES ON *.* TO 'backup'@'localhost';
Weil ich ständig vergesse, wie man in der Shell einem User eine weitere sekundäre Gruppe zuweist:
usermod -a -G gruppe username