PyMySQL

This package contains a pure-Python MySQL and MariaDB client library, based on PEP 249.

Requirements

Python -- one of the following:
- CPython : 3.9 and newer
- PyPy : Latest 3.x version
MySQL Server -- one of the following:
- MySQL LTS versions
- MariaDB LTS versions

Installation

Package is uploaded on PyPI.

You can install it with pip:

$ python3 -m pip install PyMySQL

To use "sha256_password" or "caching_sha2_password" for authenticate, you need to install additional dependency:

$ python3 -m pip install PyMySQL[rsa]

To use MariaDB's "ed25519" authentication method, you need to install additional dependency:

$ python3 -m pip install PyMySQL[ed25519]

Documentation

Documentation is available online: https://pymysql.readthedocs.io/

For support, please refer to the StackOverflow.

Example

The following examples make use of a simple table

CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8_bin NOT NULL,
    `password` varchar(255) COLLATE utf8_bin NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
AUTO_INCREMENT=1 ;

import pymysql.cursors

# Connect to the database
connection = pymysql.connect(
    host="localhost",
    user="user",
    password="passwd",
    database="db",
    cursorclass=pymysql.cursors.DictCursor,
)

with connection:
    with connection.cursor() as cursor:
        # Create a new record
        sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
        cursor.execute(sql, ("webmaster@python.org", "very-secret"))

    # connection is not autocommit by default. So you must commit to save
    # your changes.
    connection.commit()

    with connection.cursor() as cursor:
        # Read a single record
        sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
        cursor.execute(sql, ("webmaster@python.org",))
        result = cursor.fetchone()
        print(result)

This example will print:

{"password": "very-secret", "id": 1}

Resources

DB-API 2.0: https://www.python.org/dev/peps/pep-0249/
MySQL Reference Manuals: https://dev.mysql.com/doc/
Getting Help With MariaDB https://mariadb.com/kb/en/getting-help-with-mariadb/
MySQL client/server protocol: https://dev.mysql.com/doc/internals/en/client-server-protocol.html
"Connector" channel in MySQL Community Slack: https://lefred.be/mysql-community-on-slack/
PyMySQL mailing list: https://groups.google.com/forum/#!forum/pymysql-users

License

PyMySQL is released under the MIT License. See LICENSE for more information.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pymysql-1.2.3.tar.gz (50.6 kB view details)

Uploaded Sep 17, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

pymysql-1.2.3-py3-none-any.whl (46.7 kB view details)

Uploaded Sep 17, 2026 Python 3

File details

Details for the file pymysql-1.2.3.tar.gz.

File metadata

Download URL: pymysql-1.2.3.tar.gz
Upload date: Sep 17, 2026
Size: 50.6 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for pymysql-1.2.3.tar.gz
Algorithm	Hash digest
SHA256	`d5b288529782e536ae171866df3ca9dc4f6cbfb3cc2f18e6f837fbb90dbc262b`
MD5	`fc45000cf0191d5c6a22fe01e7a60302`
BLAKE2b-256	`b1d4c15b459e25a23767d2f4065ef40968920320f04e302889574310c21c96a3`

See more details on using hashes here.

Provenance

The following attestation bundles were made for pymysql-1.2.3.tar.gz:

Publisher: publish.yml on PyMySQL/PyMySQL

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: pymysql-1.2.3.tar.gz
- Subject digest: d5b288529782e536ae171866df3ca9dc4f6cbfb3cc2f18e6f837fbb90dbc262b
- Sigstore transparency entry: 2878092789
- Sigstore integration time: Sep 17, 2026
Source repository:
- Permalink: PyMySQL/PyMySQL@c990e86083c26493f3285b1e047902994c4b1811
- Branch / Tag: refs/tags/v1.2.3
- Owner: https://github.com/PyMySQL
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish.yml@c990e86083c26493f3285b1e047902994c4b1811
- Trigger Event: push