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 »
By halfgaar, 2 years ago, on August 11, 2010, at 09:08 | No comments

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 »
By halfgaar, 2 years ago, on January 11, 2010, at 14:01 | No comments