How to Reset MySQL Root Password on Windows [WORKING!!]
HTML-код
- Опубликовано: 5 сен 2024
- In this video, I'm going to show you how to reset your MySQL password if you have forgotten it or was not prompted to setup it up while installing.
You don't need to remember the OLD password for changing to a new one!
So watch this video till the end and don't skip in between!!.
This video has all the proper ways to reset your MySQL root password on windows if you have forgotten your root password
✻ Please click on the CC button to read the subtitles of this video.
✻I hope by following my video you're able to reset your forgotten password♥
✅Subscribe to my Channel to learn more about Computer Programming, computer tools, and technologies.
Thanks for watching my videos till the end, if you like my work please do Like, Comment, and Share!!
----------------------------------------------
Timestamp:
00:18- Introduction
00:20 -Stopping MySQL Services
01:25- Query for changing MySQL Root Password
02:01-Save the query file
02:19-Opening cmd in administrator mode
02:35-Changing path of command prompt
03:13- mysqld command for changing your password
03:38-Locate ProgramData folder for the my.ini file
04:44- Command Executed Successfully
05:07 - Checking whether cmd working or not!
05:56- Restarting MySQL Services
06:52-Conclusion
-----------------------------------------------------------------------
Channel Subscription:
🔗 / cscornersunitarai
Java Programming Tutorial Playlist
🔗 • Java Programming Tutorial
Advanced Java Tutorial Playlist
🔗 • Advanced Java Tutorial
------------------------------------------------------------------------
🎥 Tools I used for recording
www.amazon.in/...
🌍🌍$$$**Want To Become a SUCCESSFUL RUclipsr please join FREE Webinar ***$$$🌍🌍
digitalachieve...
------------------------------------------------------------------------
CONNECT WITH ME ON:
►Facebook - / cscornersunitarai
►Personal Facebook A/c - / sunita.sharmarai
►Instagram - / cscornersunitarai
►Telegram - t.me/cscorners...
►LinkedIn - / cscornersunitarai
------------------------------------------------------------------------
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps supports the channel and allows us to continue to make videos like this. Thank you for the support!
how to reset mysql password,how to reset mysql password on windows,reset mysql root password windows,forgot mysql password,how to reset mysql root password,how to reset mysql root password on windows,forgot mysql root password,forgot mysql password on windows,forgot mysql root password on windows,reset mysql password,reset mysql root password,reset mysql password on windows,reset mysql root password on windows,reset mysql root password on windows 10,reset password
===============================
MySQL closes on entering password?
===============================
I have provided you the possible solution. Please read it carefully still if you facing a problem
*_Please share through comments or reach us on telegram _**_t.me/cscorner_*
This means that the password you entered is incorrect.
Possible solutions:
1. Passwords are Case-sensitive. So make sure to check caps lock and num lock on your keyboard while entering the password.
2. Check the change.txt for the password that you've set. Enter that same password in the MySQL cmd line client.
3. Make sure that you've stopped the MySQL service first, as I've done in the video. If u skip this, your password won't reset.
4. Check that the change.txt has exact same thing that I've shown in the video.
5. Also make sure that cmd opened is in administrator mode, else it will show you an error( error message I have given in my video).
6. If these don't work, watch the video from start to end without skipping.. possibly you might have missed a few steps and details.
========
Important
========
If you get an error while doing the steps, or you face any problems, please recheck all the commands, all the steps, and everything in the video thoroughly!
There could be a small unnoticeable error that might waste your time!! Save your time by watching the video completely.
It's showing that" The file name, directory name, or volume label syntax is incorrect ".. What can i do now?? 😢
I cannot thank you enough Sunita mam, I wasted all my time for finding the solution until this video. Everything was crystal clear. ♥
Glad it helped! Keep watching
@@CSCORNERSunitaRaii forgot MySQL password in Mac os. How can I get my password now
@@CSCORNERSunitaRai i forgot my password how to reget it or rechange the password
I have watched so many tutorials, have read so many stuff on stack overflow, and THIS was the one that finally worked, thank you very very much!
Glad my video helped you👍 keep watching
@@CSCORNERSunitaRai
kya comment karu comment reply nhi ata...well reset ho gya
After getting stuck by 3 to 4 tuts. Finally your video really helps me a lot! Thank you ma'am, keep this good work going..
🤩glad my video helped you👍keep watching
bro i had same prolem help im not getting
mam merko ek problem aarahi h
@@CSCORNERSunitaRai
I wasted lot of time by searching videos on RUclips to fix forgot password problem but none of them worked
But your video helped me to resolve the problem
Thank u mam
Glad to hear that!!
You're welcome 👍please subscribe 😊
thank you so much. I have zero coding background and just started with Google data analytics. I set up MySQL on my system a few months back and forgot to put down the password. Thank you so much once again for the awesome guide. Notification turned on.
That's great my video helped you👍 please subscribe
You are a saint! I've spent the past hour wrestling with this issue. Even the main MySQL website documentation wasn't helping. Thank you!
Thank you so much for your words😊👍Please subscribe
It was great help for me, a novice in this area. You have guided end-to-end in an excellent manner. Thanks and keep it up.
Glad to hear that!
You're welcome😊please subscribe👍
maam u have saved my computer science practical file, all my sql documents were stored on my computer server and i had forgotten the password thank you so much maam from the bottom of my heart
Glad you liked it.. plz subscribe
Forget my root password and I tried several ways to recover it but still failed. Until I found this video. It is very helpful, informative and easy to follow. Thanks for sharing the video madam!
Wow! Glad to know that👍 Keep watching
You're amazing. I watched many videos but I got the same error you displayed on your video. Thanks a lot, I fixed it with your great help.
Glad it helped!
You're welcome 👍 Please subscribe😊
I spent so much time reading different complicated explanations. Found your demo extremely helpful. Thank you Sunita! from your neighbor (PK).
Wonderful!
Glad my video helped you☺
Stay connected 👍
It was really helpful mam! I watched lot of videos about it but this was a perfect fit for my problem. I highly recommend it..🔥🙌
Glad to hear that😊 Please support by subscribing
it is really helpful for me. I have successfully changed MYSQL password. thank you!
Glad it helped! Please subscribe
Great step-by-step video, Sunita! Every step is very clear! Great job! Keep it up!
Glad you liked it👍☺plz subscribe
I have watched many videos of 10 mins to fix this issue still unable to fix. But your 40 secs video fixed that. Very thankful ❤️
Glad it helped☺👍please subscribe
Hello Mam!!
I tried step by step but it keeps showing like this:
mysql : [error] unknown variable 'init-file=xx' (xx is my change.txt file location). Please Help
Watch video again and follow steps properly, I'm sure u will be able to do
same error
@@rajeshkannan8608 same error
can u help me how to solve
same error
can u help me how to solve
@@Maneekumar1156 sorry bro, I tried solution from various videos, i forgot which one worked🥲
Thank you so much ma'am for helping through clear and easy steps 👍
My pleasure 😊 Please subscribe
Mam, I have struggled due to this issue. It was now solved and my old lost databases also retrieved... And password also created... Thankyou mam🙂
Glad your problem resolved👍
Thank you so much Sunita! I was struggling to try to reset my password and you saved my life!
Glad my video helped you👍 please subscribe😊
Thanks for your help Sunita. Was scared for forgetting the passward
Happy to help! 😊 Please subscribe!
Thank you so much... i was stuck at this problem and I really had no idea how to deal with this, even after going through all the steps that are mentioned on SQL page. But you have made this so easy to understand. can't thank you enough for this. Super helping video
Very helpful! It worked! At first I forgot to open command prompt as administrator so it did not work, but I realized this and did it again and PERFECT!
very informative, thank you🙏
earlier used google too for help but wasn't much helpful😅
Tqsm, I have been searching for this kind of video for a long time and finally caught it
Glad it was helpful! Please support by subscribing
Thanks! I don't venture into the Windows command prompts much, so that was very helpful!
Seriously 😭😭😭😭
Thx mam 🥺🥺🥺🥺🥺
My cs exam is on 23march and i want to do mysql practice but i forgot my password lmaooo 😂
Hope my video helped you👍 👍 please subscribe
simple and effective, thank you so much for this tutorial !
Thank you so much...!. After searching from several useless videos I finally found the solution here. Your efforts are really appreciated.😊
Glad it helped!
You're welcome👍 Please subscribe😊
Thank you so much this worked!
commands :
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysqld --defaults-file="" --init-file="" --console
Glad my video helped you👍
I can't thank you enough for this, thank you so much for such a quick & simple solution!
Glad my video helped you👍You're welcome 👍Please subscribe
Yes, I wanna thank you too !!! this realy helped me ! And it worked.
Small question: Did you get those knowledge from the Official Dokumentation of MYSQL or how do you know about these Infos ?
Perfect mam!! Absolutely Working.. I was actaully looking for this solutiion,since months....Thank u so much mam
Glad you liked it👍 keep watching
Finally able to reset mysql password and that get possible only because of your this video. Thank you very..... Much
That's great👍 keep watching
Thank you Sunita, your way solved the problem for me as I tried many solutions! Greetings from Romania 🤗
Wonderful! Keep watching
Great job, ma’am! You have saved my time and energy. 😊
My pleasure 😊 Please subscribe
after struggle of half an hour I found your video and now I successfully reset my password, thank you for this amazing video
Thank u so much for this solution. Great find for me to get rid of this issue. Cheers mam!
You're welcome! Please subscribe😊
Thank you so much! This video is pure gold.
Glad it was helpful!👍 Please support by subscribing 😊
Dhanyawad madam.
It took me a while but finally issue is resolved.
You have saved 5days of hard work
Glad my video helped you👍😊 plz subscribe
Thanks a lot.....a very brief and straight to the point solution....🙏🙏🙏🙏🙏🙏🙏🙏
You're welcome👍 please subscribe😊
mam, thank you so much... i searched the whole internet but nothing was working, then i found this video after days of frustration and it solved my problem. Thank you so much again, ma'am
Thank you very much for this detailed instructions. This helped me for retrieving de connection to my Database.
Glad my video helped you👍 plz subscribe
Your tutorial is correct ! I just followed it and finished resetting my 'root' password which I forgot. Thanks so much !!!! 🙂 Highly recommend this video if any fellow wants to reset the password.
Glad it helped you! 👍Thank you so much for your sweet words ☺ stay connected
Too much thaks for your nice demonstration. Tried few articles. But all failed except your one.
Glad it helped👍Stay connected
you have no idea how much you helped me. You explained so well and I could now use mysql.. it really worked.. thank you so much mam !!
It's showing that "the filename, directoryname, or volume label is incorrect "😢 what can i do now??
Join my telegram send screenshot
Thank you so much, Sunita. This tutorial was clear and very helpful
Glad my video helped you 👍 Please support by subscribing 😊
Thank you very much. As usual, a youtube video is more helpful than the official documentation smh.
Really😊
You're welcome👍 please subscribe 😊
Very informative video and it totally works for resetting the MySQL password if forgotten. Thanks for the help.
Glad you liked it👍 Keep watching
thank you so much. i have my computer board practical tmw and i was struggling to change my password since morning
Glad my video helped u in exam! Plz subscribe
Really Helpful. Thank You So Much
Glad it was helpful!👍 Please support by subscribing 😊
I also tried other youtube videoes but they didnt work and spent lot of time on this. By your video its done in one just 2 minutes Thank you.
Mam I done all these things ..
But when I m opening the SQL .... Thee dialogue box open infront of me iss .. cannot connect to data base server . Nd ur connection attempt failed for user root to the MySQL server at localhost 3306. Plz help what can I doo
Join my telegram and share pic
Thank u so much ma'am it worked!! I had been wasting my time watching other tutorials since an hour but this video solved my issue, Thanks again ma'am..
Really thanks alot mam, many many thanks from last 8 hrs I am strugglingI tried alot, seen many videos ,but your video solved my big problem..!! I successfully reset my password. Once again thanks alot. 🙏🙏
I am so happy my video helped you👍plz subscribe and keep watching☺
Sure mam. Thanks once again 👏🥳✌💯
Awesome, seen many but explanation and steps were very clear with reasoning. excellent work and video. password finally worked !!
Great to hear!
Most welcome 😊 Please subscribe👍
Whew! THis helped me a lot! followed everything and it worked! Thanks
You're welcome! 😊Please subscribe 👍
ma'am in command prompt it is showing ' directory name is invalid ' , plz instruct what should I do ?
You need to provide your directory name.
I have created sunita U can create any folder and provide location
This is by far the best recourse I've seen on this topic. Thank you verify much.
Glad you liked my content 👍keep watching
hello mam, This video is helpful but my data running the online server not in the localhost server
so I lost my MySQL password, how do rest the password
Mam the error which was highlighted in the video which show an error u can get i am getting the same error
Thank you Mam , This video may be old but it resolved my issue in windows 11
Glad my video helped you👍 plz subscribe
Thankyou so much mam, after hustling since 3 days , i finally came to your video , finally it worked , thankyou so much again.❤
Thank you your videos are really helpful. ❤
Glad you like them!
Mam how can we see the path where we have saved the alter command textfile
Please help it's urgent
Mam please helppp
dont' worry create new text file wherever u want.
just remember path
Nice, thanks and love you mam, i was trying from long time to change password.
Glad it was helpful!☺please subscribe👍
Sure mam..
I am unable to find my.ini file in all the location and hidden items was enabled. I tried whole window search also but no luck. Please suggest
Process is straightforward. Great✓
Thanks 👍 Please subscribe
Thank you so much for such a quick & simple solution!
Glad you liked it😊 plz subscribe😊👍
why is my ini file is missing although i did exactly like the video myini file is missing in program data's mysql file please help me to resolve this problem
Check in hidden files/folders
thank you so much, after watch so many tutorials, only your solution works, thanks
That's great👍keep watching ☺stay connected
Hello Mam, Thank you for making this video, I followed all the steps but at the end when I am entering password in Mysql command line client and pressing enter then Mysql command line client is gettting closed. Could you help me out with this issue.
R u entering correct password?
If u hv forgotten password u get reset. Check my video on this.
Also check in windows services mysql server is running or not
Also subscribe to my channel👍
I don't have my.ini file , I even marked the show hidden items but i don't have that file. It didn't work for me. Any other solution ? thanks for sharing and your help
Which version of mysql u hv?
Thank you so much, it worked very well for me. You don't know how much this helped me :)
Please, keep up sharing your knowledge with us!
Glad my video helped you😊Please subscribe
Glad my video helped you😊Please subscribe
Finally! After spending 2 hours, it worked! Thank you so much.
You're welcome!👍please subscribe😊
I was struggling, thank you very much !
Most welcome 😊Please subscribe
Thanks can finally start my practical assignments
That's great👍keep watching
Thanks for this! So incredibly helpful!
Glad it was helpful!
Most welcome 😊Please subscribe
You are genius, thank you for amazing explanation 🥰
Glad you liked my content😊
Please subscribe 👍
Hello ma'am can u plzz tell jo aapne E:\sunita\change .txt wali line likhi thi usme Sunita kha se aaya .... please tell ma'am and if anyone else know plz help
Sunita is my folder name which I have created in e: drive
It's shows the directory name is invalid at 3:03 while using command prompt . Please help ma'am.
You need to change directory to bin. Make sure you copied proper path
I lost words to say to you ma'am this is a huge relief to me thanks a lot ma'am
Glad my video helped u!
Most welcome 😊Please subscribe
Thank You, that was very helpful.👍
Glad it was helpful! Please support by subscribing
Thank you very much, it worked! Amazing tutorial, saved me a lot of headache :D
Glad you liked it👍 please subscribe
Thank You👍👍
You're welcome👍 please subscribe😊
Thanks a lot! I was panicking as I had to do assignments in the existing databases.
Can you please provide the video of how to connect external db using credentials in MySQL workbench.
What type of external db u r using?
U can import them in mysql and use
Mam.. i also done as same as you.. but in cmd it shows
Mysqlid is not recognised as an internal or external command
U need to open cmd prompt in administrative mode
Thank you so much miss.
U really saved me and really it worked without any problem ❤
You are welcome 😊 Please subscribed
Please help me I forgot my password and reinstalled the MySQL present following the video The result is an error please solve the issue mam.
What's the error?
Muy buen video, me ayudo bastante para cambiar la contrasena. Se entiende perfectamente, le doy like. Thank you so much, this video really helped me to reset the password
You're welcome ! Please subscribe and keep watching
i get the error "mysql: [ERROR] unkown variable 'init-file=MyPath'.
after = u need to paste ur path
Thanks so much for this video. Just saved me hours of finding a solution to resetting my password.
Great to hear!😊please subscribe👍
Thank you so much mam....😇
Mam can you please upload a video on how to get connection with MySql i.e., giving permission to something that deal with SHA-256.Thank you so much mam.
Thank you so much👍
I think if you select 2nd option from this video 04:47. This option is for SSL
ruclips.net/video/iw1WX7eIWNY/видео.html
Thanks for the video. provided information has worked for me
Glad my video helped you🤗 please subscribe
my.ini file is not there, in my system, can you please suggest a solution 🙏
I'll chk
MySQL80 says its running, but when i right click It wont let me stop it
I don't think so it's error.
Check on phpadmin
the main thing is in services i am not seeing any mysql server so plz could u help me ......
It means your server not running
I got "mysqld: [ERROR] Failed to open required defaults file: C:\ProgramData\MySQL\MySQL" No idea why
Open cmd as run as administratior
Very informative.. thanks for sharing... Iit is very easy and helpful
Glad you liked it👍