Re: Cannot make mysql client read the password form .mylogin.cnf

[Todd Farmer]

Hi Lefteris,

I can't recreate the problem you describe:

R:\>bin\mysql_config_editor.exe set --user=root --password --host=localhost
Enter password: *******
WARNING : 'client' path already exists and will be overwritten.
Continue? (Press y|Y for Yes, any other key for No) : y

R:\>bin\mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

R:\4>bin\mysql -P3310
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

As you can see, the password is being used when I attempt to connect.

What version are you using?

Can you try using an explicit login-path, as below?

R:\>bin\mysql_config_editor.exe set --user=root --password --host=localhost --login-path=tf
Enter password: *******

R:\>bin\mysql --login-path=tf -P3310
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/