I’ve run backups several times on our production server with:
xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/root/backups
and it worked fine, but now it’s demanding a password:
230316 12:38:49 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup’ (using password: NO).
Failed to connect to MySQL server: DBI connect(‘;mysql_read_default_group=xtrabackup’,‘’,…) failed: Access denied for user ‘root’@‘localhost’ (using password: NO) at - line 1315.
230316 12:38:49 Connecting to MySQL server host: localhost, user: not set, password: not set, port: not set, socket: not set
I’m certain that the database always had a root password set. How can this have happened ?