Recover MySQL 8.0 root Password

Stop the MySQL 8.0service from services


Run mysqld_safe --skip-grant-tables &
Open another session and run the following commands
mysql -u root 

select authentication_string,host from mysql.user where user='root';
update mysql.user set authentication_string='' where user='root';
flush privileges;
exit

Try to start the MySQL 8.0 service.
Connect using username as root & password as blank.


Change Password and relogging with new password.





Comments

Popular Posts