How to Reset MySQL Workbench Password (Forgot Password) on Windows

 Follow the below steps to Reset your MySQL Workbench root password.

Step 1: Open Services from Start Menu and Search for MySQL and Stop the Service

Step 2: Create mysql-init.txt file in your local with the following text:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password'

Step 3: Copy the Location - C:\ProgramFiles\MySQL\SQL Server\bin

Open Command Prompt:

cd location of bin 

Step 4: Open "Program Data" in C drive and Go to SQL Server and Check for my.ini file

Switch to Command Prompt

Enter the below command with your file locations:

mysqld --defaults-file="C:\ProgramData\Server\my.ini --init-file=location\mysql-init.txt

Press Enter

Step 5: Open Task Manager and Select Window Command Processor

Right Click and Select End Task

Step 6: Open Services and Start MySQL Server

Step 7: Open Command Prompt

Enter the below command:

mysql -u root -p

Enter Password: (Enter the password provided in the mysql-init.txt file)

Now you should be able to log in to MySQL Workbench using the new password you've set.