mobile logo

MySQL Backup User Privilege Grant

posted on February 5, 2009 / IN Quick Tip / Security / 1 Comment

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';

By admin

Tagged With

1 Comment

Please use the form to leave a comment

    • David Ward
      Posted on September 25, 201310:39 am Reply

      Thank you.

      Another site was adding in “SUPER” for a backup user. I don’t think so.

Page 1 of 1

Leave a comment.