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

johnwick · May 16, 2022, 12:18pm

System Information

Strapi Version: v4
Operating System: macOS
Database: mySQL
Node Version: 16.15.0
NPM Version: 8.5.5
Yarn Version: 1.22.18

I am trying to connect my strapi app with MySQL database, for the same I am using the mySQL with docker (I have the latest version of sql in that image). After creating the app using custom method when I run the npm run develop, the command fails with an error:

debug: ⛔️ Server wasn't able to start properly.
[2022-05-16 17:44:06.850] error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Marc.th1 · October 11, 2022, 2:47pm

You have to check “Use Legacy Password Encryption” in your mysql installation.
On mac if you have mysql installed you can change it under: system preferences, MySQL, Initialise Database.

oooop_Overhere · July 10, 2023, 1:29pm

after I do that, I have another error:
code: ‘ER_ACCESS_DENIED_ERROR’,
errno: 1045,
sqlMessage: “Access denied for user ‘root’@‘localhost’ (using password: YES)”,
sqlState: ‘28000’,
fatal: true

hieutm1511 · August 23, 2023, 6:21am

Did you fix this error? I have the same problem with you

johnwick · May 9, 2024, 12:11pm

isn’t this a mysql authentication issue?

Strapped · July 26, 2024, 12:32pm

There is some good information at the bottom of this thread:

github.com/strapi/strapi

MySQL8: Client does not support authentication protocol requested by server

opened 01:31AM - 14 Jul 22 UTC

closed 09:10AM - 29 Mar 23 UTC

benderillo

issue: enhancement source: core:database

## Bug report ### Required System information - Node.js version: 16 - Strap…i version: 4.2.2 - Database: MySQL 8 - Operating system: Mac ### Describe the bug **TL;DR** Mysql database driver used by Strapi does not support the new authentication method that MySQL8 uses by default. This generates error: ``` Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client ``` **Long story** Currently Strapi uses `mysql` npm package as a driver to connect to MySQL database. This package does not support the new authentication method (`caching_sha2_password `) which some MySQL8 hosted databases use by default. For example, if you deploy on Railway.app, their mysql db will refuse connection. The solution can be either lower the security of the Database by configuring it to use the old `mysql_native_password ` auth method or use another package for mysql driver which supports the authentication: [mysql2](https://www.npmjs.com/package/mysql2) The details can be found in this answer in stackoverflow: https://stackoverflow.com/a/56509065/985942 Unfortunately, using the `mysql2` package as a driver for the DB fails because strapi passes the client name ('mysql') as a package name to "knex" so the "knex" fails to find such a package upon loading. Specifying a "mysql2" as a client in the config file fails too as the Strapi database package has explicit checks for "mysql" client name. This ticket is to ask to add support for the `mysql2` driver to strapi so developers can opt to install it instead of the `mysql`. Since the `mysql2` package is mostly API compatible with the `mysqljs` it should be an easy fix to treat the driver `mysql2` the same way as the `mysql`. ### Steps to reproduce the behaviour 1. Create a new strapi project and configure it to use MySQL database 2. Install a MySQL8 database and configure project to connect to it. 3. Run Strapi project and observe it fails to connect because of the `ER_NOT_SUPPORTED_AUTH_MODE` error. 4. Install mysql2 `npm install mysql2` and change the database configuration to use "mysql2" driver. 5. Try to run Strapi and observe that it fails as the driver is not supported. ### Expected behaviour Should be able to select "mysql2" as a driver for a MySQL database. **UPDATE** PR for this issue: https://github.com/strapi/strapi/pull/13775

You can now use the mysql2 package instead ad also mentioned in the note at the bottom of the strapi documentation: