Hi,
I have been trying to use the XtraBackup to perform backup on my Percona server (5.5). I’m using Ubuntu 14.04 LTS.
When i run this command - xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/
data/backups/mysql/
…i get the following error.
root@mysite:~# xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/
data/backups/mysql/
160218 14:57:16 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;m
ysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld
.sock’ as ‘mysql’ (using password: NO).
Failed to connect to MySQL server: DBI connect(’;mysql_read_default_group=xtraba
ckup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock’,‘mysql’,…) failed: Ac
cess denied for user ‘mysql’@‘localhost’ (using password: NO) at - line 1314.
160218 14:57:16 Connecting to MySQL server host: localhost, user: mysql, passwor
d: not set, port: 3306, socket: /var/run/mysqld/mysqld.sock
Failed to connect to MySQL server: Access denied for user ‘mysql’@‘localhost’ (u
sing password: NO).
Any ideas?
Thanks.