Fix: MySQL Error 1045 (28000) Access denied for user root localhost (using password YES) Windows 10
Learn how to fix MySQL Error 1045 (28000) Access denied for user root@localhost (using password YES) on Windows 10.
Install MySQL on Windows 10:
• How to install MySQL 8...
MySQL Tutorial for Beginners
• Learn MySQL in 3 Hours...
#accessdenied #mysql #windows10
► Top Online Courses From Amit Thinks
MySQL Tutorial for Beginners: ⭐️ • Learn MySQL in 3 Hours...
MongoDB Tutorial for Beginners: ⭐️ • MongoDB Tutorial for B...
Bootstrap 4 Tutorial: ⭐️ • Bootstrap Tutorial for...
Eclipse Programming Tutorial: ⭐️ • Learn Eclipse in 1 Hou...
► Follow
My Website - studyopedia.com
► Subscribe
/ amittechie
► Donate & Support us
www.paypal.com/paypalme/learn...
Пікірлер: 140
👉MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Still the same error, I tried to find my.ini but i can't find this file in no one path at all. Im windows 10 user mysql server 8.0 NOTE: localhost has a autosigned certificate by VMWare, I don't know why is installed, i didn't
Same error showing in pycharm Database is correctly working bt not connecting to pycharm . Can I follow same steps?
Access denied for user 'root'@'localhost' (using password: NO) after doing it its showing same error in the eclipse bt in cmd its running smoothly .how to fix it
Multumesc frumos pentru ajutor si efortul depus.Succes in continuare!!!!
@Amit.Thinks
6 ай бұрын
I have used Google Translate to translate your comments. You're welcome. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Thanks for the information. I am still struggling as I want to connect to my employers host via my company's VPN in the MySQL using his username and password. How could I do that?? please let me know if anyone has experience with this.
Thank you so much Amit! It was pretty helpful.
@Amit.Thinks
6 ай бұрын
Glad to hear that. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
thank you very much for the video amit, a big hug it helped me a lot with my school work
@Amit.Thinks
3 ай бұрын
Glad it helped. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
still the same error presists, please guide.
This works for python as well if your python app(pycharm/Spyder) is showing the same problem
I'm still having this error 😭😭😭😭😭😭😭 Bro help pls
i use xaamp and getting this error do i need to follow the same process ?
@Amit.Thinks
5 ай бұрын
For XAMPP Access Denied error, follow this video: kzread.info/dash/bejne/f4WbqZJ-p8y6p9o.html
Thank you so much sir really it's helpful 🙏❤
@Amit.Thinks
7 ай бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
In cmd, when i type , mysql -version , it’s showing mysql is not recognized as an internal or external command, operable program or batch file
@swapnavivek9647
Жыл бұрын
I also get the same error. But I had installed mysql80 and port no. is 3308. Can someone pls help soon?
@yashsahu3525
Жыл бұрын
copy the bin path from sql server folder and paste in command prompt as : cmd path Them use commands
@CodeWithKav
10 ай бұрын
You just need to add path of c:\program files\my sql\SQL server\bin to the environment variables
Still getting same error
It worked, thanks !
@Amit.Thinks
2 жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
How to solve type iniatiator error
I guess this problem occurs most of the time (like in my case) because if you have XAMPP installed you will probably have a path to "c:\xampp\mysql\bin" in the environment variables. Just delete this path variable and insert the path to "c:\program files\MySQL\MySQL Server 8.0\bin" Thx for your effort Amit!
@biswaschongbang156
Жыл бұрын
thank you brother this was the best solution advice i have ever got
@abuloly2690
Жыл бұрын
You have my respect 🫡 ❤
@rif37283
11 ай бұрын
You are so helpful brother, thank a lot
@prachigaikwad6769
7 ай бұрын
Thankyou very much it really helped
my problem solved .Thank you.
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Not worked .
Helped a lot😀😀
@Amit.Thinks
9 ай бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
its not working
Amit bro you r boss🎉
i dont know the password what to do ?
@Amit.Thinks
Жыл бұрын
Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
NOTE: If your root password contains a single quote (or potentially other special characters, I only tested with single quotes), this will not fix it, you have to change the password.
@S1zzy__
Жыл бұрын
How?
@SHORTSALBUMS
6 ай бұрын
Thanks but how I can change it
@Amit.Thinks
6 ай бұрын
Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
@SHORTSALBUMS
6 ай бұрын
@@Amit.ThinksTHANKS SIR BUT I ALREADY WATCH AND MY PASSWORD IS WORKING BUT WHEN I OPEN AND ENTER MYSQL PASSWORD IS SHOWING MySQL Shell 8.0.36 Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help' or '\?' for help; '\quit' to exit. This is showing please help 👆
@Amit.Thinks
6 ай бұрын
Oh, no. Open a new cmd and type: mysql --version What is visible?
doesnt work
Thanks a lot.
@Amit.Thinks
10 ай бұрын
You're welcome. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
In passward section which password we have to put
@Amit.Thinks
3 ай бұрын
If it is directly asking you to enter the current password, then maybe the installation failed or partially installed. Follow the steps: Step1: Uninstall MySQL Completely: kzread.info/dash/bejne/k4B6lJtqp8qpp7w.html Step2: Restart the system Step3: Re-install MySQL 8.0.36: kzread.info/dash/bejne/iWVnrspmnaq_n6w.html
'mysql' is not recognized as an internal or external command,
@Amit.Thinks
11 ай бұрын
Here's the fix for "mysql is not recognized...: kzread.info/dash/bejne/kZZnxMmGmN3eibw.html
I forgot my root password. how can I resolve that problem?Please guide me
@Amit.Thinks
4 ай бұрын
Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
Issue resolved ✅
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Still this problem facing sir I my case mein jab path dalti hu tab naii ata error or jab firse mujhe study karna rehta hai to laptop on karke jab command prompt open karti hu to firse ye problem ho jati hai in short jab path dalti hu again tab he error nahii ata firse open karne pn ata hai
@Amit.Thinks
Жыл бұрын
Set the path under Environment Variables i.e. "System Variables". Check the updated video: kzread.info/dash/bejne/eat80qulYNnXiZc.html
no, no me funciona
thanx u so much may god bless you
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
If I don't know my password what to do ?? Pls anyone say
@Amit.Thinks
Жыл бұрын
Reset MySQL password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
Twice checked.....still getting error
@Amit.Thinks
4 ай бұрын
Step1: Uninstall the partial MySQL: kzread.info/dash/bejne/k4B6lJtqp8qpp7w.html Step2: Restart the system Step3: Re-install MySQL 8.0.36: kzread.info/dash/bejne/iWVnrspmnaq_n6w.html
you are so great u have figured my most hated bug this is if i would meet you i would reward you my car
@Amit.Thinks
Жыл бұрын
Welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
What to do after I forgot the root password
@Amit.Thinks
5 ай бұрын
Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
it's worked, thankss!
@Amit.Thinks
Жыл бұрын
You're welcome! Refer to our free: MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Hi sir Mysql error 1045 Access denied for user root@ localhost (using password (NO)) How can solve that is pls tell me
@Amit.Thinks
Ай бұрын
Fix: kzread.info/dash/bejne/hZV2pteroKTaoMY.html
@sreedharveera4540
Ай бұрын
Hi sir Mysql error is 1045 django.db.utils.operationalError : Access denied for user root@ localhost (using password (NO)) How can solve that is pls tell me sir i did try this video fix: kzread.info/dash/bejne/hZV2pteroKTaoMY.html but not work pls tell me sir another way how solve this problem
@Amit.Thinks
Ай бұрын
Django operational error? What are you installing? I have only shown how to install MySQL. You're mixing things.
Thanks bhaiya
@Amit.Thinks
2 жыл бұрын
You're welcome. Subscribe! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
thanks
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
for those still facing the error i solved mine typing mysql -u root -p -h localhost instead of mysql -u root -p i hope it work for you
@ayushmishrarn-1883
Жыл бұрын
Thanku very much bhai .....🙏🙏
@I-can-do-that-1
Жыл бұрын
Yes this on this one working...., big thanks
@faizansiddiq8624
Жыл бұрын
may god blast you with surprises
@gautambh375
11 ай бұрын
bhaii u r genius
@sahithyavani
9 ай бұрын
Thanks a lot 😊
thanks that helped
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Thanks a lotttttttttttttttttttttttttttttt..............
@Amit.Thinks
7 ай бұрын
You're welcome. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Enter password.... Which password?
@Amit.Thinks
2 жыл бұрын
The password you created while installing.
@mg-koda
2 жыл бұрын
@@Amit.Thinks My problem is.. i forgot the password i created while installing.
@Amit.Thinks
2 жыл бұрын
@Francesco Reset the password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html
Mysql 5.0 on window 10
@Amit.Thinks
2 жыл бұрын
MySQL 5.0 is outdated/ obsolete
It worked!! 💯 Thank you Sir!
@Amit.Thinks
10 ай бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Sir can you explain how to fix the error 1044(42000): Access denied for user root to database 😢
@Amit.Thinks
10 ай бұрын
Fix: kzread.info/dash/bejne/hZV2pteroKTaoMY.html
@sujatabiswal2505
10 ай бұрын
@@Amit.Thinks thank you sir...
Sir it is still showing the same error
@Amit.Thinks
8 ай бұрын
Follow the steps: Step1: Uninstall MySQL Completely: kzread.info/dash/bejne/k4B6lJtqp8qpp7w.html Step2: Restart the system Step3: Re-install: kzread.info/dash/bejne/nWmoq6WunsjSg7g.html
OpEn sOurCE iS tHE fuTURe
password send me
@Amit.Thinks
2 жыл бұрын
Add your own password
I still have the same error
awesome
@Amit.Thinks
Жыл бұрын
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Not working
@Amit.Thinks
2 жыл бұрын
Welcome! Subscribe! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
wooou thank youuuuuuuuuuuuuuuu
@Amit.Thinks
4 ай бұрын
You're welcome. After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
not work
@Amit.Thinks
Жыл бұрын
Try using cmd with "Run as Administrator"
@debangshubiswas7870
Жыл бұрын
@@Amit.Thinks still not working sir.
thanks (:
@Amit.Thinks
10 ай бұрын
Welcome. Get our free MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
Very fast
@Amit.Thinks
2 жыл бұрын
No one ever said that. If it will be slow, people will comment, it’s slow. 😊 You can reduce the speed of any KZread video to 0.75. I hope you know how to do that.
FOR ALL THE PEOPLE WHO ARE STILL HAVING AN ISSUE AFTER DOING EVERYTHING IN THE TUTORIAL CORRECTLY HERE IS HOW I SOLVED MY ISSUE mysql -u root -p -h 127.0.0.1 -P 3306 the enter your password if the issue is in visual studio on the Add Connection Dialog 1.Just click the Advanced... Button 2.Under Connection section Look for Port and server and input the above port number mine was 3306 3.Click okay and then Test the connection I sincerely hope the time i spent searching for this will save someone some headache
@payalswain8652
2 жыл бұрын
It's clearly working, thank you
@034-deepikaa3
2 жыл бұрын
thank you so much
@joeljacobfelix4871
Жыл бұрын
thanks man
@anelephantseal5828
Жыл бұрын
doesn't work
@muhammadadryanhasbi6402
Жыл бұрын
Its working, thank you so much sir
I first tried to add `C:\Program Files\MySQL\MySQL Server 8.0\bin` into the path (env variable), didn't work out. It might be another reason but in my case it was all about copying and pasting the password, typing it out manually solved the issue.
This worked for me: Windows+R > services.msc > MySQL80 > Start For some reason it was off
@Amit.Thinks
2 жыл бұрын
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html
didnt work