Port setting not used in my.cnf

Question

I'm trying to store the credentials for the Percona XtraBackup tool in the /etc/my.cnf file as follows:

[xtrabackup]
target-dir=/backup
user=root
password=[password]
host=[local ip]
port=12345

When running:

extrabackup --backup /backup

I get:

Connecting to MySQL server host: [local ip], user: root, password: set, port: 3306

Everything is used except for the port which is ignored. What am I missing here? If I run extrabackup --backup /backup --port=12345 it does work as expected.

I was wondering why the downvote, I guess another troll. – Michael Zukowski Jan 05 '18 at 08:39 — Michael Zukowski, Jan 05 '18 at 08:39

score 1 · Accepted Answer · answered Jan 04 '18 at 22:48

1

Well as soon as I moved the file from /etc/my.cnf to /root/.my.cnf it started working.

answered Jan 04 '18 at 22:48

Michael Zukowski

109
6

Port setting not used in my.cnf

1 Answers1