Connect MySQL

Follow this step-by-step guide to connect your SQL databases (MySQL, PostgreSQL, and AlloyDB) to Airbook.

Connecting MySQL Databases

1. Navigate to Connections:

   • In your Airbook workspace, click on the "Connections" tab located on the sidebar.

2. Select MySQL:

   • From the list of available data sources, select "MySQL."

3. Enter Connection Details:

   • You’ll need the following information to connect:

     • Host: The hostname or IP address of your MySQL server.

     • Port: The port number for MySQL.

     • Database Name: The name of the database you want to connect to.

     • Username: Your MySQL username.

     • Password: Your MySQL password.

4. Whitelist Our IP Address:

   • To ensure seamless connectivity and the ability to query your database without interruptions, please whitelist our IP address: 34.122.205.142. This step is crucial for establishing a secure and stable connection between your database and Airbook, allowing us to retrieve and analyze your data effectively. Whitelisting our IP address will help avoid any network or security blocks that could prevent successful data queries.

5. Test Connection:

   • Click the "Submit" button to ensure Airbook can connect to your MySQL database. If the test is successful, you'll see a success message. Otherwise, you'll be prompted to make the required corrections to your database credentials.

6. Save and Connect:

   • Once the connection test is successful, save your configuration. You’ll be prompted to give the connection a schema name. Enter a descriptive name and save it.

7. Start Exploring:

   • Your MySQL database is now connected to Airbook. You can start exploring and analyzing your data.