Metabase can't connect to remote MySQL

Metabase is up and running in Linode 1 (Ubuntu 19.10). I can access it, add people, check logs…

MySQL DB is up and running in Linode 2 (Ubuntu 19.10). I can connect to it from another server(Even from Linode 1). So User Access is provided properly.

Still, when I try to add the DB from Metabase admin panel, I am getting the following error:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

1 Reply

Linode Staff

I'm not all that familiar with Metabase, but I wanted to try to help you out. This appears to be a connection error rather than anything wrong with your Metabase configuration.

I found a post on Stack Overflow that addresses the error that you posted. The suggestions that it gives involve taking a look at your version of mysql-connector-java, as it may need to be updated to a newer version. Here's the link:

MySQLNonTransientConnectionException Could not create connection to database server.

Another post I found when I searched for your error says pretty much the same thing:

Stack Overflow - MySQLNonTransientConnectionException

My recommendation is to update your version of the MySQL connector to the most recent, as is detailed through those links.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct