Skip to content

MySQL permissions for backup

  1. GRANT SHOW DATABASES, SELECT, LOCK TABLES, RELOAD ON *.* to backup@localhost IDENTIFIED BY ‘password’;
  2. FLUSH PRIVILEGES;

Note

Create a specific user for backups purpose with read-only permissions

Tags: