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:

cd /etc
ls -lrt my.cnf
chmod 700 .my.cnf
And put in it:
[client]
user=root
password=root123

And jut type MySQL u will able to login directly in MySQL prompt ...