[FEATURE REQUEST] Documentation / List required SQL Privileges

[W1zzardTPU]

It would be useful to have a section in the documentation that lists the privileges required for a MyDumper user in the database (and why)

Answer from ChatGPT, not sure if accurate

To create a backup user in MySQL for mydumper, you need to grant the necessary privileges to allow the user to perform backups efficiently. Here’s the SQL script to create a backup user:

CREATE USER 'backup_user'@'localhost' IDENTIFIED BY 'StrongPassword';

GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT, SHOW VIEW, EVENT, TRIGGER, SELECT ON .
TO 'backup_user'@'localhost';

FLUSH PRIVILEGES;

Explanation of Privileges:

SELECT ON *.*: Allows reading all databases and tables.
RELOAD: Required for FLUSH operations (used in mydumper).
LOCK TABLES: Needed to use FLUSH TABLES WITH READ LOCK for consistent backups.
PROCESS: Grants access to process list (SHOW PROCESSLIST).
REPLICATION CLIENT: Required for reading binary log positions.
SHOW VIEW: Allows viewing database views.
EVENT: Grants access to backup database events.
TRIGGER: Allows backing up triggers.