MySQL Connector/Python

Those who rely heavily on Python for their various programming undertakings could, at some point, require to access other database environments, such as MySQL.
MySQL Connector/Python was developed in order to provide connectivity between Python-based programs and MySQL databases.
To achieve such connectivity, it will deploy an API that is compliant with the Python Database API Specification v2.0 (PEP 249). The utility is written in pure Python and its single dependencies include the Python Standard Library.
Available in both 32 and 64-bit installations, this application is currently compatible with versions of Python from 2.7 to 3.5, this way offering users a broad range of options when choosing the required installer.
Using MySQL Connector/Python, one will be able to convert parameter values back and forth between Python and MySQL data types and this can be done either manually or automatically, in order to achieve increased performance.
Some of the other significant capabilities that are worth mentioning are the fact that the application does support protocol compression, which offers data stream compression between the client and server and secure TCP/IP connections, using SSL certification.
Furthermore, the application has a self-contained driver and it will not require any other Python modules apart from those provided in the standard library, which means that people will not need the MySQL client library.
One important aspect that users must take into account is the fact that MySQL Connector/Python does not support the old, traditional MySQL Server authentication methods and this translates into the fact that MySQL 4.1 or earlier will not function.System requirementsMySQL
Python