MySQL Forums
Forum List  »  Security

Re: Cannot make mysql client read the password form .mylogin.cnf
Posted by: Todd Farmer
Date: April 14, 2015 09:33AM

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot make mysql client read the password form .mylogin.cnf
2350
April 14, 2015 09:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.