If you missed your mysql root user password, then here are the steps to reset it:
- stop mysql server
service mysqld stop - make sure all mysql process are dead
ps -A | grep mysql - start mysqld in safe mode
mysqld_safe –skip-grant-tables - open a new shell window and start mysqld
service mysqld start - access mysql database
mysql -u root mysql - reset password of root user
update user set Password=PASSWORD(‘yournewpassword’) where user=’root’; - stop mysqld_safe and restart mysql server
service mysqld restart.
Happy Administration!
