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

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

thanks bro! your amazing

DUDE , THANK YOU

thnx buddy…

thanks men

Thanks

This was straight to the point. Thank you.

If any of you are getting a problem where your command line crashes after you enter your password..
use this link: https://mccshreyas.wordpress.com/2018/01/07/how-to-fix-mysql-command-line-crashing-problem/
It helped me before i was able to solve my problem with this video.

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

services option also not showing in my desktop windows 10 ?

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 .

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

Thanks!!!

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.

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

thank you!

thanks

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

Mysql: [warning] c:program filesmysqlmysql server 5.7binmysql.exe : ignoring option '–no-beep' due to invalid value "
Enter password:

I entered password than close cmd!

Thanks a lot for this solution.Worked on Windows 10

Thank you Bro

After entering the password cmd got closed
Plz help me out

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

Thanks bro , my problem is solved.

Way to go man! Thank you for the video <3

Thank you so much!!

is anyone getting this error while using Eclipse???

Thank you!!!!

Solved my problem after 2 hours thank you

Worked for me, Thanks!!

thank you very much friend

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

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

this was helpful.

Useful

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!

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

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

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?