Page 1 of 1
Grant rights to a backup user.
Posted: Mon Feb 22, 2016 6:44 pm
by Peter_w
Hello,
I want to create a backup user account with only read access,
to use with mysqldump.
what are the minimum rights I have to grant to this user?
Re: Grant rights to a backup user.
Posted: Tue Feb 23, 2016 5:20 pm
by chris
I think the minimum right mysql dump needs is SELECT and LOCK TABLES
Code: Select all
GRANT SELECT, LOCK TABLES ON database.* TO ‘backup’@’hostname’ IDENTIFIED BY ‘password';
Don't forget to flush command:
Re: Grant rights to a backup user.
Posted: Sun May 16, 2021 8:39 am
by chris
PROCESS privilege is new as of MySQL 5.7.31 and MySQL 8.0.21 and is also needed if you don't use
--no-tablespaces.
privilege needed for mysqldump backup user:
- SELECT privilege for dumped tables
- SHOW VIEW for dumped views
- TRIGGER for dumped triggers
- LOCK TABLES if you don’t use the --single-transaction option
- PROCESS if you don’t use the --no-tablespaces option