The Temple of Fu

code, systems and games

Reset MySQL root password

with one comment

#service mysqld stop
#/usr/bin/mysqld_safe --skip-grant-tables &
#mysql --user=root mysql
mysql>update user set Password=PASSWORD('new-password-here') WHERE User='root';
mysql>flush privileges;

Kill the mysqld_safe process


Then restart MySQL
#service mysqld restart


Written by lordfu

March 20, 2010 at 11:25 pm

One Response

Subscribe to comments with RSS.

  1. […] I changed the root password to mysql. I searched the net to try and find the default pass but could not find one, so I did it like this. […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: