You can connect to your MySQL database to explore data, combine them with other data sources and build apps on top of them as a data foundation.
To connect your MySQL database, follow the steps below:
- 1.Go to Data Management and click on "New data source" to create a new data source.
- 2.Select MySQL from the list of available data sources.
- 3.Name your data source connection and provide the connection details:
The host url of the server the database runs on.
The port number through which the requests should run through. By default we set the port to 3306 since that's the usual port used for MySQL database requests.
The name of the database on the host that you wish to connect to.
Username & Password
These are the credentials of the user account that has the required access permissions for the database.
Connect using SSL
You can specify if you want to connect to the server using SSL. This is a default setting to ensure secure connection.
(optional) Use SSH tunnel
Specifies if the connection should run via SSH tunnelling. If you are familiar with SSH tunnelling, you will need to provide the following additional details. Once this option is toggled, we provide our public key for download.
- 4.Click on "Test connection" to ensure that your connection works reliably and save your data source connection with "Connect".
Note: You can configure the data source for two different environments, Staging and Production. You can find more information about it here.