MySQL Forgotten Root password reset

In this video, I have explained the process for resetting the root password for MySQL. for resetting the root password I have used a txt file where I have mentioned the command
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yournewpassword';

and executed the below command on CMD with run as administrator on My sql installation path C:\Program Files\MySQL\MySQL Server 8.1\bin\

Command

after few seconds just press Ctrl + c and try to access your MySQL with new password which is written in your txt file.

#windows11
#windows10
#windows
#windows11mix
#mysql
#mysqldba #databasemanagementsystem
#windows

[todorhristov]

I get "C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 8.0\my.ini" --init-file="C:\\reset.txt
mysqld: [ERROR] Failed to open required defaults file: C:\Program Files\MySQL\MySQL Server 8.0\my.ini
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!"
I don`t have my.ini file in mySQL Server 8.0 folder what is it for and is it important ? Should i just cut the command to mySQL Server 8.0 and be done ?

[hinduja.b]

Excuse me, sir. Two years ago, I downloaded MySQL, but I have forgotten the current password. I have uninstalled and reinstalled it several times, but it keeps asking for the current password. I watched your video, and the first step you mentioned was to stop the service, but I cannot find the MySQL service option on my system....please give me one solution sir

[PranavRathod-hm]

'mysqld' is not recognized as an internal or external command,
operable program or batch file.
above error is coming how to solve?

[jeremydavidson]

this works thanks! had me frustrated for awhile

[basvanzutphen]

Thank you Sir! I succesfully changed my root password

[viniemeralda]

THANK YOU VERY MUCHH SIR I HAVE ASSIGNMENT THAT NEED TO BE COMPLETED IN 3 HOURS THIS IS REALLY HELPFUL

[veetoria-toms]

Hi, thank you for your video, but how do I create the text file to input the new password? I can't seem to get it 😢

[veetoria-toms]

Hi again!!

I'm having a error msg
"Access denied for user (using password: YES)

[bronwynrojas]

Mine still doesnt work :/ It says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" even though i typed in the new password correctly

[vadlamudirakesh]

Create root password doesn't show me when i install my sql workbench now the database connection also not established now it shows connection error, Now how to connect database connection to my work bench and root password also i didnt create root password while instal work bench

[Ritu-TheWinner]

C:\Program Files\MySQL\MySQL Server Server 8.0\my.ini" --init-file=C:\\reset.txt
'mysqld--defaults-file' is not recognized as an internal or external command,
operable program or batch file.

Could you pls help...thx in advance

[prashantkumar-ekim]

"C:\Program Files\MySQL\MySQL Server 8.0\bin\Mysqld" MySQL (My path to executable is showing only this portion

[yyijvnn]

Its showing this "Access denied for user error 1045"
How to solve this

[riddhijadav]

In services me can't show mysql8.0 then what should I do?

[afnanali]

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)