ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server error
Hello Guys,
In this video, I have discussed an error with code ER_NOT_SUPPORTED_AUTH_MODE. In detail we can say it Client does not support authentication protocol requested by server. This kind of error occurs in Node JS or TS projects when we try to access or get the connection with MySql database using connection pool.
This error code ER_NOT_SUPPORTED_AUTH_MODE is not related to the Application level error but is related to MySql authentication. We can easily resolve this error just by using the below-written SQL Query in MySql Workbench as shown in the video.
MySql Query for resolving Client does not support authentication protocol requested by server error:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password@123';
Go to this link to take the test to identify yourself.
https://oktests.com/
Like us on Facebook: / oktests
Watch video ER_NOT_SUPPORTED_AUTH_MODE Client does not support authentication protocol requested by server error online without registration, duration hours minute second in high quality. This video was added by user localhost 22 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16,093 once and liked it 176 people.