How to change the default database for one user in MySQL

Question

Though this might seem like a http://serverfault.com question at first glance I don't think it is.
I have a mysql database on a server at work. Every time I log in to execute a query, I have to manually select the one database I want from the one database I have, which is a waste of time. Is there any way for me as an end user to set a default?

Answer 1

In the user's home directory (e.g. ~username) create a file named .my.cnf, or add to the existing .my.cnf file a line like :

database=databasename-you-want-by-default

Here are the contents of a typical .my.cnf:

[client]
host=localhost
user=root
password=root
database=mygotodb