Integrate Google Cloud for MySQL with Databox

---

Availability

Users, Editors, and Admins

All accounts

Exclusive to select subscription plans

---

Google Cloud SQL is a fully managed relational database service from Google Cloud that handles provisioning, maintenance, and scaling of MySQL databases without requiring you to manage the underlying infrastructure. It supports MySQL 5.7 and 8.0 and is commonly used to power web applications, internal tools, and analytics pipelines hosted on Google Cloud. Connecting Google Cloud for MySQL to Databox lets you pull data directly from your managed database, build datasets using SQL queries, and visualize business-critical figures alongside data from your other connected tools.

If you've already established a connection, you can reuse it to add new data sources to your Databox account.

Databox only reads data from your database — it never writes to it. Create a dedicated MySQL user with SELECT-only privileges scoped to the Databox IP address. You can run these commands using the Cloud SQL Studio query editor in the Google Cloud Console, or via a MySQL client connected to your instance.

MySQL 8.0+ (modern syntax):

CREATE USER 'databox'@'52.4.198.118' IDENTIFIED BY 'your_secure_password';
GRANT SELECT ON your_database.* TO 'databox'@'52.4.198.118';
FLUSH PRIVILEGES;

MySQL 5.7 (legacy single-statement syntax):

GRANT SELECT ON your_database.* TO 'databox'@'52.4.198.118' IDENTIFIED BY 'your_secure_password';
FLUSH PRIVILEGES;

Replace your_database with the name of the database you want to connect, and your_secure_password with a strong password. If you need to grant access to multiple databases, repeat the GRANT statement for each one.

Note: Avoid the following special characters in your password, as they can cause encoding issues when establishing the connection: `, ', ", /, \, and spaces.

Databox connects to Cloud MySQL over a public IP address. If your instance does not already have one assigned, enable it in the Google Cloud Console.

1. In the Google Cloud Console, go to SQL and select your instance.
2. Click Edit.
3. Under Connections, expand Networking and ensure Public IP is enabled.
4. Click Save to apply the change.

Note: Your instance's public IP address is shown on the Overview tab of the Cloud SQL instance page, under Connect to this instance. Copy this value — you will need it in Step 4.

Cloud SQL controls inbound network access through an authorized networks list. Add the Databox IP address as an authorized network so it can reach your instance on port 3306.

1. In the Google Cloud Console, go to SQL and select your instance.
2. Click Edit.
3. Under Connections > Networking > Authorized networks, click Add a network.
4. In the Network field, enter 52.4.198.118/32.
5. Optionally enter a name (e.g., Databox) in the Name field.
6. Click Done, then click Save.

1. In Databox, go to Data Sources > + New connection.
2. Search for Google Cloud for MySQL and click Connect.
3. Fill in the connection form:
   • Data source name — a label for this connection in Databox.
   • Host — the public IP address of your Cloud SQL instance, found on the instance's Overview tab in the Google Cloud Console (e.g., 34.123.45.67).
   • Port — the port your Cloud SQL instance listens on. The default for MySQL is 3306.
   • User — the MySQL username created in Step 1.
   • Password — the password for that user.
   • Database name (optional) — the specific database to connect to. Leave blank to connect at the server level.
   • Timezone — the time zone used to interpret date values in query results. Defaults to Etc/UTC.
4. Select an SSL/TLS mode (see SSL/TLS below).
5. Click Connect.

Databox offers three SSL/TLS modes when connecting to a database. Choose the one that matches your server's configuration.

Google Cloud SQL provides SSL/TLS certificates signed by a Google-managed server CA. To use SSL with server certificate verification, download the server CA certificate from the Connections > Security tab of your Cloud SQL instance in the Google Cloud Console, and paste its contents into the CA certificate bundle (ssl-ca) field in Databox. Client certificates can also be created and downloaded from the same tab for mutual TLS. For step-by-step instructions on configuring each SSL mode, see Enable SSL/TLS for your database connection.

The Google Cloud SQL for MySQL integration supports the creation of datasets, which allow you to define and shape the specific data you want to use for reporting in Databox. Datasets make it easier to focus on the most relevant information, enabling you to filter, visualize, and analyze metrics across projects, teams, and clients without writing complex queries each time.

1. Select a table: Pick the appropriate schema within that database.
2. Select columns: Browse and select the specific columns (fields) from your tables or views to include in your dataset. These columns define the structure and content of your dataset.

For more advanced use cases, you can write a custom SQL query instead of selecting columns manually. This allows you to:

• Join multiple tables
• Apply filters and aggregations
• Format or transform data before importing it into Databox

Your query must return a valid tabular result to be used as a dataset.

• Cloud SQL for MySQL documentation — Official Google Cloud docs for Cloud SQL for MySQL, covering instance creation, connectivity, user management, security, backups, high availability, and replication.
• Cloud SQL connection options — Overview of all available connection methods for Cloud SQL, including public IP, private IP, and the Cloud SQL Auth Proxy, with guidance on when to use each.

For comprehensive details on metrics, data availability, templates, specifications, usage guidelines, and other key information, refer to the resources listed below.

Technical Details

Behavior & Usage

Notes

Ask Genie

Get instant answers or help with your data using the in-app AI assistant.

Talk to an expert

For customers: Get help with your setup, strategy, or making the most of Databox.

Book a demo

New to Databox? See how it works and get guidance on getting started.

Send an email

Reach out to support for help with your account, data, or technical issues.