MySQL connection
To access your data in MySQL, create a connection asset for it.
MySQL is an open-source relational database management system.
Supported versions
- MySQL Enterprise Edition 5.0+
- MySQL Community Edition 4.1, 5.0, 5.1, 5.5, 5.6, 5.7
Create a connection to MySQL
To create the connection asset, you need these connection details:
- Database name
- Hostname or IP Address
- Port number
- Character Encoding
- Username and password
- SSL certificate (if required by the database server)
For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Data access tools > Connection. See Adding a connection to a project.
- In a catalog
- Click Add to catalog > Connection. See Adding a connection asset to a catalog.
- In a deployment space
- Click Add to space > Connection. See Adding connections to a deployment space.
- In the Platform assets catalog
- Click New connection. See Adding platform connections.
Next step: Add data assets from the connection
Where you can use this connection
You can use MySQL connections in the following workspaces and tools:
Projects
- AutoAI (Watson Machine Learning)
- Cognos Dashboards (Cognos Dashboards service)
- Data quality rules (Watson Knowledge Catalog)
- DataStage (DataStage service). See Connecting to a data source in DataStage.
- Metadata enrichment (Watson Knowledge Catalog)
- Metadata import (Watson Knowledge Catalog)
- Notebooks (Watson Studio). Click Read data on the Code snippets pane to get the connection credentials and load the data into a data structure. See Load data from data source connections.
- SPSS Modeler (SPSS Modeler service)
Catalogs
-
Platform assets catalog
-
Other catalogs (Watson Knowledge Catalog)
- Watson Query service
- You can connect to this data source from Watson Query.
Federal Information Processing Standards (FIPS) compliance
The MySQL connection is compliant with FIPS except for a connection that requires SSL.
Running SQL statements
To ensure that your SQL statements run correctly, refer to the MySQL documentation for the correct syntax.
MySQL setup
Learn more
Parent topic: Supported connections