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:\
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
Пікірлер: 47
this works thanks! had me frustrated for awhile
@InfoAlias
3 күн бұрын
Good to know... 👍
It really works, thanks bro 👍
@InfoAlias
8 ай бұрын
Welcome 👍 and good to know your problem has been fixed please subscribe and share with others....
Thank you Sir! I succesfully changed my root password
@InfoAlias
3 ай бұрын
Happy to help
Thank you so much sir!
@InfoAlias
3 ай бұрын
Thanks for watching this, kindly share with others and subscribe
Very useful..👍👍
@InfoAlias
11 ай бұрын
Thanks a lot
THANK YOU VERY MUCHH SIR I HAVE ASSIGNMENT THAT NEED TO BE COMPLETED IN 3 HOURS THIS IS REALLY HELPFUL
@InfoAlias
Ай бұрын
Best of luck for your assignment........................
Thank you!
@InfoAlias
Ай бұрын
Thanks for watching this video. Kindly share with others.
👍👍👍
thank you so much
@InfoAlias
5 ай бұрын
Thanks for watching. Please share with your friends and please subscribe for upcoming tech videos
thanks sir
@InfoAlias
4 ай бұрын
Most welcome, please subscribe and share with others
thanks
@InfoAlias
2 ай бұрын
You're welcome! Good know your issue has been fixed. Kindly subscribe and share with others.
Thanks a lot
@InfoAlias
10 ай бұрын
Happy to help, Please share with others as well for subscribing my channel.
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
@etc_sushantdhavane9448
5 ай бұрын
same problem
@InfoAlias
5 ай бұрын
Can you share the MySQL installation path from your system
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
@InfoAlias
4 ай бұрын
Hope you have stopped service and doing it these whole process with admin account, watch this video from begining only
@zahramustafa5656
2 ай бұрын
Same issue, can you please help, I followed the entire process
@NarutoUzumaki-mg8yd
2 ай бұрын
same issue pls help
@InfoAlias
2 ай бұрын
@@zahramustafa5656 follow the instructions carefully, this will work and its tested
@InfoAlias
4 күн бұрын
You need to open the cmd with run as administrator
"C:\Program Files\MySQL\MySQL Server 8.0\bin\Mysqld" MySQL (My path to executable is showing only this portion ......)
@InfoAlias
8 ай бұрын
Watch the complete video carefully. This should be similar like in this video. Try to copy the path from service this is what I did in this video.. Thanks
Its showing this "Access denied for user error 1045" How to solve this
@InfoAlias
5 ай бұрын
Check Account Permissions: Verify that the service is configured to run under an account with the necessary permissions. If the account lacks the required privileges, it might result in the service failure.
In services me can't show mysql8.0 then what should I do?
@InfoAlias
5 ай бұрын
Can you please share the path exactly from service
@riddhijadav6196
5 ай бұрын
C:\ProgramData\MySOL\MySQL Server 8.0 and it's already show that exists
@InfoAlias
5 ай бұрын
Please watch the video carefully , this will fix your issue, Even you can read the description of this video as well, @@riddhijadav6196
@DorivalAfonsoCardoso
9 күн бұрын
dont worked in my mysql8.0 too.. :(
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld--defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file=C:\ eset.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
@InfoAlias
5 ай бұрын
there is a space between mysqld and --defaults, Just go through the description and perform the task accordingly.
dont worked in my mysql8.0
@InfoAlias
8 күн бұрын
try to follow the complete steps . This will work for 8.0 as well.
not working
@InfoAlias
4 ай бұрын
tell me the error