Last updated: Nov 27, 2024
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 (optional): If you do not enter a database name, you must enter the catalog name, schema name, and the table name in the properties for SQL queries.
- Hostname or IP address
- Port number
- Username and password
- SSL certificate (if required by the database server)
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
- In a deployment space
- Click Import assets > Data access > Connection. See Adding data assets 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
- Notebooks. 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.
- Decision Optimization
- SPSS Modeler
- Synthetic Data Generator
Catalogs
- Platform assets catalog
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