Skip to content

Instantly share code, notes, and snippets.

@i-amolo

i-amolo/reset-mysql-8-root-password-windows.md

Forked from pishangujeniya/reset-mysql-8-root-password-windows.md
Created October 29, 2021 09:07
Show Gist options
  • Save i-amolo/6af4741638fc8095e36cc72ef45cca00 to your computer and use it in GitHub Desktop.
Save i-amolo/6af4741638fc8095e36cc72ef45cca00 to your computer and use it in GitHub Desktop.
Download ZIP
Reset MySQL 8.0 root Password in Windows
Raw
reset-mysql-8-root-password-windows.md

Reset MySQL 8.0 root Password in Windows

  1. Stop the MySQL 8.0service from services
  2. Go to path C:\Program Files\MySQL\MySQL Server 8.0\bin and open cmd
  3. Run mysqld --console --skip-grant-tables --shared-memory
  4. Open new cmd in the same path
  5. Run following commands
  6. mysql -u root
  7. select authentication_string,host from mysql.user where user='root';
  8. UPDATE mysql.user SET authentication_string='' WHERE user='root';
  9. Now close both the cmd.
  10. Try to start the MySQL 8.0 service.
  11. Connect using username as root & password as blank.
  12. Change the password from the user managerment.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment