How to use a MySQL advanced security account
Hi,
I am on a 30-day trial with Domo, and I'm trying to connect to a Google CloudSQL instance.
I've whitelisted all necessary IPs on my instance and enabled SSL. However, when I try to use the MySQL connector I receive this error message:
I've looked around and found a "MySQL Advanced Security" account type (under the list of possible accounts I can create in Domo) which seems exactly what I need, because it lets me specify not only the CA certificate but also the SSL Certificate and SSL Key. I've created one, it seems to work but if I go under the MySQL connector it forces me to create a completely new account: I don't have the option to use the advanced security one I already have.
Am I doing something wrong, or is it because I'm on a trial that I can't use this type of account?
Many thanks if you can help me.
Simona
Comments
-
Hi Simona,
There's 2 versions of the MySQL connector avaiable, MySQL and MySQL SSH. The Advanced Security account corresponds with a version of the MySQL connector that was deprecated.
I'd suggest confirming if you are able to connect to your Google CloudSQL database using MySQL Workbench. The only requirements we have for the MySQL connector are:
The username and password you use to log into your MySQL database
The host name for the database
The port number for the database
The database name or schema name
The SQL query you will use to pull data
SSL
You can also include the URL where your SSL CA Certificate is located, though this is optional.
Thanks,
Aaron S.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有