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.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive