# xtrabackup method does not honor user=mysql in my.cnf

**URL:** <https://forums.percona.com/t/xtrabackup-method-does-not-honor-user-mysql-in-my-cnf/2454>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [July 27, 2012, 6:10am UTC](https://forums.percona.com/t/xtrabackup-method-does-not-honor-user-mysql-in-my-cnf/2454 "2012-07-27T06:10:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tinhtruong](https://avatars.discourse-cdn.com/v4/letter/t/2acd7d/32.png) [@tinhtruong](https://forums.percona.com/u/tinhtruong)\
**Post date:** [July 27, 2012, 6:10am UTC](https://forums.percona.com/t/xtrabackup-method-does-not-honor-user-mysql-in-my-cnf/2454/1 "2012-07-27T06:10:49Z")

</div>

I have setup a Percona XtraDB Cluster Percona-XtraDB-Cluster-server 5.5.24-23.6.340.rhel6 (CentOS 6.3 AWS EC2) on two nodes (will change to 3 when everything works properly). Here is my.cnf on the first node:

[mysqld]datadir=/data/mysql-datauser=mysqlserver\_id=1binlog\_format=ROWwsrep\_provider=/usr/lib64/libgalera\_smm.sowsrep\_cluster\_address=gcomm://wsrep\_slave\_threads=2wsrep\_cluster\_name=a-clusterwsrep\_sst\_method=xtrabackupwsrep\_node\_name=db-prod-1innodb\_locks\_unsafe\_for\_binlog=1innodb\_autoinc\_lock\_mode=2innodb\_buffer\_pool\_size=400Minnodb\_log\_file\_size=64M

The configuration worked fine when I set wsrep\_sst\_method to rsync on both nodes, but when I change to xtrabackup, I could start the first node but failed with the second node. I check the innobackupex.backup.log file on the first node and see this:

120727 09:59:23 innobackupex: Starting mysql with options: --unbuffered --120727 09:59:23 innobackupex: Connected to database with mysql child process (pid=10606)innobackupex: Error: mysql child process has died: ERROR 1045 (28000): Access denied for user ‘ec2-user’@‘localhost’ (using password: NO)

Why innobackupex use ‘ec2-user’ (this is one of the system user, this user is in the sudoer list, and start the mysql with the command ‘sudo service mysql start’) instead of ‘mysql’ (configured in my.cnf)? Is it a bug?  
Btw, I did not see any documentation on how to specify the password for the user used by xtrabackup to connect with mysql for backup.

Any hint would be appreciated.  
Thanks.

---

<div class="post-metadata">

**Author:** ![tinhtruong](https://avatars.discourse-cdn.com/v4/letter/t/2acd7d/32.png) [@tinhtruong](https://forums.percona.com/u/tinhtruong)\
**Post date:** [August 1, 2012, 6:17am UTC](https://forums.percona.com/t/xtrabackup-method-does-not-honor-user-mysql-in-my-cnf/2454/2 "2012-08-01T06:17:16Z")

</div>

Anyone?

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [August 14, 2012, 2:59am UTC](https://forums.percona.com/t/xtrabackup-method-does-not-honor-user-mysql-in-my-cnf/2454/3 "2012-08-14T02:59:54Z")

</div>

Hi,

You need to provide to the SST script (in this case xtrabackup) the credentials.

You can do this by adding in my.cnf ([mysqld] section) the following:

wsrep\_sst\_auth=root:password

Regards,