Xtrabackup 8.0.14 - MySQL 8.0.21 - Access denied for user 'backup'@'localhost'

MySQL & MariaDB Percona XtraBackup
1

Hi to all,
I can’t generate a backup using xtrabackup and defaults_file

I’ve generate an backup user with these grants:

GRANT SELECT, INSERT, CREATE, RELOAD, PROCESS, SUPER, LOCK TABLES, REPLICATION CLIENT, CREATE TABLESPACE ON *.* TO `backup`@`localhost`
GRANT BACKUP_ADMIN ON *.* TO `backup`@`localhost`

as show in this post.
As requird in the post, I also generated the /etc/mysql/backup.cnf and the /usr/local/bin/backup-mysql.sh.

The only difference is that in this phase of dev, i decide to do not use the encrypt .

I can connect to mysql server using the backup user, by the mysql command:

[backup@dadi ~]$ mysql -u backup -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 244
Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

So i don’t understand because xtrabackup don’t accept the connect by backup.cnf and give me this error:
Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','backup',...) failed: Access denied for user 'backup'@'localhost' (using password: YES) at - line 1536.

Thanks

Stefano G.

1 Like