Reset mysql root password
- January 29, 2014
Back
EDUCATION DETAIL
Have you ever forgotten the root password on one of your MySQL servers? No? Well maybe I’m not as perfect as you. This is a quick h00tow (how to) reset your MySQL root password. It does require root access on your server. If you have forgotten that password wait for another article.
First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
mysqld_safe --skip-grant-tables
You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
mysql --user=root mysql
set password for 'root'@'[host]' = password('new-password');
Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.
Notes : If you are using remote application like putty, you must have two session of putty, one for running mysqld_safe --skip-grant-tables and other for update root password
Source : http://www.cmdln.org/2008/02/09/reset-mysql-root-password/