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 8.0 and 8.4.
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)
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 > Prepare data > Connect to a data source. 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 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
Federal Information Processing Standards (FIPS) compliance
This connection can be used on a FIPS-enabled cluster (FIPS tolerant); however, it is not FIPS-compliant.
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