MySQL connector issues

PBSmith · July 2016

I am on a 60 day trial. I have MySQL (Aurora and straight-up MySQL) at Amazon RDS and an independent server, all of which I can access from my PC via MySQL Workbench. All of the servers are set to be publicly accessible.

I can't connect to any of them with Domo's MySQL connector this afternoon.

Failed to authenticate. Verify the credentials and try again. Could not establish a connection with the MySQL host; please check your settings and try again.

Any ideas?

Brad

Unknown · August 2016

Brad,

It is possible to connect to a MySQL database in the AWS environment. Domo requires that any database connection to have SSL enabled so that would be step one. You would also want to make sure that the Domo IPs are whitelisted and bi-directional traffic is enabled on the database and port that you are attempting to connect to. The list if IP addresses can be found in the Domo Help center under "Whitelist".

kshah008 · August 2016

Hi all,

Can anybody help @PBSmith out?

Thanks!

PBSmith · August 2016

I ultimately gave up and was able to work this out through the Workbench tool. I am curious, however, if others succeed connecting to MySQL at Amazon.

Unknown · August 2016

Brad,

It is possible to connect to a MySQL database in the AWS environment. Domo requires that any database connection to have SSL enabled so that would be step one. You would also want to make sure that the Domo IPs are whitelisted and bi-directional traffic is enabled on the database and port that you are attempting to connect to. The list if IP addresses can be found in the Domo Help center under "Whitelist".

kshah008 · August 2016

@PBSmith, did Archimedes' reply help you out?

PBSmith · August 2016

Yes, this took care of the issue. Thanks for the advice on enabling SSL.

Brad

MySQL connector issues

Best Answer

Answers

Categories