I get this error message today connecting Local MySQL Database to Metabase, previous day it was okay
Could not connect to address=(host=127.0.0.1)(port=33062)(type=master) : Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'
I wonder why? the password also already defined as mysql_native_password in the settings
Hi @vangz
Please post “Diagnostic Info” from Admin > Troubleshooting.
Which version of MySQL?
So nothing has changed and you didn’t restart MySQL or Metabase (or the machine) and it just stopped working?
Just try to connect again today, its successful today, I think I will post here if I get any more failed occurences again, thankyou @flamber
Any ideas on what causes this? I ran into this today where suddenly Metabase was unable to connect. At first the error it gave required Flushing Hosts. However once I flushed the hopes it told me it didn’t support caching_sha2_password, then once I changed it’s user to mysql_native_password for the user, it told me that it doesn’t support mysql_native_password giving me the error posted above by @vangz.
Really not sure what to do.
@nick-sbp Please post “Diagnostic Info” from Admin > Troubleshooting.
Have you tried restarting MySQL or Metabase?
It’s difficult to understand without the full errors and where you did what.
{:database_id 10,
:started_at #t "2021-03-19T18:04:19.960820Z[UTC]",
:via
[{:status :failed,
:class java.sql.SQLNonTransientConnectionException,
:error
"Could not connect to address=(host=xxx)(port=3306)(type=master) : Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'",
:stacktrace
["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)"
"org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)"
"org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1372)"
"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/java.sql.DriverManager.getConnection(Unknown Source)"
"java.sql/java.sql.DriverManager.getConnection(Unknown Source)"
"--> connection_pool$proxy_data_source$reify__34149.getConnection(connection_pool.clj:29)"],
:state "08004"}
{:status :failed,
:class com.mchange.v2.resourcepool.CannotAcquireResourceException,
:error "A ResourcePool could not acquire a resource from its primary factory or source.",
:stacktrace
["com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)"
"com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)"
"com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)"
"com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)"
"com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)"
"com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)"
"--> driver.sql_jdbc.execute$fn__77477.invokeStatic(execute.clj:155)"
"driver.sql_jdbc.execute$fn__77477.invoke(execute.clj:153)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
"driver.sql_jdbc$fn__79102.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__79102.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46414.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__45666.invoke(check_features.clj:41)"
"query_processor.middleware.limit$limit$fn__46400.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:184)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:175)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__45324.invoke(cache.clj:210)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46579.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44470.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40787.invoke(wrap_value_literals.clj:147)"
"query_processor.middleware.annotate$add_column_info$fn__40650.invoke(annotate.clj:582)"
"query_processor.middleware.permissions$check_query_permissions$fn__45541.invoke(permissions.clj:75)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47102.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45739.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47415.invoke(resolve_joined_fields.clj:94)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__47720.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44064.invoke(add_implicit_joins.clj:181)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__46375.invoke(large_int_id.clj:44)"
"query_processor.middleware.format_rows$format_rows$fn__46355.invoke(format_rows.clj:74)"
"query_processor.middleware.desugar$desugar$fn__45805.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__44830.invoke(binning.clj:228)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45348.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__43694.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43925.invoke(add_implicit_clauses.clj:146)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48150.invoke(upgrade_field_literals.clj:45)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44217.invoke(add_source_metadata.clj:122)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47299.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44417.invoke(auto_bucket_datetimes.clj:139)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45395.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__47084.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45447.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__46061.invoke(expand_macros.clj:155)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__44226.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48086.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47310$fn__47314.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47310.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46301.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__48095$fn__48096.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48095.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__48157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__46427.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44082.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48071.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__45682.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__47173.invoke(process_userland_query.clj:135)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__45625.invoke(catch_exceptions.clj:173)"
"query_processor.reducible$async_qp$qp_STAR___37428$thunk__37429.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___37428$fn__37431.invoke(reducible.clj:108)"]}
{:status :failed,
:class java.sql.SQLException,
:error "Connections could not be acquired from the underlying database!",
:stacktrace
["com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)"
"com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)"
"com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)"
"--> driver.sql_jdbc.execute$fn__77477.invokeStatic(execute.clj:155)"
"driver.sql_jdbc.execute$fn__77477.invoke(execute.clj:153)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
"driver.sql_jdbc$fn__79102.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__79102.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46414.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__45666.invoke(check_features.clj:41)"
"query_processor.middleware.limit$limit$fn__46400.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:184)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:175)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__45324.invoke(cache.clj:210)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46579.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44470.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40787.invoke(wrap_value_literals.clj:147)"
"query_processor.middleware.annotate$add_column_info$fn__40650.invoke(annotate.clj:582)"
"query_processor.middleware.permissions$check_query_permissions$fn__45541.invoke(permissions.clj:75)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47102.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45739.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47415.invoke(resolve_joined_fields.clj:94)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__47720.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44064.invoke(add_implicit_joins.clj:181)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__46375.invoke(large_int_id.clj:44)"
"query_processor.middleware.format_rows$format_rows$fn__46355.invoke(format_rows.clj:74)"
"query_processor.middleware.desugar$desugar$fn__45805.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__44830.invoke(binning.clj:228)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45348.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__43694.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43925.invoke(add_implicit_clauses.clj:146)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48150.invoke(upgrade_field_literals.clj:45)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44217.invoke(add_source_metadata.clj:122)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47299.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44417.invoke(auto_bucket_datetimes.clj:139)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45395.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__47084.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45447.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__46061.invoke(expand_macros.clj:155)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__44226.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48086.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47310$fn__47314.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47310.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46301.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__48095$fn__48096.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48095.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__48157.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__46427.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44082.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48071.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__45682.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__47173.invoke(process_userland_query.clj:135)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__45625.invoke(catch_exceptions.clj:173)"
"query_processor.reducible$async_qp$qp_STAR___37428$thunk__37429.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___37428$fn__37431.invoke(reducible.clj:108)"],
:state nil}],
:state "08004",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true},
:native
{:template-tags
{"SKU"
{:id "7e6205ae-1252-e53b-00f9-a17003684c55",
:name "SKU",
:display-name "Sku",
:type :dimension,
:dimension [:field-id 25383],
:widget-type :category,
:default nil},
"barcode"
{:id "c83d8942-1e3f-d904-66fd-b654ed069643",
:name "barcode",
:display-name "Barcode",
:type :dimension,
:dimension [:field-id 25377],
:widget-type :category,
:default nil},
"description"
{:id "e1dff404-86c7-5dad-ba14-e90157e1ced9",
:name "description",
:display-name "Description",
:type :dimension,
:dimension [:field-id 25384],
:widget-type :category,
:default nil},
"date"
{:id "8bc8babd-f9c5-6718-8881-120999a2605d",
:name "date",
:display-name "Date",
:type :dimension,
:dimension [:field-id 25386],
:widget-type :date/range,
:default nil}},
:query
:database 10,
:parameters [],
:async? true,
:cache-ttl 305},
:status :failed,
:class java.sql.SQLException,
: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/java.sql.DriverManager.getConnection(Unknown Source)"
"java.sql/java.sql.DriverManager.getConnection(Unknown Source)"
"--> connection_pool$proxy_data_source$reify__34149.getConnection(connection_pool.clj:29)"],
:context :question,
:error
"Client does not support authentication protocol requested by server. plugin type was = 'mysql_native_password'",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
I have restarted MySQL
I’m not hosting the Metabase instance itself, however I can submit a ticket to have it restarted
@nick-sbp Are you using Metabase Cloud?
Can you try going to Admin > Databases > (your-mysql) > and without changing anything, just press Save, which should flush any existing connections and make it reconnect again.
If that doesn’t work, then might need to get a restart of Metabase. I have seen this once before and a restart solved the problem. Think it’s a problem in the MariaDB driver.