Documentation
Data sources
Connect Databses
MySQL

MySQL

With Querier, you can integrate with MySQL and execute various queries.

Preparation

Connecting via IP Whitelisting

Add the following IP address to the whitelist in your database's firewall rules:

35.187.200.118

Connecting via SSH Tunneling

Please refer to this document to set up a bastion server.

Connection Method

1. Create a new data source connection

  1. Click the [Resources] tab.
  2. Click the [Create] button next to [Resources].
  3. Select [MySQL].

2. Enter the connection information

Common Items

FieldDescription
NameEnter the name of the MySQL connection (e.g., Querier DB).
Managed serviceSelect None or Cloud SQL.
Database nameEnter the database name of the MySQL you are connecting to.
Database usernameEnter the database username for the MySQL connection.
Database passwordEnter the password for the MySQL connection.

🙋‍♂️ About Managed Service

Currently, Querier supports connections via Cloud SQL Proxy. If you use Cloud SQL, select Cloud SQL under [Managed Service] to connect via Cloud SQL Proxy.
If not, please choose None.

If None is selected for Managed Service

FieldDescription
HostEnter the host of the MySQL connection.
PortEnter the port for the MySQL connection (e.g., 3306).

If Cloud SQL is selected for Managed Service

FieldDescription
Project IDEnter the Project ID for the GCP where Cloud SQL is set up.
Instance nameEnter the instance name of the Cloud SQL you are connecting to.
RegionEnter the region of the Cloud SQL (e.g., asia-northeast1).
Credentials JSONEnter the service account for the GCP where Cloud SQL is set up in JSON format.

🙋‍♂️ Required Permissions for the Service Account

The service account must have one of the following permissions:

  • Cloud SQL Client
  • Cloud SQL Editor
  • Cloud SQL Admin

When SSL connection is enabled

FieldDescription
CA CertificateUpload the CA certificate file.
Client KeyUpload the client key file.
Client CertificateUpload the client certificate file.
Verification modeSelect the verification method.

3. Set Up a Bastion Server

If you are connecting via a bastion server, follow these additional steps. If not, skip this section.

  1. Check [Set up a bastion server].
  2. Select the bastion server you set up during the preparation.