Connecting to RDS for MySQL with the Amazon JDBC Driver, Amazon Python Driver, and Amazon ODBC Driver for MySQL
Connect to RDS for MySQL DB instances with the Amazon JDBC Driver, the Amazon Python Driver, and the Amazon ODBC Driver for MySQL. For more information, see the following topics.
Topics
Connecting to RDS for MySQL with the Amazon Web Services (Amazon) JDBC Driver
The Amazon Web Services (Amazon) JDBC Driver is designed as an advanced JDBC wrapper. This wrapper is complementary to and extends the functionality of an existing JDBC driver. The driver is drop-in compatible with the community MySQL Connector/J driver and the community MariaDB Connector/J driver.
To install the Amazon JDBC Driver, append the Amazon JDBC Driver .jar file (located in the
application CLASSPATH
), and keep references to the respective community
driver. Update the respective connection URL prefix as follows:
-
jdbc:mysql://
tojdbc:aws-wrapper:mysql://
-
jdbc:mariadb://
tojdbc:aws-wrapper:mariadb://
For more information about the Amazon JDBC Driver and complete instructions for using it,
see the Amazon Web Services (Amazon) JDBC Driver GitHub repository
Connecting to RDS for MySQL with the Amazon Web Services (Amazon) Python Driver
The Amazon Web Services (Amazon) Python Driver is designed as an advanced Python wrapper. This wrapper is
complementary to and extends the functionality of the open-source Psycopg driver. The
Amazon Python Driver supports Python versions 3.8 and higher. You can install the
aws-advanced-python-wrapper
package using the pip
command,
along with the psycopg
open-source packages.
For more information about the Amazon Python Driver and complete instructions for using it,
see the Amazon Web Services (Amazon) Python Driver GitHub repository
Connecting to RDS for MySQL with the Amazon Web Services (Amazon) ODBC Driver for MySQL
The Amazon ODBC Driver for MySQL is a client driver designed for the high availability of RDS for MySQL. The driver can exist alongside the MySQL Connector/ODBC driver and is compatible with the same workflows.
For more information about the Amazon ODBC Driver for MySQL and complete instructions for
installing and using it, see the Amazon Web Services (Amazon) ODBC Driver for MySQL