MySQL Backup User Privilege Grant
Mar 25, 2022

MySQL Backup User Privilege Grant

LOCK TABLES and SELECT are the minimal requirements to use 'mysqldump'.You can use the following grant statement to create a user with as little privileges as possible: GRANT LOCK TABLES, SELECT ON mydatabase.* TO 'backup'@'hostname' IDENTIFIED BY 'p4sswOrd';

Related posts

Browse more
We haven't published any posts