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 /root
# touch .my.cnf
# chmod 640 .my.cnf
And put in it:
password=<password of mysql root user>
Once you have done the following steps, the root user can login to mysql as root user without giving password.
root@server [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 749
Server version: 5.1.68-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.