How to recover lost MySQL passwords (win * win:
Windows:
1. log on to the system as a system administrator.
2. stop MySQL services.
3. go to the command window and enter the MySQL installation directory. for example, if my installation directory is c:/mysql, go to C:/mysql/bin.
4. skip the permission check and start MySQL,
C:/mysql/bin> mysqld-nt-skip-grant-tables
5. open a new window, enter the c:/mysql/bin directory, and set the new root password.
C:/mysql/bin> mysqladmin-u root flush-privileges password "newpassword"
C:/mysql/bin> mysqladmin-u root-p shutdown
Replace newpassword with the root password you want to use. the second command will prompt you to enter a new password and repeat the password entered by the first command.
6. stop MySQL Server and start Mysql in normal mode
7. You can use a new password to link to Mysql.
Unix & Linux:
1. log on to the system using root or a user running mysqld;
2. use the kill command to end the mysqld process;
3. use the-skip-grant-tables parameter to start MySQL Server
Shell> mysqld_safe-skip-grant-tables &
4. set a new password for root @ localhost
Shell> mysqladmin-u root flush-privileges password "newpassword" 5. restart MySQL Server