MySQL Workbench Cannot Connect to Database Server -'caching_sha2_password' cannot be loaded

[@yashthakkar6231]

Thanks bro , you helped me today twice with mysql problems !

[@nateboorsma9634]

For those struggling because you who are receiving the error "Unable to connect to root: localhost 3306" or something like that. Boot up the MySQL Installer again. Select "Reconfigure" on the "MySQL Server" line and go through the normal process of installing the server you used the first time to create the Server (default selections are generally fine)... I used the same password. Once you click "Finish" on the installer, try connecting to your server again or entering your password in the MySQL Command Line. It worked for me (twice now) when I encountered this error. Hope this helps if you havent solved it yet.

[@BrucetheWayne]

thanks a lot, this tip worked for me as i had the same issue as well

[@999xMihox999]

Big Thx man! It was very useful for me. I had this error too int my ubuntu 18.04. It's worked for me. God Bless You!

[@sabbr92275656]

Mysql: [warning] c:\program files\mysql\mysql server 5.7\bin\mysql.exe : ignoring option '--no-beep' due to invalid value " Enter password: I entered password than close cmd!

[@deltaskyhawk]

Thanks .... this had me hair pulling on Linux Mint 19. Could not find any documentation on this issue. Your solution WORKED!

[@joaohenrico1988]

Me too rsrsrsrs

[@danpaolillo3168]

Thank you very helpful, the only other thing I noticed is that it helps prevent the same problem happening in the future if you change the MYSQL service to automatic

[@koolooc726]

as soon as i enter the password, the command client thing closes

[@erickcepeda4339]

Thanks big boss, Programmers love hindues

[@saisandeepivaturi287]

Hello, unfortunately, my command line crashes after I press enter right after typing my password. Please help,

[@srivivek3057]

wrong password brother

[@nateboorsma9634]

Check my comment above.

[@danielonehi2818]

Go to services and start SQL. Your problem will be solved

[@mihirsansare7804]

@@danielonehi2818 Thanks man u solved my problem

[@mihirsansare7804]

@@danielonehi2818 Thanks man u solved my problem

[@Mr.Indian662]

Really thanks you for making this video. Really it works and my database work properly.

[@okbatrad9748]

You're my hero, thnk you broo, rreally you helped me

[@juangonzalez3288]

Thanks brother I was having problems with this!

[@PushpendraKumar-ck8op]

command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

[@drakZes]

Where do I enter this if the client closes as soon as I enter a password. I put 'test' as my password but it says it's wrong. MySQL is a garbage framework. Don;t have this problem with MongoDB.

[@martinbalke1843]

Solved my problem after 2 hours thank you

[@TheIzaa77]

Hey, I get a syntax error -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified with mysql_native_password BY 'password'' at line 1- Can you help me out?:(

[@akware977]

Thanks a lot for this solution.Worked on Windows 10

[@yordanydiaz1397]

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show databases' at line 2

[@MirandaLuciasocool]

You need to close MYSQL, if you have it open

[@rohithreddy1764]

I’m getting an error saying authentication plug-in. My SQL native password cannot be loaded. The specified mod could not be found.

[@christinaslick987]

I ran that command & it returned Query OK. Restarted mySLQ services. Do not get the error in MySQL Workbench, but still get this exact error in my browser using LocalHost:3000. Any suggestions?

[@Harish_Vision]

I can't able to connect Mysql to Netbeans and throwing an error ' caching_sha2_password'

[@harshitraj8409]

Thanks bro , my problem is solved.

[@sanskratiagrawal4334]

there is error init. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234'' at line 1 plz reply as soon as posible

[@ashokkumark6756]

After doing also not opening......and so command client also not working properly when we press enter come out

[@mohammedzaidtech5942]

Thank you and if you have problem like That in MYSQL command line when you enter your password and it closes then simply restart MYSQL as I din't did that part and just simply restarted MYSQL in servises

[@vitorcarvalho9081]

Very good, thankyou for video

[@glenfernandes3661]

Really Appreciate this video

[@vipintekade6400]

services option also not showing in my desktop windows 10 ?

[@lamperougeone5831]

Thank you, finally got it to work!

[@bindur1540]

After entering the password cmd got closed Plz help me out

[@nateboorsma9634]

Check out my comment above.

[@benroshan3337]

@@nateboorsma9634 It is not available above

[@nateboorsma9634]

Ben Roshan apologies, ive copy pasted my comment here ---- For those struggling because you who are receiving the error "Unable to connect to root: localhost 3306" or something like that. Boot up the MySQL Installer again. Select "Reconfigure" on the "MySQL Server" line and go through the normal process of installing the server you used the first time to create the Server (default selections are generally fine)... I used the same password. Once you click "Finish" on the installer, try connecting to your server again or entering your password in the MySQL Command Line. It worked for me (twice now) when I encountered this error. Hope this helps if you havent solved it yet.

[@peterrae3619]

@@nateboorsma9634 Thanks for this, was reading through this thread for a solution. massive thumbs up to you

[@thessaz2588]

mine does not do anything after entering that code in command line. HELP

[@gabrieltargino8204]

Thank you dude! This help me so much

[@benedict6695]

Hello guys, I get this error while I am trying to connect my python file with 'sqlalchemy' to my mysql database (I'm using mysql workbench on win10 system): sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)") Any suggestion/ solution would mean a lot to me since I have been trying to solve this issue for 3 days. **side note: I have just installed mysql into my PC and I can log in to my mysql workbench; I do NOT have any problem installing and using mysql in my laptop. Thanks a lot guys!

[@AhmedAli-ns1ti]

It removed all my databases. what do I do now ?

[@vaibhavwahatule4158]

Thank you bro it's working 👍

[@vinittamoli8197]

i am facing this problem on jupyter window ,please send a solution for this

[@efealptekin160]

bro commend line doesnt work too

[@omarwasfi]

it works on linux also thanks .

[@ALBERTO-cr3gz]

thank you very much friend

[@juangranda3808]

hola amigos ami me funciono solo hasta que puse la contraseña en la terminal y despues cerre el mysql y lo volvi abrir y puse la contraseña y ya no me salio ese error que suerte tuve.

[@lucasfrancisco1502]

I had a little problem: I don't remember my password. How can I recover it?

[@jinujawad]

U can Reset password first. Check the description. I have another video on that

[@prudhvimunjeti9232]

Bro i even cannot save password bro please help me to sort it out

[@markus1285]

worked for me, thx!

[@dkm865]

You are life saviour !

[@oleghalat3140]

You are the best !!!!!!!!!!!!!!!!!!!

[@radhikamundada6776]

nahi chal raha hai bhaiya ... kya karu madat karo

[@laurap5242]

Thank youuuuu!!!!! I save your video

[@adrluis7]

thanks bro! your amazing

[@johandejager629]

cannot hear anything.....

[@shaiknazeer7307]

Iam not getting

[@vipintekade6400]

even if i remember my password root .I typed in sql command line .It suddenly got closed what should i do replay it to me please .

[@jinujawad]

go to services and start mysql service, it might be stopped.

[@vipintekade6400]

@@jinujawad I restart my system now it is working.

[@GSTamer]

@@vipintekade6400 not your system, the service, Go to services and then look for mysql. Then right click and start it

[@vipintekade6400]

@@GSTamer I have restrart my system it is working fine.

[@jhonny9378]

I don't know my pass '-'

[@saurabhamle150]

this was helpful.

[@subhajitroy4148]

thnx buddy...

[@BepDieuThao]

thanks so much

[@shishir6270]

nice bro

[@renzosanantonio5952]

Thank you so much!!

[@petarkolev6928]

Way to go man! Thank you for the video

[@sergiocotero6622]

Qué pasa? 🤙

[@paulcatalanlara3200]

thanks bro

[@ashut0ast23]

Gracias

[@justanotherperson4409]

Thanks

[@suga3025]

thanks, you are awesome!

[@jihanei4889]

Merciii

[@raghavgade2000]

DUDE , THANK YOU

[@default-126]

Useful

[@BlackHatWorld192]

thanks

[@matheus12henq78]

amazing, ty

[@joanneko3953]

thank you!

[@ДарьяТихонова-ч2я]

Thank you!!!!

[@Ache148]

Спасибо

[@mauweb1797]

Gracias

[@khaledibrahim96]

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

[@shruthikumar3692]

Thank you ☺️

[@harithaa4046]

Thank you so much bro

[@gkarthik55]

Thank you Bro

[@JavierFC195]

thanks men

[@sainaik9969]

Thank you bro

[@emmanuelarchibong9378]

Thanks a lot

[@henriquewirzbergerlima7220]

thank you..