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

  • @Amit.Thinks
    @Amit.Thinks Жыл бұрын

    👉MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html

  • @fzgonzalez94
    @fzgonzalez942 жыл бұрын

    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

  • @pratiksha5157
    @pratiksha5157 Жыл бұрын

    Same error showing in pycharm Database is correctly working bt not connecting to pycharm . Can I follow same steps?

  • @amritaroy1572
    @amritaroy15722 жыл бұрын

    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

  • @ilieghilas2918
    @ilieghilas29186 ай бұрын

    Multumesc frumos pentru ajutor si efortul depus.Succes in continuare!!!!

  • @Amit.Thinks

    @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

  • @manpreetsohal11
    @manpreetsohal11 Жыл бұрын

    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.

  • @juanpablomontes9508
    @juanpablomontes95086 ай бұрын

    Thank you so much Amit! It was pretty helpful.

  • @Amit.Thinks

    @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

  • @gonzalogarcia.7606
    @gonzalogarcia.76063 ай бұрын

    thank you very much for the video amit, a big hug it helped me a lot with my school work

  • @Amit.Thinks

    @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

  • @kokkiligovinda1943
    @kokkiligovinda19432 жыл бұрын

    still the same error presists, please guide.

  • @animebattles_
    @animebattles_8 ай бұрын

    This works for python as well if your python app(pycharm/Spyder) is showing the same problem

  • @acrobite26
    @acrobite26 Жыл бұрын

    I'm still having this error 😭😭😭😭😭😭😭 Bro help pls

  • @itsmayuresh8140
    @itsmayuresh81405 ай бұрын

    i use xaamp and getting this error do i need to follow the same process ?

  • @Amit.Thinks

    @Amit.Thinks

    5 ай бұрын

    For XAMPP Access Denied error, follow this video: kzread.info/dash/bejne/f4WbqZJ-p8y6p9o.html

  • @dishantitaliya1912
    @dishantitaliya19127 ай бұрын

    Thank you so much sir really it's helpful 🙏❤

  • @Amit.Thinks

    @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

  • @ankitrao8377
    @ankitrao8377 Жыл бұрын

    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

    @swapnavivek9647

    Жыл бұрын

    I also get the same error. But I had installed mysql80 and port no. is 3308. Can someone pls help soon?

  • @yashsahu3525

    @yashsahu3525

    Жыл бұрын

    copy the bin path from sql server folder and paste in command prompt as : cmd path Them use commands

  • @CodeWithKav

    @CodeWithKav

    10 ай бұрын

    You just need to add path of c:\program files\my sql\SQL server\bin to the environment variables

  • @sakshipandey8018
    @sakshipandey80182 жыл бұрын

    Still getting same error

  • @subodhpatil4949
    @subodhpatil49492 жыл бұрын

    It worked, thanks !

  • @Amit.Thinks

    @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

  • @priyam_18
    @priyam_182 жыл бұрын

    How to solve type iniatiator error

  • @fleckenfurz77
    @fleckenfurz77 Жыл бұрын

    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

    @biswaschongbang156

    Жыл бұрын

    thank you brother this was the best solution advice i have ever got

  • @abuloly2690

    @abuloly2690

    Жыл бұрын

    You have my respect 🫡 ❤

  • @rif37283

    @rif37283

    11 ай бұрын

    You are so helpful brother, thank a lot

  • @prachigaikwad6769

    @prachigaikwad6769

    7 ай бұрын

    Thankyou very much it really helped

  • @enjoylearning8585
    @enjoylearning8585 Жыл бұрын

    my problem solved .Thank you.

  • @Amit.Thinks

    @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

  • @RohitKumar-dz8dh
    @RohitKumar-dz8dh Жыл бұрын

    Not worked .

  • @Photosyntax
    @Photosyntax9 ай бұрын

    Helped a lot😀😀

  • @Amit.Thinks

    @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

  • @jenishrai4457
    @jenishrai44572 жыл бұрын

    its not working

  • @ridoychandraray2413
    @ridoychandraray241311 ай бұрын

    Amit bro you r boss🎉

  • @raviteja8798
    @raviteja8798 Жыл бұрын

    i dont know the password what to do ?

  • @Amit.Thinks

    @Amit.Thinks

    Жыл бұрын

    Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @HighTempChaos
    @HighTempChaos Жыл бұрын

    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__

    @S1zzy__

    Жыл бұрын

    How?

  • @SHORTSALBUMS

    @SHORTSALBUMS

    6 ай бұрын

    Thanks but how I can change it

  • @Amit.Thinks

    @Amit.Thinks

    6 ай бұрын

    Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @SHORTSALBUMS

    @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

    @Amit.Thinks

    6 ай бұрын

    Oh, no. Open a new cmd and type: mysql --version What is visible?

  • @thepassingpawn
    @thepassingpawn2 жыл бұрын

    doesnt work

  • @jameskirbyremo9077
    @jameskirbyremo907710 ай бұрын

    Thanks a lot.

  • @Amit.Thinks

    @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

  • @AMOLNAITAM
    @AMOLNAITAM3 ай бұрын

    In passward section which password we have to put

  • @Amit.Thinks

    @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

  • @pupppydo
    @pupppydo11 ай бұрын

    'mysql' is not recognized as an internal or external command,

  • @Amit.Thinks

    @Amit.Thinks

    11 ай бұрын

    Here's the fix for "mysql is not recognized...: kzread.info/dash/bejne/kZZnxMmGmN3eibw.html

  • @shwetaskatta8464
    @shwetaskatta84644 ай бұрын

    I forgot my root password. how can I resolve that problem?Please guide me

  • @Amit.Thinks

    @Amit.Thinks

    4 ай бұрын

    Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @msk-pl3hw
    @msk-pl3hw Жыл бұрын

    Issue resolved ✅

  • @Amit.Thinks

    @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

  • @sanikalonare03
    @sanikalonare03 Жыл бұрын

    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

    @Amit.Thinks

    Жыл бұрын

    Set the path under Environment Variables i.e. "System Variables". Check the updated video: kzread.info/dash/bejne/eat80qulYNnXiZc.html

  • @anonymushadow282
    @anonymushadow282 Жыл бұрын

    no, no me funciona

  • @kenzaamroune7809
    @kenzaamroune7809 Жыл бұрын

    thanx u so much may god bless you

  • @Amit.Thinks

    @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

  • @madhurikasarapu04
    @madhurikasarapu04 Жыл бұрын

    If I don't know my password what to do ?? Pls anyone say

  • @Amit.Thinks

    @Amit.Thinks

    Жыл бұрын

    Reset MySQL password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @jagrutibhagwat9899
    @jagrutibhagwat98994 ай бұрын

    Twice checked.....still getting error

  • @Amit.Thinks

    @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

  • @mosesmaned2151
    @mosesmaned2151 Жыл бұрын

    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

    @Amit.Thinks

    Жыл бұрын

    Welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html

  • @prashanththeru9939
    @prashanththeru99395 ай бұрын

    What to do after I forgot the root password

  • @Amit.Thinks

    @Amit.Thinks

    5 ай бұрын

    Reset MySQL Password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @bagusdarmawann11
    @bagusdarmawann11 Жыл бұрын

    it's worked, thankss!

  • @Amit.Thinks

    @Amit.Thinks

    Жыл бұрын

    You're welcome! Refer to our free: MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html

  • @sreedharveera4540
    @sreedharveera4540Ай бұрын

    Hi sir Mysql error 1045 Access denied for user root@ localhost (using password (NO)) How can solve that is pls tell me

  • @Amit.Thinks

    @Amit.Thinks

    Ай бұрын

    Fix: kzread.info/dash/bejne/hZV2pteroKTaoMY.html

  • @sreedharveera4540

    @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

    @Amit.Thinks

    Ай бұрын

    Django operational error? What are you installing? I have only shown how to install MySQL. You're mixing things.

  • @anshumaangangwar
    @anshumaangangwar2 жыл бұрын

    Thanks bhaiya

  • @Amit.Thinks

    @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

  • @hassanbibich12
    @hassanbibich12 Жыл бұрын

    thanks

  • @Amit.Thinks

    @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

  • @caxtei
    @caxtei Жыл бұрын

    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

    @ayushmishrarn-1883

    Жыл бұрын

    Thanku very much bhai .....🙏🙏

  • @I-can-do-that-1

    @I-can-do-that-1

    Жыл бұрын

    Yes this on this one working...., big thanks

  • @faizansiddiq8624

    @faizansiddiq8624

    Жыл бұрын

    may god blast you with surprises

  • @gautambh375

    @gautambh375

    11 ай бұрын

    bhaii u r genius

  • @sahithyavani

    @sahithyavani

    9 ай бұрын

    Thanks a lot 😊

  • @RonDavisceo
    @RonDavisceo Жыл бұрын

    thanks that helped

  • @Amit.Thinks

    @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

  • @proudindo383
    @proudindo3837 ай бұрын

    Thanks a lotttttttttttttttttttttttttttttt..............

  • @Amit.Thinks

    @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

  • @bitcoin2395
    @bitcoin23952 жыл бұрын

    Enter password.... Which password?

  • @Amit.Thinks

    @Amit.Thinks

    2 жыл бұрын

    The password you created while installing.

  • @mg-koda

    @mg-koda

    2 жыл бұрын

    @@Amit.Thinks My problem is.. i forgot the password i created while installing.

  • @Amit.Thinks

    @Amit.Thinks

    2 жыл бұрын

    @Francesco Reset the password: kzread.info/dash/bejne/oaR8uaVufpXQlrg.html

  • @edouardwilliam3258
    @edouardwilliam32582 жыл бұрын

    Mysql 5.0 on window 10

  • @Amit.Thinks

    @Amit.Thinks

    2 жыл бұрын

    MySQL 5.0 is outdated/ obsolete

  • @taiwoelizabeth7824
    @taiwoelizabeth782410 ай бұрын

    It worked!! 💯 Thank you Sir!

  • @Amit.Thinks

    @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

  • @sujatabiswal2505
    @sujatabiswal250510 ай бұрын

    Sir can you explain how to fix the error 1044(42000): Access denied for user root to database 😢

  • @Amit.Thinks

    @Amit.Thinks

    10 ай бұрын

    Fix: kzread.info/dash/bejne/hZV2pteroKTaoMY.html

  • @sujatabiswal2505

    @sujatabiswal2505

    10 ай бұрын

    @@Amit.Thinks thank you sir...

  • @navneetpatelverma7420
    @navneetpatelverma74208 ай бұрын

    Sir it is still showing the same error

  • @Amit.Thinks

    @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

  • @rewe3536
    @rewe3536 Жыл бұрын

    OpEn sOurCE iS tHE fuTURe

  • @dmflowers967
    @dmflowers9672 жыл бұрын

    password send me

  • @Amit.Thinks

    @Amit.Thinks

    2 жыл бұрын

    Add your own password

  • @ebikatsuenak3797
    @ebikatsuenak37972 жыл бұрын

    I still have the same error

  • @caliwlove
    @caliwlove Жыл бұрын

    awesome

  • @Amit.Thinks

    @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

  • @Nixop1205
    @Nixop12052 жыл бұрын

    Not working

  • @Amit.Thinks

    @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

  • @niwemutoniannedivine773
    @niwemutoniannedivine7734 ай бұрын

    wooou thank youuuuuuuuuuuuuuuu

  • @Amit.Thinks

    @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

  • @LvnnnX
    @LvnnnX Жыл бұрын

    not work

  • @Amit.Thinks

    @Amit.Thinks

    Жыл бұрын

    Try using cmd with "Run as Administrator"

  • @debangshubiswas7870

    @debangshubiswas7870

    Жыл бұрын

    @@Amit.Thinks still not working sir.

  • @kuldeeppaswan1345
    @kuldeeppaswan134510 ай бұрын

    thanks (:

  • @Amit.Thinks

    @Amit.Thinks

    10 ай бұрын

    Welcome. Get our free MySQL Tutorial: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html

  • @nsksureshkumar8444
    @nsksureshkumar84442 жыл бұрын

    Very fast

  • @Amit.Thinks

    @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.

  • @meth8848
    @meth88482 жыл бұрын

    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

    @payalswain8652

    2 жыл бұрын

    It's clearly working, thank you

  • @034-deepikaa3

    @034-deepikaa3

    2 жыл бұрын

    thank you so much

  • @joeljacobfelix4871

    @joeljacobfelix4871

    Жыл бұрын

    thanks man

  • @anelephantseal5828

    @anelephantseal5828

    Жыл бұрын

    doesn't work

  • @muhammadadryanhasbi6402

    @muhammadadryanhasbi6402

    Жыл бұрын

    Its working, thank you so much sir

  • @Yalchin403
    @Yalchin4032 жыл бұрын

    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.

  • @Pablo-no3sw
    @Pablo-no3sw2 жыл бұрын

    This worked for me: Windows+R > services.msc > MySQL80 > Start For some reason it was off

  • @Amit.Thinks

    @Amit.Thinks

    2 жыл бұрын

    After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: kzread.info/dash/bejne/mHqbxtCMYc_HcZM.html

  • @bahadrcolak27
    @bahadrcolak27 Жыл бұрын

    didnt work

Келесі