mysql –login-path connecting to the wrong database

Posted on

Question :

I have a strange problem with mysql and the –login-path option.
I have configurated multiple users and databases, some local and some remote using mysql_config_editor.

But since I had my last configuration it seems mysql –login-path=any_config_entry is always connecting to the last entered configuration as if I entered mysql –login-path=last_config_entry.

What could it be?

version is:
mysql Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using EditLine wrapper

Answer :

OK so I think I found the problem, I recently added an entry, and looking at my bash history I can see that I entered the information with set two times once without the –login-path resulting in creating an entry with the name client

after removing this entry with : mysql_config_editor remove –login-path client
all other configuration paths are working again.

Leave a Reply

Your email address will not be published. Required fields are marked *