saved password in config files are NOT honored

[georgi iovchev]

Hello

Recently I have updated mydumper to latest version from master branch https://github.com/maxbube/mydumper
And I noted that mydumper has stopped to read saved password in config files.

How to repeat:
# Safe password in .mylogin.cnf
$ mysql_config_editor set --password

# Test that password is working
$ mysql --host=127.0.0.1 mysql -NBe"select 1"
1

# Try to make mydumper backup
$ mydumper --host=127.0.0.1 --database=mysql --no-data --outputdir=/tmp/test

** (mydumper:25094): CRITICAL **: Error connecting to database: Access denied for user 'root'@'127.0.0.1' (using password: NO)

I have tested with centos 7.2 x64, mysql community 5.6.34.

Additional findings:

I have found out that this bug is introduced in "Commits on Oct 10, 2016 / correct 'this ‘if’ clause does not guard' error when using make" (https://github.com/maxbube/mydumper/archive/a59526b12f2cdbc29575883848d3670f42af4c7c.zip).
All versions after this commit are affected.

Latest non affected version is: https://github.com/maxbube/mydumper/archive/ca44245c33b714e939dd80f71f20170137011a95.zip

Regards,
Georgi

[Max Bubenick (max-bubenick)]

Hi Georgi,

I've confirmed this bug and It must be fixed on this PR https://github.com/maxbube/mydumper/pull/21 I will merge it after a few more tests.

[James (lixtic7)]

Hi Max,

I am trying to run mydumper with Mysql_config_editor and I keep getting this error below

** (mydumper:5847): CRITICAL **: Error connecting to database: Access denied for user 'ec2-user'@'localhost' (using password: NO)