Windows:
1. log on to the system as a system administrator.
2. Stop MySQL services.
3. Enter the command window (CMD), and then enter the MySQL installation directory. For example, if my installation directory is C:/MySQL, enter C:/MySQL/bin.
4. Skip the permission check and start MySQL,
C:/MySQL/bin> mysqld-NT -- skip-grant-tables
5. Open a new cmd 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"
. Restart MySQL Server
Kill-9 MySQL process
Mysqld_safe -- user = MySQL -- skip-grants-table