Amazon RDS for MySQL connection
To access your data in Amazon RDS for MySQL, create a connection asset for it.
Amazon RDS for MySQL is a MySQL relational database that runs on the Amazon Relational Database Service (RDS).
Supported versions
MySQL database versions 5.6 through 8.0
Create a connection to Amazon RDS for MySQL
To create the connection asset, you need these connection details:
- Database name
- Hostname or IP address
- Port number
- 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 Amazon RDS for MySQL connections in the following workspaces and tools:
Projects
- Data Refinery (Watson Studio or 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. Use the insert-to-code function 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.
Amazon RDS for MySQL setup
For setup instructions, see these topics:
Running SQL statements
To ensure that your SQL statements run correctly, refer to the Amazon RDS for MySQL documentation for the correct syntax.
Learn more
Parent topic: Supported connections