Sometimes you want automated access for root on your MySQL database. One way of accomplishing that is by doing this:
/root
touch .my.cnf
chmod 640 .my.cnf
And put in it:
[client] user=root password=foobar
Tag: password
When you don’t know the current mysql root password and you want to change it, do this:
/etc/init.d/mysql stop mysqld --skip-grant-tables & mysql -p use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; flush privileges; quit; killall mysqld /etc/init.d/mysql start
Recent Comments