[nycbug-talk] mysql client and .my.cnf

[Okan Demirmen]

hi all - 

so i'm curious as to how other people deal with ~/.my.cnf and multiple
hosts/databases/usernames. for example i have:

hostname=db01.example.com
database=my_first_database
username=first_database_user

hostname=db02.example.com
database=my_next_database
username=next_database_user

hostname=db99.example.com
database=my_other_database
username=other_database_user

...etc...

now, i'd *love* to see an ssh_config(5) style to .my.cnf (or heck if
mysql likes this ini style, then something like isakmpd.conf(5) would
work too), but for now i'm using multiple .my.cnf.${db} files with the
relevant info and shell aliases for each and such...i don't like it much
- kinda messy...

what does everyone else do?

cheers,
okan