Connect to MySQL

The MySQL connector allows you to access data from MySQL databases within Data Studio.

In this article:

• How to connect to MySQL
• Special data types
• Unsupported database types
• Notes
• Limits
• Related resources

How to connect to MySQL

A Data Studio data source can connect to a single MySQL database table.

The Data Studio MySQL connector is based on Google Cloud SQL for MySQL, and is subject to the same limits on versions and supported features. Learn more about Google Cloud SQL for MySQL.

Supported versions

We've tested Data Studio on the following MySQL versions:

• 5.6
• 5.7
• 8.0

If you experience issues using a supported version, please let us know in the Data Studio Help Community. You can add and vote on feature requests here.

To connect

1. Sign in to Data Studio.
2. In the top left, click , then select Data Source.
3. Select the MySQL connector
4. Configure access to your database using one of the connection options (see below)
5. Click AUTHENTICATE
   1. You will see a list of tables in that database
6. Select a table
7. Click CONNECT.

You can now access all of the columns in the table as fields in your reports.

Connection options

BASIC

Connecting with a hostname or IP address requires the following information:

• Hostname or IP address
  Data Studio can't connect to localhost. You must use a public hostname or IP address.
• Port (Optional)
• Database
• Username
• Password

JDBC URL

To connect via a JDBC URL, provide the following connection information:

• JDBC URL
  Example
  
  jdbc:mysql://<hostname or IP address>[:<port>]/<database>
• Username
• Password

If you use the JDBC hostname option, you can make sure it's accessible with public DNS lookup tools such as Whois.

Use secure connection (optional)

Data Studio supports secure (encrypted) connections to the server using the TLS (Transport Layer Security) protocol. TLS is also referred to as SSL (Secure Sockets Layer). To enable a secure connection, check Enable SSL, then provide your SSL client configuration files.

Learn more about MySQL secure connections.

Select a table

When you click authorize, Data Studio will try to access your database and list all of the tables. Finally you need to select one table and click connect.

Data Studio will then turn all of the columns in the table into fields.

Custom Query

Select the CUSTOM QUERY option to provide a SQL query instead of connecting to a single table. Data Studio uses this custom SQL as an inner select statement for each generated query to the database.

Special data types

Data Studio will map your table’s column data types to a unified set of Data Studio types. Some database types are currently not supported in Data Studio. When Data Studio encounters a column of a non-supported type, it will not create a field for that column.

Unsupported database types

Data Studio does not support MySQL's Spatial Data Extensions.

Notes

If your database is behind a firewall, you will need to open access to all of the following IP addresses. These are used by Data Studio to connect to and query your MySql database.

64.18.0.0/20

64.233.160.0/19

66.102.0.0/20

66.249.80.0/20

72.14.192.0/18

74.125.0.0/16

108.177.8.0/21

142.251.74.0/23

173.194.0.0/16

207.126.144.0/20

209.85.128.0/17

216.58.192.0/19

216.239.32.0/19

2001:4860:4807::/48

Limits of the MySQL connector

• You can query a maximum of 100K rows using this connector.
• Column headers (field names) must use ASCII characters only. Non-ASCII characters aren't supported.

Related resources

Create a data source