Reset MySQL Root Password

Reset MySQL Root Password

November 30, 2009 in SQL
Written by: Dag Jonny Nedrelid

If you have mysql- or root user shell access to the linux host where your mysql is running, you can reset the password like this:




(Debian based example).

First, stop the daemon:

#/etc/init.d/mysqld stop

Second, start mysql without privileges:

#mysqld --skip-grant-tables &

Third, connect to the daemon and make changes:

#mysql
#UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE User='root';
#FLUSH PRIVILEGES;
#quit

Now stop the daemon and start it normally:

#/etc/init.d/mysql stop
#/etc/init.d/mysql start

It might be sufficient with a simple restart, but I like it the explicit way to be sure.

For more information on this subject, visit the official MySQL reference:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix

Leave a Reply





Welcome to Thronic.com

My name is Dag Jonny Nedrelid. I'm an IT consultant and computer programmer who lives in Southern Norway. Computers have been one of my hobbies and line of work since 1995.

If you want to contact me, you can send me an e-mail. My e-mail address