error connecting to MariaDB: ER_NOT_SUPPORTED_AUTH_MODE

  • 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?

  • 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.

  • @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 ...

Suggested Topics

| | | |