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:

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