Change MySQL root password
This is the 'hands-on' way of changing the root password for your MySQL server. Get to a command prompt on the MySQL server and enter the following commands:
mysql -u root mysql
> UPDATE user SET password=password('secret') WHERE user='root';
> flush privileges;
This should reset the password for you and then you can log in and get some real work done.
