08
Oct
09

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';
mysql> FLUSH PRIVILEGES;

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!

Advertisements

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

  • 226,733 hits

%d bloggers like this: