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

No comments:

Post a Comment