MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). It is written in pure Python and does not have any dependencies except for the Python Standard Library.
For notes detailing the changes in each release of Connector/Python, see MySQL Connector/Python Release Notes.
MySQL Connector/Python includes support for:
Almost all features provided by MySQL Server up to and including MySQL Server version 5.7.
Connector/Python 8.0 also supports X DevAPI. For documentation of the concepts and the usage of MySQL Connector/Python with X DevAPI, see X DevAPI User Guide.
Converting parameter values back and forth between Python and MySQL data types, for example Python
DATETIME. You can turn automatic conversion on for convenience, or off for optimal performance.
All MySQL extensions to standard SQL syntax.
Protocol compression, which enables compressing the data stream between the client and server.
Connections using TCP/IP sockets and on Unix using Unix sockets.
Secure TCP/IP connections using SSL.
Self-contained driver. Connector/Python does not require the MySQL client library or any Python modules outside the standard library.
For information about which versions of Python can be used with different versions of MySQL Connector/Python, see Chapter 3, Connector/Python Versions.
Connector/Python does not support the old MySQL Server authentication methods, which means that MySQL versions prior to 4.1 will not work.