Thursday 19 September 2013

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 ...