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