Skip to main content

Python interface to MySQL

Project description

mysqlclient

This project is a fork of MySQLdb1. This project adds Python 3 support and fixed many bugs.

Support

Do Not use Github Issue Tracker to ask help. OSS Maintainer is not free tech support

When your question looks relating to Python rather than MySQL:

Or when you have question about MySQL:

Install

Windows

Building mysqlclient on Windows is very hard. But there are some binary wheels you can install easily.

If binary wheels do not exist for your version of Python, it may be possible to build from source, but if this does not work, do not come asking for support. To build from source, download the MariaDB C Connector and install it. It must be installed in the default location (usually "C:\Program Files\MariaDB\MariaDB Connector C" or "C:\Program Files (x86)\MariaDB\MariaDB Connector C" for 32-bit). If you build the connector yourself or install it in a different location, set the environment variable MYSQLCLIENT_CONNECTOR before installing. Once you have the connector installed and an appropriate version of Visual Studio for your version of Python:

$ pip install mysqlclient

macOS (Homebrew)

Install MySQL and mysqlclient:

$ # Assume you are activating Python 3 venv
$ brew install mysql pkg-config
$ pip install mysqlclient

If you don't want to install MySQL server, you can use mysql-client instead:

$ # Assume you are activating Python 3 venv
$ brew install mysql-client pkg-config
$ export PKG_CONFIG_PATH="$(brew --prefix)/opt/mysql-client/lib/pkgconfig"
$ pip install mysqlclient

Linux

Note that this is a basic step. I can not support complete step for build for all environment. If you can see some error, you should fix it by yourself, or ask for support in some user forum. Don't file a issue on the issue tracker.

You may need to install the Python 3 and MySQL development headers and libraries like so:

  • $ sudo apt-get install python3-dev default-libmysqlclient-dev build-essential pkg-config # Debian / Ubuntu
  • % sudo yum install python3-devel mysql-devel pkgconfig # Red Hat / CentOS

Then you can install mysqlclient via pip now:

$ pip install mysqlclient

Customize build (POSIX)

mysqlclient uses pkg-config --cflags --ldflags mysqlclient by default for finding compiler/linker flags.

You can use MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS environment variables to customize compiler/linker options.

$ export MYSQLCLIENT_CFLAGS=`pkg-config mysqlclient --cflags`
$ export MYSQLCLIENT_LDFLAGS=`pkg-config mysqlclient --libs`
$ pip install mysqlclient

Documentation

Documentation is hosted on Read The Docs

Project details


Download files

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

Source Distribution

mysqlclient-2.2.1.tar.gz (90.0 kB view details)

Uploaded Source

Built Distributions

mysqlclient-2.2.1-pp310-pypy310_pp73-win_amd64.whl (202.8 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.1-pp39-pypy39_pp73-win_amd64.whl (202.9 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.1-pp38-pypy38_pp73-win_amd64.whl (203.0 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.1-cp312-cp312-win_amd64.whl (202.8 kB view details)

Uploaded CPython 3.12 Windows x86-64

mysqlclient-2.2.1-cp311-cp311-win_amd64.whl (202.8 kB view details)

Uploaded CPython 3.11 Windows x86-64

mysqlclient-2.2.1-cp310-cp310-win_amd64.whl (202.8 kB view details)

Uploaded CPython 3.10 Windows x86-64

mysqlclient-2.2.1-cp39-cp39-win_amd64.whl (202.8 kB view details)

Uploaded CPython 3.9 Windows x86-64

mysqlclient-2.2.1-cp38-cp38-win_amd64.whl (202.8 kB view details)

Uploaded CPython 3.8 Windows x86-64

File details

Details for the file mysqlclient-2.2.1.tar.gz.

File metadata

  • Download URL: mysqlclient-2.2.1.tar.gz
  • Upload date:
  • Size: 90.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.12.0

File hashes

Hashes for mysqlclient-2.2.1.tar.gz
Algorithm Hash digest
SHA256 2c7ad15b87293b12fd44b47c46879ec95ec647f4567e866ccd70b8337584e9b2
MD5 38943a80e1421ef35162ac81164c98f5
BLAKE2b-256 37fbd9a8f763c84f1e789c027af0ffc7dbf94c9a38db961484f253f0552cbb47

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-pp310-pypy310_pp73-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-pp310-pypy310_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 97eee76818774bb695e018ff4c3dafaab74b9a0b0cf32c90b02caeec3b19cd8e
MD5 77602ad37b040c565cbb1e4e5aadee0b
BLAKE2b-256 38b65c8da078534566e697278ad5c871493268b22165a7192767922301948cf0

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-pp39-pypy39_pp73-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-pp39-pypy39_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 641a7c9de443ddef186a0e89f24b4251ad44f4ddc5e7094332bf2d286d7c9e33
MD5 c23b8a3eb8ffa078b3a9293a14a09561
BLAKE2b-256 aa1772681dd8cb7f30bb93867adf0f5139d07dcb8d2b418d876bf9eaa5babb03

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-pp38-pypy38_pp73-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-pp38-pypy38_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 4fabe1f4b545ed6244ad0ff426e6b27054b7e5c5b1392be0de2e5f2f59be0392
MD5 c2de2aa378feeb33719b2d3ba3a6b985
BLAKE2b-256 e759e9e589b92106fe01d5b29e0c73b46f00ebab3e2e8b8c63b3c5ab74c904f8

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 45600f4f321096bd1ead3355bc62cfcf8d97dc78df94e4ab5db72ecb5db1bd04
MD5 d793c67ea309cd731ceac41bf9eac3b7
BLAKE2b-256 f789998d7dd34a3159a69da35593e147bc4082e8774a82c806debbef52393689

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 8f40c872f19639366e3df27bef2ff087be0e3ee0bd3453470bd29f46b54a90f6
MD5 8267ec01db2b3509703bf5ea02848b0a
BLAKE2b-256 925da26d4d3a19d12df4a742e93364ae3ff6a5b75678add3c0ef769d32023a5e

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 c5a293baebbfcfa2905545198a54e90f1cf00f211eae6637d24930abb6432cba
MD5 6aebcf3b2bf6f7fc89c501c3e5cf54ed
BLAKE2b-256 530ad460306c405d07abb45771becee27e8a0ec8e2a5b8dc80f1b38bc3a708e6

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 9db6305cdf2a1da350f827d2a19be7f2666eafd9eb8d4f7cbbac5df847d61b99
MD5 e9b753d19e1819ee4150ef511851238c
BLAKE2b-256 e068b9ab8d1287f91252aa4f7908bcf833e1852869cf558fcece2dc5f1533dde

See more details on using hashes here.

File details

Details for the file mysqlclient-2.2.1-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for mysqlclient-2.2.1-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 1f8889cc5f0141bb307b915e981a66793df663ace92259344661084a7dd8d12a
MD5 ce25ce13b02f3360a15b8c43751c3851
BLAKE2b-256 408c310e592d2f288cf3518f693b108d268b074482ff9c6e922d1e738e3a359f

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page