Skip to content

Tag: password

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: Read More »

Changing lost MySQL root 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 Read More »