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:
Then login to mysql as root (you don’t need a pass anymore)
and type the following:
Don’t forget to kill the mysql process when you are done and restart it properly.