Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27867

missing required privilege REPLICATION CLIENT by /usr/bin/mariabackup

    XMLWordPrintable

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

          Activity

            People

              danblack Daniel Black
              testjetco Test Jetco
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.