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