[*] Technical - Sequelize is not compatible with MySQL till V8.X.X

[SteveBunlon]

Expected behavior

Sequelize should be able to connect to MySQL V8.X.X

Actual behavior

Sequelize can't create a connection to MySQL database with version starting at 8.X.X

Failure Logs

Context

When using a MySQL database with version 8, the MySQL connector within Sequelize (mysql2) is not able to establish a connection. This is due to the new authentication plugin from MySQL that connectors do not support so far.

• Package Version: Every version
• Sequelize Version: 5.8.6
• Database Dialect: MySQL
• Database Version: 8.X.X

Workarounds :

• Run the following queries :
  ALTER USER ‘YOURUSER’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘YOUR_NEW_PASSWORD’;
  FLUSH PRIVILEGES;
• Reinstall MySQL and don't use the new authentication mechanism.
• Downgrade to previous version of MySQL