MySQL

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.

Connecting to your MySQL Database

To connect your MySQL database, follow the steps below:

  1. Go to Data Management and click on "New 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:

Setting
Description

Hosts

The host url of the server the database runs on.

Port

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.

Database name

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.

  • Bastian host

  • Bastian port

  • SSH user

  1. 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.

PreviousMongoDBNextOpenAI

Last updated