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:\
eset.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
29 сен 2024