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
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.
Connect using username as root & password as blank.
Change Password and relogging with new password.
Comments
Post a Comment