sequelize支持mysql版本_Sequelize不会支持MySQL 8自动化协议，我也不会更改该协议

I'm trying to migrate a db with Sequelize working with MySQL 8.0.15, but I'm not able to do that. I keep receiving this error message.

Sequelize CLI [Node: 10.15.0, CLI: 5.4.0, ORM: 5.3.5]

Loaded configuration file "config/config.json".

Using environment "development".

ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I've tried every single solution for this problem. The thing is when i try to change the MySQL root password the message i get is this one:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Then I did try to change the password validate policy following this procedure

then MySQL crashed cause it's deprecated. Then I tried this one

Then I got this

mysql> INSTALL COMPONENT 'file://component_validate_password';

ERROR 3529 (HY000): Cannot load component from specified URN:

'file://component_validate_password'.

Then I checked where the component is

ls /usr/lib64/mysql/plugin/component_v*

/usr/lib64/mysql/plugin/component_validate_password.so

Anyone can help? I'm realy out of options, now!

Thanks in advance

解决方案

If you want to use MySQL 5.x style authentication, typically all you have to do is add this to your my.cnf:

[mysqld]

default_authentication_plugin=mysql_native_password

Do this before adding any users. Only use users for connecting via Sequelize, never root.