MySQL
An overview of the MySQL integration with Secoda
Getting Started with MySQL
There are three steps to get started using MySQL with Secoda:
Create a database user
Connect MySQL to Secoda
Whitelist Secoda IP Address
Create a Database User
The username and password you’ve already created for your cluster is your admin password, which you should keep for your own usage. For Secoda, and any other 3rd-parties, it is best to create distinct users.
To create a new user, you’ll need to log into the MySQL database directly and run the following SQL commands:
When connecting to MySQL in Secoda, use the username/password you’ve created here instead of your admin account.
Connect MySQL to Secoda
After creating a MySQL user, the next step is to connect Secoda:
In the Secoda App, select ‘Add Integration’ on the Integrations tab
Search for and select "MySQL"
Enter your MySQL credentials
Click 'Connect'
Security
VPCs keep servers inaccessible to traffic from the internet. With VPC, you’re able to designate specific web servers access to your servers. In this case, you will be whitelisting the Secoda IPs to read from your data warehouse.
Allow Secoda to read into your MySQL database using the Secoda IP address.
Last updated