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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive