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
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.1\my.ini" --init-file=C:\\reset.txt


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

Post changing your password you can delete the reset.txt file for security reason.


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

• #education
• #mysql_root_password
• #mysql_forgotten_password_reset
• #root_password_for_mysql
• #how_to_reset_root_password_in_mysql
• #steps_for_resetting_mysql_root_password
• #reset_mysql_forgotten_root_password
• #mysql_root
• #root_password_reset_in_mysql_windows_11
• #reset_mysql_root_password_in_windows_11
• #change_root_password_in_mysql_in_window
• #change_mysql_root_password
• #mysql_password_forgot
• #how_to_reset_mysql_root_password
• #forgot_mysql_root_password