MySQL forgot password cannot log in

1. Edit MySQL config file My.ini (in MySQL installation directory, my D:\Program files\mysql\mysql Server 5.0\my.ini), add a line under [mysqld] This entry Skip-grant-tables Save exit and restart MySQL;

2,cmd inside input mysql-u root-p, login MySQL;

3, Enter MySQL database :

mysql> use MySQL;
Database changed

4.to set a new password for the root user:
mysql> Update user set Password=password ("xxx") where user= "root";
Query OK, 1 rows affected (0.01 sec)
Rows matched:1 changed:1 warnings:0

5. Comment out the skip-grant-tables added in the 1th step save exit and restart

MySQL forgot password cannot log in