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 [...]
