Setting password for mysql user in .my.cnf

Sometimes you want automated access for root on your MySQL database. One way of accomplishing that is by doing this:

/root
touch .my.cnf
chmod 640 .my.cnf

And put in it:

[client]
user=root
password=foobar