Error: ER_NOT_SUPPORTED_AUTH_MODE - Unable to Connect to MySQL Database

[vimalaathythan]

Please provide dev environment versions of your system

node -v ( xmysql requires node >= 7.6.0 )

npm -v = 8.15.0 mysql --version = 8.0.34 xmysql --version = undefined npm xmysql --version=8.15.0

---

Issue:

I encountered the following issue when trying to use xmysql to connect to a MySQL database:

To create a GitHub issue for the xmysql problem you're facing, follow these steps:

Title:

vbnet Copy code Error: ER_NOT_SUPPORTED_AUTH_MODE - Unable to Connect to MySQL Database Description:

markdown Copy code Environment:

• Node.js Version: node -v

arduino Copy code (xmysql requires node >= 7.6.0)

• npm Version: npm -v

diff Copy code

• MySQL Version: mysql --version

diff Copy code

• xmysql Version: xmysql --version

vbnet Copy code

Issue:

I encountered the following issue when trying to use xmysql to connect to a MySQL database:

C:\Users\Vimalaathythan>xmysql -h localhost -u root -p dfdfgd2309 -d world Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[Mike-Fink-Jr]

having the same problem

[ArchiLantern]

MySQL8版本对密码安全策略的问题，还是那个caching_sha2_password的问题 。。 参考这里：https://waylau.com/node.js-mysql-client-does-not-support-authentication-protocol/ 解决办法： ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';