As follow-up, Xtrabackup should ignore user under [mysqld] because this user is not a MySQL server's user, it is a system user, which will own the MySQL process while starting, i.e MySQL server will start under that user. http://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
In contrast the user under [client] is for client connection.
[client]
user = xtrbackup
[mysqld]
user = mysql
It is especially affected while doing some test in Jenkins. There will be no 'root' in jenkins, the default is 'jenkins' system user.
As follow-up, Xtrabackup should ignore user under [mysqld] because this user is not a MySQL server's user, it is a system user, which will own the MySQL process while starting, i.e MySQL server will start under that user. dev.mysql. com/doc/ refman/ 5.7/en/ changing- mysql-user. html
http://
In contrast the user under [client] is for client connection.
[client]
user = xtrbackup
[mysqld]
user = mysql
It is especially affected while doing some test in Jenkins. There will be no 'root' in jenkins, the default is 'jenkins' system user.
[client] /tmp/mysql. sock /mnt/workspace/ PTB-run- percona- server- 5.6-pxb- 2.3.5-2. 4.4/Host/ centos7- 64/Percona- Server- 5.6.33- rel79.0- Linux.x86_ 64.ssl101 /mnt/workspace/ PTB-run- percona- server- 5.6-pxb- 2.3.5-2. 4.4/Host/ centos7- 64/mnt/ var/ps_ 5.6.33_ sysbench/ test-0/ mysql.1/ data /mnt/workspace/ PTB-run- percona- server- 5.6-pxb- 2.3.5-2. 4.4/Host/ centos7- 64/mnt/ var/ps_ 5.6.33_ sysbench/ test-0/ mysql.1/ tmp /tmp/mysql. sock /mnt/workspace/ PTB-run- percona- server- 5.6-pxb- 2.3.5-2. 4.4/Host/ centos7- 64/mnt/ var/ps_ 5.6.33_ sysbench/ test-0/ mysql.1/ mysql.pid log-file= /mnt/workspace/ PTB-run- percona- server- 5.6-pxb- 2.3.5-2. 4.4/Host/ centos7- 64/mnt/ var/ps_ 5.6.33_ sysbench/ test-0/ mysql.1/ query.log
port=10000
socket=
user=root
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
console
user=jenkins
server-id=1
general-
Temporary workaround was to create 'jenkins' user for MySQL.