Overview - Python Connector for MySQL

Overview

Python Connector for MySQL is a connectivity solution for accessing MySQL databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to MySQL from a Python application via TCP/IP, eliminating the need for the database client library. A direct connection increases the speed of data transmission between the application and MySQL database server. It also streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Compatibility

• Python versions from 3.7 to 3.13
• MySQL versions:
• MySQL server: 8.0, 6.0, 5.7, 5.6, 5.5, 5.1, 5.0, 4.1, 4.0, 3.23
• MariaDB server: 5.x-10.x.
• Microsoft Azure Database for MySQL
• Amazon RDS for MySQL
• Amazon Aurora
• Google Cloud for MySQL
• SQLAlchemy
• pandas
• petl

Supported platforms

• Windows 32-bit and 64-bit
• Windows Server 32-bit and 64-bit
• macOS 64-bit and ARM (Apple M1 and M2)
• Linux 64-bit

Note: For details on supported OS versions, check the compatibility page of your Python version.