sudo yum install percona-xtrabackup-80

• libdev
• mariadb-connector-c
• perl-DBD-MySQL
• perl-DBI
• perl-Data-Dumper
• perl-Digest
• perl-Digest-MD5
• perl-Math-BigInt
• perl-Math-Complex
• rsync
• zstd

For 8.0 and above...

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY RANDOM PASSWORD;

For earlier versions...

CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 'MyC0mp!expA55wRd';

GRANT RELOAD ON *.* TO 'bkpuser'@'localhost';

GRANT LOCK TABLES ON *.* TO 'bkpuser'@'localhost';

GRANT REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';

GRANT CREATE TABLESPACE ON *.* TO 'bkpuser'@'localhost';

GRANT PROCESS ON *.* TO 'bkpuser'@'localhost';

GRANT SUPER ON *.* TO 'bkpuser'@'localhost';

GRANT CREATE ON *.* TO 'bkpuser'@'localhost';

GRANT ALTER ON *.* TO 'bkpuser'@'localhost';

GRANT INSERT ON *.* TO 'bkpuser'@'localhost';

GRANT SELECT ON *.* TO 'bkpuser'@'localhost';

For 8.0 and above, also include...

GRANT BACKUP_ADMIN ON *.* TO 'bkpuser'@'localhost';

GRANT SELECT ON performance_schema.log_status TO 'bkpuser'@'localhost';

GRANT SELECT ON performance_schema.keyring_component_status TO bkpuser@'localhost';

GRANT SELECT ON performance_schema.replication_group_members TO bkpuser@'localhost';

FLUSH PRIVILEGES;