error connecting to MariaDB: ER_NOT_SUPPORTED_AUTH_MODE

[Jürgen]

I cloned the ubb import (nodebb-plugin.import-ubb) in order to write my own importer for a self written forum.

I tried to import out of a MariaDB:

/usr/bin/mysql --version
/usr/bin/mysql  Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

and received the following error:

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client {"code":"ER_NOT_SUPPORTED_AUTH_MODE","errno":1251,"sqlState":"08004","fatal":true}

Upgraded the mysql driver to

   "mysql": "~2.4.2"
   "mysql": "~2.18.1",

but error stayed the same.
Is there a recommendation to solve this problem?

[nhl.pl]

Your problem comes from MariaDB/MySQL and you'll find solution on Stack Overflow or GitHub.

For example you can downgrade MariaDB (older versions use SHA256_password auth and your version uses sha2_password auth) to solve problem.

[Jürgen]

@nhl-pl
thx for that advice. Already thought about this and started to use a mysql using the old authentification methods - will know about the results later ...