Details
Description
I am using mariadb 10.7.3. I tried to perform db backup using '/usr/bin/mariabackup' by user other than root.
/usr/bin/mariabackup --backup -umariadbbackup -pxxxxxx --binlog-info=on --databases=all -h /mysql --galera-info --target-dir=/backup/`hostname`-mariadb-backup-${DATEVAR}
|
I have granted the following privileges to the backup db user, mariadbbackup:
> show grants for "mariadbbackup"@"localhost";
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for mariadbbackup@localhost |
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT SELECT, RELOAD, PROCESS, SHOW DATABASES, LOCK TABLES, BINLOG MONITOR, SHOW VIEW, EVENT, SLAVE MONITOR ON *.* TO `mariadbbackup`@`localhost` IDENTIFIED BY PASSWORD '......' |
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
After backup, I reviewed the backup log and found the following statement:
Warning: missing required privilege REPLICATION CLIENT on .
/usr/bin/mariabackup based on MariaDB server 10.7.3-MariaDB Linux (x86_64)
I have already granted 'REPLICATION CLIENT' but it didn't show up after using 'show grant' command. I already have both BINLOG MONITOR and REPLICA MONITOR privileges granted. But still the warning message appears.
How should I solve this issue?
Attachments
Issue Links
- relates to
-
MDEV-23607 Warning: missing required privilege REPLICATION CLIENT
-
- Closed
-