Archive for the 'mysql' Category

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!




Blog Stats

  • 223,848 hits