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.
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:
Another post I found when I searched for your error says pretty much the same thing:
My recommendation is to update your version of the MySQL connector to the most recent, as is detailed through those links.