Connecting to MySQL server host: localhost, user: (null), password: not set but trying to connect with root
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
| 2.3 |
Fix Released
|
Low
|
Sergei Glushchenko | |||
| 2.4 |
Fix Released
|
Low
|
Sergei Glushchenko | |||
Bug Description
Testing branch -> https:/
If user info specified like, i.e not specified:
[client]
#user = root
#password = msandbox
[mysqld]
#user = sh
#port = 5632
[xtrabackup]
#user=msandbox
#password=msandbox
Running backup command:
sh@sh-ubuntu:
170110 13:13:27 Connecting to MySQL server host: localhost, user: (null), password: not set, port: 5632, socket: /tmp/mysql_
Failed to connect to MySQL server: Access denied for user 'root'@'localhost' (using password: NO).
Result -> user is null and password is not set, but it is trying to connect using 'root'.
| Sergei Glushchenko (sergei.glushchenko) wrote | #1 |
| Sergei Glushchenko (sergei.glushchenko) wrote | #2 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
The behaviour is correct and it matches mysql client behavoiur. When user is not set, xtrabackup is trying connect with current system useer. You probably ran xtrabackup as root.
Keeping this report as request to replace "user: (null)" part of the message with "user: not set" message.