Reset your MySQL password on Windows PC without requiring the old password. Success rate - 100%
Reset your MySQL password on Windows PC without requiring the old password. Success rate - 100%
Hello and Welcome to my channel! I’m CA and today I’m gonna show you how to reset your MySQL password if you have forgot it or was not prompted to setup it up while installing.
You don’t need to remember the old password for this fix!
So watch this video till end and don’t skip in between!!.
► MySQL reset password Blog :- https://cutt.ly/YbTcaKx
► MySQL official website :- https://cutt.ly/ybTcjjD
► Install Jupyter Notebook on Computer:- https://bit.ly/32rvntS
► Visit my Blog:- https://bit.ly/3eax04I
► Windows 10:- https://bit.ly/3stSb79
► Follow me on Instagram:- https://bit.ly/3tww01f
► Don’t Click!!! - https://bit.ly/3an6a8n
#mysql #resetPassword #password #forgotPassword
─────────────────────────────────────────
Music in this video:-
○ Friendship by Declan DP https://soundcloud.com/declandp
Licensing Agreement: http://declandp.info/music-licensing
Free Download / Stream: https://bit.ly/friendship-declan-dp
Music promoted by Audio Library • Friendship – Declan DP (No Copyright …
○ Believe by Roa https://soundcloud.com/roa_music1031
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/roa-believe
Music promoted by Audio Library • Believe – Roa (No Copyright Music)
○ Higher by Roa https://soundcloud.com/roa_music1031
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/higher-roa
Music promoted by Audio Library • Higher – Roa (No Copyright Music)
─────────────────────────────────────────
Content
0.76 -> Welcome to Everything Computerized, I am CA
and in this video I am going to show you how
4.89 -> you can reset your MySQL password without
requiring the old password. So watch this
9.76 -> video till end and let's get started. So in
order to reset your MySQL password, you don't
28.33 -> need to have your old password with you. You
just need to login your computer as the admin
34.12 -> user and follow the steps which I am going
to show you and then you will be able to reset
39.51 -> your MySQL password. So first you need to
stop the MySQL service. So for that, you need
46.329 -> to go to 'Start' and then you need to search
for 'services' and then you need to open this
51.719 -> particular application and you will be having
Windows Services Explorer in front of you.
57.549 -> In order to open this particular window, you
can also go to start, right click on it, and
63.02 -> then go to run, and there, you need to type
'services.msc' and then when you press enter.
70.14 -> Then also you will be able to open this Windows
Services Explorer. So once you have the services
74.9 -> explorer in front of you, you need to search
for MySQL, so scroll a bit until you find
80.97 -> MySQL. So I am having MySQL80 but if you have
a different version of MySQL, then the number
88.52 -> succeeding MySQL might be different for you.
I have MySQL80 because I have installed MySQL
95.14 -> 8.0 version. So, double click on the service
and now you need to stop this service. So
102.64 -> for that you need to click on the 'stop' button.
Now what you need to do is you need to go
109.95 -> to this particular path, that is, Path to
executable, and then right click on it and
116.02 -> then click on 'Select all', and once it is
selected, you need to right click on it again
121.67 -> and then click on 'Copy'. Now you need to
open Notepad, so go to start, search for Notepad,
128.45 -> and now you need to paste the thing that you
have copied just now, so right click on it,
132.48 -> and click on 'Paste' and this is the thing
which we are going to need further in this
138.17 -> video. You just need to edit a few things,
so you just need to remove this and then you
143.56 -> need to remove this mysql80 also. So these
are the two things which we are going to need
149.69 -> so the first one is the path to the MySQL
Service and the second one is the path to
154.73 -> the init file that we are going to use, so
don't close this Notepad window, just minimise
160.459 -> it.
164.92 -> Now you need to create a new text file, so
right click on the desktop, then click on
170.55 -> New, and then click on text document. Here
you need to give the name reset and press
175.61 -> enter. Now you need to edit this file, so
double click on it, and you need to type the
181.12 -> thing that I am going to type here. So, you
need to type ALTER USER and within single
190.359 -> quotations you need to write 'root' and then
you need to close the quotation mark and then
196.779 -> you need to type @ and again you need to type
single quotation and you need to write 'localhost'
204.65 -> and enclose it with a single quotation mark,
and now with a space, you need to write IDENTIFIED
210.349 -> BY and now, you need to write the password
that you are going to have within single quotations.
220.2 -> So I will write 123456 as my new password
and then you need to enclose it within single
226.719 -> quotation mark and then add a semicolon at
the end. So, this is the final thing that
232.37 -> you need to have in your text file. You don't
have to make any mistake because it is then
238.4 -> going to give an error and then you will not
be able to reset your password. So this is
243.54 -> the thing which you are going to have, that
is, ALTER USER and then within single quotation
248.309 -> you need to write 'root' and then @ and then
again within single quotations, you need to
254.42 -> write 'localhost' and then, IDENTIFIED BY
and within single quotations you need to write
259.41 -> the new password, so in my case I am writing
'123456' as the new password and you can have
265.17 -> any other password of your choice. Now you
need to save this, so click on file, and then
270.64 -> click on save. Now close this notepad.
275.58 -> Now you need to move this file to C drive,
so right click on this, click on cut, and
280.941 -> now you need to go to This PC, and then go
to C drive, and now on the blank side, you
285.47 -> need to right click and click on Paste. Now
click on continue and then you will be having
292.06 -> the text document inside C drive. Now close
this. Now you need to open Command Prompt,
298.7 -> so go to start, and then scroll until you
find Windows system, and then right click
305.13 -> on command prompt, and then click on more,
and then click on the run as administrator.
309.54 -> I have opened the command prompt window. Now
you need to open the Notepad window that we
315.75 -> have just opened after opening the services
tab. So these are the two things which we
321.34 -> are going to need now. So you need to copy
the first file path that is for the my SQL
327.79 -> service. Select this file path, then right
click on it, and then click on copy. Now go
333.43 -> back to your command prompt and then right
click here so that the copied thing will be
337.49 -> pasted here. Now give space and now you need
to type -- and then you need to type defaults
346.82 -> and then a - again and then file and then
given equal to sign and then you need to go
354.3 -> back again to the Notepad and copy the second
part that is for the my.ini, so right click
361.46 -> on it and then click on copy. Now go back
again to the command prompt window and right-click
366.08 -> here and the copied thing is pasted here.
Now give space again and then give -- and
373.75 -> then write init-file and then give an equal
to sign and here you need to give the path
382 -> of the reset.txt file that we have just created
before. So give a " and then type "C:\reset.txt"
395.53 -> and then type again a " mark and now give
space again and type -- and then type console.
405.57 -> Now this is our final statement that we are
going to execute. You don't have to make any
411.2 -> mistake here because then you will not be
able to reset MySQL password. So make sure
417.02 -> that each and everything is correct here.
So when you have finalized everything, press
422.26 -> enter and now it will take some time and then
it will start the MySQL process and then if
429.89 -> you have an output like this, then what you
need to do is open MySQL command line client,
435.171 -> so go to start, and then scroll a bit until
you find MySQL, and then you need to open
441.84 -> MySQL command line client, so click on it,
and now you need to type the new password
447.93 -> that you have set. I have my new password
as 123456 so type the password and then click
454.58 -> on enter, and if you are able to access your
MySQL command line Client or if you are having
460.31 -> an output like this, then you have successfully
reset your password. Now you need to close
466.9 -> this command line client and here you need
to press Ctrl + C and as soon as you do this,
475.75 -> MySQL service will be stopped. Press enter
and now close this command prompt window.
482.389 -> Now we don't need this Notepad so close this,
and now you need to start your MySQL service
490.31 -> again, so you need to open services again,
so go to start and then search for services
496.4 -> and then open it. And now you need to search
for MySQL again. So here is the MySQL service,
506.38 -> double click on it and then you need to click
on start, and it will take some time and MySQL
513.56 -> service will be started again, and now once
it is successfully started, click on OK and
520.43 -> then you need to close the services window,
so close it, and now you need to go to command
525.27 -> line client again just for the sake of completion,
so go to MySQL command line client and type
531.88 -> the new password. So I will type 123456 as
in my case, so when I press enter, I'll be
538.39 -> able to access MySQL with my new password.
So this is the step by which you can reset
546.07 -> your MySQL password or set a new password
without requiring the old one.
552.08 -> I have also written a blog over this particular
process, so I will be giving the link in the
558.11 -> comments section. This was all for this video.
Leave a like if it was helpful for you and
564.71 -> if you are new to this channel, a SUB to the
channel would be incredible. THANKS FOR WATCHING
569.32 -> and I'll see you in the next one!
570.66 -> *subtitle by CA*
Source: https://www.youtube.com/watch?v=rr_hDJLFvQE