MySQL Connector/Python Developer Guide/ Introduction to MySQL Connector/Python

Chapter 1 Introduction to MySQL Connector/Python

MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with thePython Database API Specification v2.0 (PEP 249).

For notes detailing the changes in each release of Connector/Python, seeMySQL Connector/Python Release Notes.

MySQL Connector/Python includes support for:

  • Almost all features provided by MySQL Server up to and including MySQL Server version 8.0.

    Connector/Python 8.0 also supports X DevAPI. For documentation of the concepts and the usage of MySQL Connector/Python with X DevAPI, seeX DevAPI User Guide.

  • Converting parameter values back and forth between Python and MySQL data types, for example Pythondatetimeand MySQLDATETIME. 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, seeChapter 3,Connector/Python Versions.

Note

Connector/Python does not support the old MySQL Server authentication methods, which means that MySQL versions prior to 4.1 will not work.