Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol SOLVED in mysql
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol SOLVED in mysql
How to solve node js Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client is shown
Content
0.24 -> hey hello everyone in this video i'll be showing
you how to solve the error er not supported
5.76 -> auth mode client does not support authentication
protocol requested by server so i'm getting this
10.24 -> error when i try to connect node.js with my local
mysql so here i'm having just like a sample code
15.92 -> here i've just given my user password and here's
the connection and i'm just printing the error and
21.12 -> that's the reason why this is getting displayed
so the simplest way to solve this problem is you
25.52 -> have to go to your local mysql so here i'm using
my sql workbench if you're having your normal
30.64 -> mysql shell you can go there just open it and you
need to just go inside your connection okay just
36.08 -> click it and type your password and go inside
your connection and here what you are typing is
42.48 -> alter user and within single quotes you need
to specify the name of the user so here in my
49.6 -> case the name of the user is root so i will just
put root over here and @ single quote localhost
59.68 -> close the single quote and
you have to type identified
65.52 -> with mysql underscore native underscore
password okay and you need to type by
76.8 -> and here you need to specify the password okay
the change password so here i'm having currently
81.36 -> password as one two three four five so let
me just change it as root123 like that okay
89.84 -> so that's it so i will just move this to the next
line so this is the entire thing okay you can type
94.64 -> it in a single line itself so after typing
this all like be careful that you don't have
99.52 -> any errors and just run it so you will be getting
here a green mark so after this i have changed my
105.68 -> user's password to root one two three
so let me just copy this password
109.92 -> and instead of this one two three four five i will
just paste it over here okay so now let me just
116.64 -> save this another important thing
you have to just save your code okay
120.24 -> save it and just come down i will just
clear everything and again start the server
130.64 -> and this time you can see i'm getting
connected that's because it's the else
134 -> block is getting displayed that means this
error is false or we are not getting any error
138.8 -> so i hope you would have solved your error
and found this video useful mine is a
141.76 -> programming channel i've done many videos
in sql queries c c plus plus java python
146.32 -> node.js react.js as well so do check other videos
of my channel subscribe me and thanks for watching
Source: https://www.youtube.com/watch?v=W2TuIx2y4kw