My SQL Password Reset

I was in a situation where we need to backup of a MySql database that was created a long time ago and no one was aware of the password and we need to reset it.
Please follow the following steps, the MySql version is 5.5 on windows server 2012

Open Run and type services.msc
My-SQL-Password-Reset-3

Find the service related to MySql and Stop the service
My-SQL-Password-Reset-1

Make a note of the defaults file which in this case is my.ini
My-SQL-Password-Reset-2

"C:/Program Files/MySQL/MySQL Server 5.5/bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.5\my.ini" MySQL

Create a text file with the following text in c:\reset.txt

USE mysql;
UPDATE mysql.user SET Password = PASSWORD("P@ssword") WHERE User='root';
FLUSH PRIVILEGES;

Open command prompt and key installation location in my case it is

"C:/Program Files/MySQL/MySQL Server 5.5/bin"

Execute the following command

mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.5\my.ini" --init-file="c:\reset.txt"

Photo by Taylor Vick on Unsplash