05 Feb 2009

MySQL Backup User Privilege Grant 

By - 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’;

One Response to “MySQL Backup User Privilege Grant”

  1. David Ward says:

    Thank you.

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

Leave a Reply