Stop the MySQL 8.0service from services
Go to path C:\Program Files\MySQL\MySQL Server 8.0\bin and open cmd
Run mysqld –console –skip-grant-tables –shared-memory
Open new cmd in the same path
Run following commands
mysql -u root
select authentication_string,host from mysql.user where user=‘root’;
UPDATE mysql.user SET authentication_string='' WHERE user=‘root’;
Now close both the cmd.
Try to start the MySQL 8.0 service.
Connect using username as root & password as blank.
Change the password from the user managerment.
