change mysql root password
If you have forgotten your mysql root password all you need is the root password of the system to create a new one.
First, stop mysql and then start it in the background with the skip-grant-tables parameter:
mysqld_safe --skip-grant-tables &
Then login to mysql as root (you don’t need a pass anymore)
mysql -uroot
and type the following:
mysql> use mysql;
mysql> update user set password=PASSWORD(your-new-root-pass) where User='root';
mysql> flush privileges;
Don’t forget to kill the mysql process when you are done and restart it properly.