reset mysql root password

I just read a great post by Cody Taylor at http://codytaylor.org/2009/10/reset-mysql-root-password-on-linux.html about reseting a mysql root password. Basically, all you need to do is start the daemon using this command ( remember to stop it first ) :

sudo mysqld_safe --skip-grant-tables --skip-networking

Next, connect using the root user :

mysql -u root mysql

and modify the password:

mysql> UPDATE user SET Password=PASSWORD('password') WHERE User='root';

You can read the full post at http://codytaylor.org/2009/10/reset-mysql-root-password-on-linux.html.

Thanks for the great post, Cody!


0 Responses to “reset mysql root password”

  1. Leave a Comment

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog Stats

  • 231,109 hits

%d bloggers like this: