SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MariaDB client

mysql node.js database mariadb sequelize.js

I found the answer:

use mysql;

update user set authentication_string=password(''),plugin='mysql_native_password' where user='root';

mysql node.js database mariadb sequelize.js

in my case I needed to type these 3 lines:

use mysql;update user set authentication_string=password('new_root_password'), plugin='mysql_native_password' where user='root';flush privileges;

mysql node.js database mariadb sequelize.js

In case you are using higher versions of mysql, you don't need to use password function. Instead you can write it as below

use mysql;update user set authentication_string='new_root_password', plugin='mysql_native_password' where user='root';flush privileges;

CodeHunter