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, go to 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