RESET MYSQL Password

To Reset the Password (Forgot Password)

service mysql stop

wait until MySQL shuts down. Then run

mysqld_safe --skip-grant-tables &

then you will be able to login as root with no password.

mysql -u root mysql

In MySQL command line prompt issue the following command:

UPDATE user SET password=PASSWORD("windowsxp123") WHERE user="root";
FLUSH PRIVILEGES;
EXIT