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
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.