Metabase v0.39.4 connects to mysql8 errors happened

metabase v0.39.4, connects to mysql8, error :Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'. We changed to version 39.2,it's was running successful on the same database.

our mysql 8 configuration :
+------------------+-----------+-----------------------+
| USER | HOST | PLUGIN |
+------------------+-----------+-----------------------+
| root | % | mysql_native_password |
| mysql.infoschema | localhost | mysql_native_password |
| mysql.session | localhost | mysql_native_password |
| mysql.sys | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
Logs:
stacktrace
["org.mariadb.jdbc.authentication.AuthenticationPluginLoader.get(AuthenticationPluginLoader.java:52)"
"org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:727)"
"org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:546)"
"org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1367)"
"org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)"
"org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)"
"org.mariadb.jdbc.Driver.connect(Driver.java:89)"
"java.sql.DriverManager.getConnection(DriverManager.java:664)"
"java.sql.DriverManager.getConnection(DriverManager.java:208)"
"--> connection_pool$proxy_data_source$reify__35108.getConnection(connection_pool.clj:29)"],
:context :ad-hoc,
:error
"Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'",
:row_count 0,
:running_time 0,
:preprocessed
{:database 2,
……

{
  "browser-info": {
    "language": "zh-CN",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "1.8.0_281-b09",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_281",
    "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "25.281-b09",
    "os.name": "Linux",
    "os.version": "3.10.0-862.14.4.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Asia/Shanghai"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "mysql",
      "sparksql"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "5.7.33"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.6.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "tag": "v0.39.4",
      "date": "2021-06-15",
      "branch": "release-x.39.x",
      "hash": "f538050"
    },
    "settings": {
      "report-timezone": "Asia/Shanghai"
    }
  }
}

Hi @feego
Instead of creating multiple issues and topics, then let's keep everything in one place:
https://github.com/metabase/metabase/issues/16710

reger that~