MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant driver. Documentation & Download: http://dev.mysql.com/doc/connector-python/en
… 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/>
. It also contains an implementation of the X DevAPI <https://dev.mysql.com/doc/x-devapi-userguide/en>
, an Application Programming Interface for working with the MySQL Document Store <https://dev.mysql.com/doc/refman/8.0/en/document-store.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/installing/#installing-with-get-pip-py>
_.
… code-block:: bash
shell> pip install mysql-connector-python
Please refer to the installation tutorial <https://dev.mysql.com/doc/dev/connector-python/8.0/installation.html>
_ for installation alternatives.
Using the MySQL classic protocol:
… 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()
Using the MySQL X DevAPI:
… code:: python
import mysqlx
# Connect to server
session = mysqlx.get_session(
host="127.0.0.1",
port=33060,
user="mike",
password="s3cr3t!")
schema = session.get_schema("test")
# Use the collection "my_collection"
collection = schema.get_collection("my_collection")
# Specify which document to find with Collection.find()
result = collection.find("name like :param") \
.bind("param", "S%") \
.limit(1) \
.execute()
# Print document
docs = result.fetch_all()
print(r"Name: {0}".format(docs[0]["name"]))
# Close session
session.close()
Please refer to the MySQL Connector/Python Developer Guide <https://dev.mysql.com/doc/connector-python/en/>
_ and the MySQL Connector/Python X DevAPI Reference <https://dev.mysql.com/doc/dev/connector-python/>
_ for a complete usage guide.
MySQL Connector/Python Developer Guide <https://dev.mysql.com/doc/connector-python/en/>
_MySQL Connector/Python X DevAPI Reference <https://dev.mysql.com/doc/dev/connector-python/>
_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>
_InsideMySQL.com Connectors Blog <https://insidemysql.com/category/mysql-development/connectors/>
_There are a few ways to contribute to the Connector/Python code. Please refer to the contributing guidelines <CONTRIBUTING.rst>
_ for additional information.
Please refer to the README.txt <README.txt>
_ and LICENSE.txt <LICENSE.txt>
_ files, available in this repository, for further details.