FIX ERROR: Client does not support authentication protocol requested by server

How to fix MySQL error: ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server; consider upgrading mysql client
*************************
How to create a new MySQL user with old authentication method:
CREATE USER 'sqluser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';
FLUSH PRIVILEGES; .
***********************************
🔥 Complete Udemy Courses :
ASP.NET MVC Course : www.udemy.com/...
ASP.NET Course : www.udemy.com/...
ASP.NET Core Web API : www.udemy.com/...
React JS : www.udemy.com/...
⬇️ Free Document Proofreading ⬇️
► Grammarly : grammarly.go2c...

[@westpoint7942]

Yep, your method works for a containerized mysql instance. Instead of many others that looks very similar. Who knows why. May be there is a difference between 'foo'@'%' and 'foo2'@'localhost'.
Thank you, man !

[@sudhanshukumar4586]

Minor mistake... * is missing in GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';... so the new command will be GRANT ALL PRIVILEGES ON **.** TO 'sqluser'@'%';..
Thanks

[@necmettinsargn667]

Thanks brother

[@uthirarajranganathan7835]

Thanks a lot, I was breaking my head with this issue. I am using VS in Ubuntu, but the commands were working in terminal as well! I became your fan Bro!!!!

[@julianandolfatti3359]

Thank you very much!!! You save my day, i start learnig SQL and had this problem just from the start. You hava my like and subscription!!!

[@kaargen]

Thanks a lot! this was the only guide I could find that didn't skip a step.

[@bobbycv64]

Thank you Sir. Worked perfectly.

[@Lvasche]

I was looking for an answer for 3 weeks in a row, as nothing helped me from the net. You are messiah

[@haryakumuda6798]

am I the only one who still cant fix this? still doesn't support authentication protocol requested by server.
I get this warning " 4058 1 factor authentication method does not match against authentication policy"

[@haryakumuda6798]

please help

[@MichaelBrima-ld9lo]

I have been trying to solve this problem for days now, thank you so much!!!

[@SkiInsane]

Awesome video! Worked perfectly for me, thank you!!!

[@Maksimka-vc8fw]

Thanks ALOT. But change second comand in the discription, you missed * around the dot)))

[@Jean-Christophe974]

thank boss you save my life with gatsby-source-mysql plugin!

[@tonyccorimanya2482]

doesn't work for me, the same problem again and again

[@tahirpk9297]

2nd command is giving me error

[@re-peteafter-me2008]

It has worked. Thanking you.

[@TheLotus24]

Bro thank so mucho! just I needed watch 3 minutes of you video, thank u thank u

[@nopaallo1147]

Can confirm this worked, thank you.

[@swan_e]

Thanks! Worked perfectly!

[@miguelvologodskiy7907]

You're just awesome! Thanks a lot!

[@yulialanz.2246]

Thank you so much. Shortly and clear. It was really helpful

[@_Spread_Positivity_]

Can you please help me with this error , i followed every step but after save connection it is giving this error and also the disconnect icon is not present for me ... please help
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[@anonymushadow282]

x2

[@andressuarez1]

Thank you sir for your kind and conscious explanation.

[@kimokimo-se3ur]

really thank you !! you just saved my day :) ! keep shining !

[@nicolasmaia6315]

You're GREAT man, thanks a lot!!

[@inna7680]

Thank you!!! It's working!!

[@porvoce2697]

Thank you, works here!!

[@talarbiv7068]

its says 'mysql' is not recognized
can someone help pls?

[@StrikerSixterGamer]

if you are talking about the error in cmd, watch this video: ruclips.net/video/yvBbSurPEgA/видео.html
is brazilian portuguese but you must understand

[@belkYT]

ATTENTION! this is outdated and does not work anymore! use another technique

[@felicianovitullo620]

Excelente, me soluciono el problema!

[@RinInABin]

You're a lifesaver, tysm 😁

[@bruno.nascimento]

Thank you sooooooo much!!! You saved my project too. 😀

[@denilsonmucavel8150]

Thanks a lot brow it helped me. Hugs from Mozambique

[@petrabayu9676]

thank u so much,finally i find something to fix my error and it work.

[@krzysiek1918]

Thank you sooooooo much!!! You saved my project :)

[@gopalks6437]

Thanks a ton ! You are just amazing !

[@SpyrosMetallinos]

Thank you so much! simple video and to the point

[@luyonjostephen8746]

Why is it that when I try checking the mysql version it returns an error "mysql is not recognized as in internal or external command, operable program or batch file."?

[@MartinEzequielMonzon]

It might be a little late to answer this question, and you may have already solved it. But basically the problem is that it wasn't added to the system's enviroment variables.

[@thuctranvan4630]

Thank you so much. You save my day. I take a lot of time to solve it.

[@erwinerickson7356]

It works.. thankssssss!!!

[@arielcampos2008]

Thank you so much, it worked perfectly.

[@jahzielperalta484]

I tried exactly but it didn't work for me :(

[@miguelflores9706]

Thanks man you rock!!!!!

[@PolatjonQurbonov]

soooo BIG thank you !!!!

[@richardrivadeneyra950]

Muchas gracias! finalmente pude conectarme

[@werosinc585]

Thank you !!

[@duncanmwangi3468]

It worked fo me

[@kondurukm]

Very useful tip and it worked fine.

[@RahulSk-rj6cu]

Thank you so much it's working

[@cedardaniel2160]

Thank you so much. This was really helpful

[@VladStashek]

cool but how to make the new authentification method work?

[@Carsten_Hoett]

That was a super tipp, helped me a lot

[@matthewtang5638]

Many thanks!

[@davidattah1629]

This was very Helpful

[@kevin.bolanoa]

Muchas Gracias!!!!!!!!!!!!!!!!!!!

[@reezmg188]

After 4 hours of struggling finally

[@muhsinertekin823]

how tf im getting a syntax error, tried like 10 times...

[@reluo]

God damn thank you so much !

[@AleksandrKulikov-r3c]

Good job ! Than you !

[@A-Miracle000]

Thank you

[@georger844]

thanks man, nice video

[@transantiago31]

thank you!

[@lisan274]

I love you

[@LuisGonzalez-gv1yb]

Thanks!!!!

[@facemonda]

Thnaksss

[@luvasluvasluvas]

thank you, thank you THANK YOU

[@BoostMyTool]

You're welcome

[@faizan4712]

great job

[@TheMapleSight]

Wow, thanks

[@StrikerSixterGamer]

THANK YOU

[@timothyli3360]

THANKS BRO

[@eorria9643]

thanks bro!

[@a.t.y7]

Password? What password you add here?

[@darksnake1495]

thank you

[@BoostMyTool]

You're welcome

[@lewlinantony4626]

thanks u ❤

[@عليسعد-ح3ك5ذ]

not working

[@freespeech515]

do not work

[@alinesinclaire2854]

IF this query throw an error:
GRANT ALL PRIVILEGES ON . TO 'sqluser'@'%';
don't forget to put the * (as in the video):
GRANT ALL PRIVILEGES ON *.* TO 'sqluser'@'%';

[@LBMello-qn8xx]

🤌👍

[@oloruntobakayode8748]

Thank you so much. I've been on this for days

[@bastianvalero4612]

Thank you!

[@dawidglap]

Thank you!

[@davidbokil2614]

THANK YOU!!

Thank you!

[@nuzz.e92]

THANK YOU!

[@alinabolotbekova146]

Thank you!!!

[@nacheo2576]

i love you bae

[@romanmotovilov129]

Thanks a lot!

[@BoostMyTool]

You're welcome

[@rockysaini9604]

Thanks a lot!

[@BoostMyTool]

You're welcome