Download and install -
WinSetView-Setup.exe
--skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting.shell> mysql
mysql>UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass')->WHERE User='root';mysql>FLUSH PRIVILEGES;
FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change.root using the new password. Stop the server, then restart it normally (without the --skip-grant-tables and --skip-networking options).