Security News
GitHub Removes Malicious Pull Requests Targeting Open Source Repositories
GitHub removed 27 malicious pull requests attempting to inject harmful code across multiple open source repositories, in another round of low-effort attacks.
mysql-connector-python
Advanced tools
A self-contained Python driver for communicating with MySQL servers, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249).
.. image:: https://img.shields.io/pypi/v/mysql-connector-python.svg :target: https://pypi.org/project/mysql-connector-python/ .. image:: https://img.shields.io/pypi/pyversions/mysql-connector-python.svg :target: https://pypi.org/project/mysql-connector-python/ .. image:: https://img.shields.io/pypi/l/mysql-connector-python.svg :target: https://pypi.org/project/mysql-connector-python/
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) <https://www.python.org/dev/peps/pep-0249/>
_ - We refer to it as the
Classic API <https://dev.mysql.com/doc/connector-python/en/connector-python-reference.html>
_.
Asynchronous Connectivity <https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html>
_C-extension <https://dev.mysql.com/doc/connector-python/en/connector-python-cext.html>
_Telemetry <https://dev.mysql.com/doc/connector-python/en/connector-python-opentelemetry.html>
_The recommended way to install Connector/Python is via pip <https://pip.pypa.io/>
_.
Make sure you have a recent pip <https://pip.pypa.io/>
_ version installed
on your system. If your system already has pip
installed, you might need
to update it. Or you can use the standalone pip installer <https://pip.pypa.io/en/latest/installation/>
_.
.. code-block:: bash
$ pip install mysql-connector-python
++++++++++++++++++++ Installation Options ++++++++++++++++++++
Connector packages included in MySQL Connector/Python allow you to install optional dependencies to unleash certain functionalities.
.. code-block:: bash
# 3rd party packages to unleash the telemetry functionality are installed
$ pip install mysql-connector-python[telemetry]
This installation option can be seen as a shortcut to install all the dependencies needed by a particular feature. Mind that this is optional and you are free to install the required dependencies by yourself.
Available options:
.. code:: python
import mysql.connector
# Connect to server
cnx = mysql.connector.connect(
host="127.0.0.1",
port=3306,
user="mike",
password="s3cre3t!")
# Get a cursor
cur = cnx.cursor()
# Execute a query
cur.execute("SELECT CURDATE()")
# Fetch one result
row = cur.fetchone()
print("Current date is: {0}".format(row[0]))
# Close connection
cnx.close()
MySQL Connector/Python Developer Guide <https://dev.mysql.com/doc/connector-python/en/>
_
MySQL Connector/Python Forum <http://forums.mysql.com/list.php?50>
_
MySQL Public Bug Tracker <https://bugs.mysql.com>
_
Slack <https://mysqlcommunity.slack.com>
_ (Sign-up <https://lefred.be/mysql-community-on-slack/>
_ required if you do not have an Oracle account)
Stack Overflow <https://stackoverflow.com/questions/tagged/mysql-connector-python>
_
Oracle Blogs <https://blogs.oracle.com/search.html?q=connector-python>
_
There are a few ways to contribute to the Connector/Python code. Please refer
to the contributing guidelines <CONTRIBUTING.md>
_ for additional information.
Please refer to the README.txt <README.txt>
_ and LICENSE.txt <LICENSE.txt>
_
files, available in this repository, for further details.
FAQs
A self-contained Python driver for communicating with MySQL servers, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249).
We found that mysql-connector-python demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 4 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
GitHub removed 27 malicious pull requests attempting to inject harmful code across multiple open source repositories, in another round of low-effort attacks.
Security News
RubyGems.org has added a new "maintainer" role that allows for publishing new versions of gems. This new permission type is aimed at improving security for gem owners and the service overall.
Security News
Node.js will be enforcing stricter semver-major PR policies a month before major releases to enhance stability and ensure reliable release candidates.