Node.js can’t authenticate to MySQL 8.0

by

MySQL 8.0 uses a new default authentication plugin – caching_sha2_password – whereas MySQL 5.7 used a different one – mysql_native_password. Currently, the community Node.js drivers for MySQL don’t support compatible client-side authentication mechanisms for the new server plugin.

A possible workaround is to alter the type of user account to use the old authentication plugin:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyNewPass';

Or create a different one that uses that same plugin:

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'bar';

There’s a pull request in pipeline to properly address the issue.

Another option is to use the official MySQL Node.js connector (full disclosure: I’m the lead dev), which is based on the X Protocol and already supports the new authentication mode.

More Related Contents:

  1. How do you use the “WITH” clause in MySQL?
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  4. MySQL with Node.js
  5. node-mysql multiple statements in one query
  6. nodejs mysql Error: Connection lost The server closed the connection
  7. How do I do a bulk insert in mySQL using node.js
  8. MySQL root access from all hosts
  9. How to grant all privileges to root user in MySQL 8.0
  10. phpMyAdmin on MySQL 8.0 [duplicate]
  11. node.js mysql error: ECONNREFUSED
  12. How to auto generate migrations with Sequelize CLI from Sequelize models?
  13. How to access a RowDataPacket object
  14. Retrieve last inserted id with Mysql
  15. How to pass parameters to mysql query callback in nodejs
  16. Making changes to multiple records based on change of single record with SQL
  17. node.js + mysql connection pooling
  18. How to connect to MySQL from the command line
  19. How to make join queries using Sequelize on Node.js
  20. NodeJS MySQL Dump
  21. Node.js connect to MySQL Docker container ECONNREFUSED
  22. Use promise to process MySQL return value in node.js
  23. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  24. Error in MySQL library for Node.js
  25. Which ORM should I use for Node.js and MySQL? [closed]
  26. find number of rows in returned mysql result (nodejs)
  27. MySQL giving “read ECONNRESET” error after idle time on node.js server
  28. Counting associated entries with Sequelize
  29. In MySQL SERVER 8.0 the PASSWORD function not working
  30. INSERT INTO fails with node-mysql

Leave a Comment