save mysql logins

Question

I have to log into multiple MYSQL DB's on different hosts via mysql cli. is it possible to save these logins so I don't have to trackdown/remember the credentials?

Answer 1

Based on a discussion at http://bugs.mysql.com/bug.php?id=17627 I use the following method to automatically log into different mysql servers:

File /path/to/my-host1-cnf.txt

[client]
host="hostname1"
user="username1"
password="password1"
database="database1"

File /path/to/my-host2-cnf.txt

[client]
host="hostname2"
user="username2"
password="password2"
database="database2"

Connect to host1, database1 with saved credentials above:

mysql --defaults-file="/path/to/my-host1-cnf.txt"

Connect to host2, database2 with saved credentials above:

mysql --defaults-file="/path/to/my-host2-cnf.txt"

Hope this helps :-)