Give .my.cnf to mysql command line

Question

How to give a specific .my.cnf config file to the mysql command line?

$ mysql --my-config=.my.cnf

Solution 1

The --defaults-file option lets you specify which options file you want to use. It would be a good idea to give it the full path to your options file.

mysql --defaults-file=/home/user/.my.cnf database

Solution 2

In here: http://dev.mysql.com/doc/refman/5.5/en/option-files.html it says you can also specify "defaults-extra-file" for additional params. Otherwise it defaults to the various my.cnf (depending on OS).