Skip to content

Instantly share code, notes, and snippets.

@pishangujeniya

pishangujeniya/reset-mysql-8-root-password-windows.md

Created December 5, 2019 18:04
Show Gist options
  • Save pishangujeniya/0f839d11a7e692dadc49821c274a2394 to your computer and use it in GitHub Desktop.
Save pishangujeniya/0f839d11a7e692dadc49821c274a2394 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.
@pishangujeniya
Copy link
Author

pishangujeniya commented Oct 29, 2022 •
edited
Loading

@PhaniKumarDasika You need have a data folder inside C:\Program Files\MySQL\MySQL Server 8.0\ this path. ref

@llleixx
Copy link

llleixx commented Oct 18, 2023

Fails on mysql -u root with ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

Don't close the previous cmd.

@pishangujeniya
Copy link
Author

Fails on mysql -u root with ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

Don't close the previous cmd.

Refere this

@kotorkovsciy
Copy link

Thank you so much

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment