The MySQL connector allows you to access data from MySQL databases within Data Studio.In this article:
How to connect to MySQL
A Data Studio data source can connect to a single MySQL database table. First, select the mySQL connector. Next, configure access to your database by supplying the following:
- Hostname or IP address
- Port (Optional)
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 MySQL 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.
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
If your database is behind a firewall, you will need to open access to the all of the following IP addresses. These are used by Data Studio to connect to and query your MySql database.