Research
Security News
Malicious npm Packages Inject SSH Backdoors via Typosquatted Libraries
Socket’s threat research team has detected six malicious npm packages typosquatting popular libraries to insert SSH backdoors.
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.
Research
Security News
Socket’s threat research team has detected six malicious npm packages typosquatting popular libraries to insert SSH backdoors.
Security News
MITRE's 2024 CWE Top 25 highlights critical software vulnerabilities like XSS, SQL Injection, and CSRF, reflecting shifts due to a refined ranking methodology.
Security News
In this segment of the Risky Business podcast, Feross Aboukhadijeh and Patrick Gray discuss the challenges of tracking malware discovered in open source softare.