XtraBackup 2.4 manual missed PROCESS among minimal privileges required for full backups
Bug #1594990 reported by
vaniachine@gmail.com
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.3 |
Fix Released
|
Medium
|
Hrvoje Matijakovic | |||
2.4 |
Fix Released
|
Medium
|
Hrvoje Matijakovic |
Bug Description
The manual section at
https:/
says
An SQL example of creating a database user with the minimum privileges required to full backups would be:
...
mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'
...
With these minimum privileges the xtrabackup --prepare command works for version 2.3.4 but fails for version 2.4.3 with
Error: failed to execute query SHOW ENGINE INNODB STATUS: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
To post a comment you must log in.
Thank you for bug report!
PROCESS privilege is needed for 2.3 as well, in particular for https:/ /www.percona. com/doc/ percona- xtrabackup/ 2.3/innobackupe x/improved_ ftwrl.html# waiting- for-queries- to-finish and https:/ /www.percona. com/doc/ percona- xtrabackup/ 2.3/innobackupe x/improved_ ftwrl.html# killing- the-blocking- queries