Forgotten/Reset mySQL Root Password

sudo /etc/init.d/mysql stop
sudo mysqld –skip-grant-tables &
mysql
mysql> use mysql;
mysql> INSERT INTO user VALUES (‘localhost’,'root’,password(‘newpassword’),’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',”,”,”,”,0,0,0,0);
mysql> INSERT INTO user VALUES (’127.0.0.1′,’root’,password(‘newpassword’),’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',”,”,”,”,0,0,0,0);
mysql> INSERT INTO user VALUES (‘the-hostname’,'root’,password(‘newpassword’),’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',’Y',”,”,”,”,0,0,0,0);
mysql>flush privileges;
mysql>quit
sudo killall mysqld
sudo /etc/init.d/mysql start

Tags:

categories Manual | rich July 15, 2010

RSS feed for comments on this post. TrackBack URI

Leave a Reply

You must be logged in to post a comment.