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.4.tar.gz (90.4 kB view details)

Uploaded Source

Built Distributions

mysqlclient-2.2.4-pp310-pypy310_pp73-win_amd64.whl (203.2 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.4-pp39-pypy39_pp73-win_amd64.whl (203.4 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.4-pp38-pypy38_pp73-win_amd64.whl (203.5 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.2.4-cp312-cp312-win_amd64.whl (203.3 kB view details)

Uploaded CPython 3.12 Windows x86-64

mysqlclient-2.2.4-cp311-cp311-win_amd64.whl (203.2 kB view details)

Uploaded CPython 3.11 Windows x86-64

mysqlclient-2.2.4-cp310-cp310-win_amd64.whl (203.2 kB view details)

Uploaded CPython 3.10 Windows x86-64

mysqlclient-2.2.4-cp39-cp39-win_amd64.whl (203.3 kB view details)

Uploaded CPython 3.9 Windows x86-64

mysqlclient-2.2.4-cp38-cp38-win_amd64.whl (203.3 kB view details)

Uploaded CPython 3.8 Windows x86-64

File details

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

File metadata

  • Download URL: mysqlclient-2.2.4.tar.gz
  • Upload date:
  • Size: 90.4 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.4.tar.gz
Algorithm Hash digest
SHA256 33bc9fb3464e7d7c10b1eaf7336c5ff8f2a3d3b88bab432116ad2490beb3bf41
MD5 962de1bfcd1872e7d969bfe608b0a4b0
BLAKE2b-256 7933996dc0ba3f03e2399adc91a7de1f61cb14b57ebdb4cc6eca8a78723043cb

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-pp310-pypy310_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 d43987bb9626096a302ca6ddcdd81feaeca65ced1d5fe892a6a66b808326aa54
MD5 d4f4e5e9620ec75674a0601885c9d838
BLAKE2b-256 69fd12cf8420a7e62098a5312b6f690a6ab377025fa4ba01ed861ed97587a756

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-pp39-pypy39_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 9d3310295cb682232cadc28abd172f406c718b9ada41d2371259098ae37779d3
MD5 ec5286d6dfa27f43853a14940aa4788e
BLAKE2b-256 b18c3ca7dd7f6a014367876b51d9bd964c4019fe5fb16fda1df43ef9854467c0

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-pp38-pypy38_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 4e80dcad884dd6e14949ac6daf769123223a52a6805345608bf49cdaf7bc8b3a
MD5 4ec294374736b98d408c12ad8f6db758
BLAKE2b-256 87a89bf2a95be6d423f9adadc47deb5a96a8bd2f7bab5dea4864815bcc454681

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 e1ebe3f41d152d7cb7c265349fdb7f1eca86ccb0ca24a90036cde48e00ceb2ab
MD5 0842e9b8bba74cb3b0014ed7f7c1662e
BLAKE2b-256 d3561fe1a8aa7ba090576632c16bd43fb0df78747d2f18c54e769015378667fb

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 329e4eec086a2336fe3541f1ce095d87a6f169d1cc8ba7b04ac68bcb234c9711
MD5 e899c6cd0dd54696e4dc4b7215a20072
BLAKE2b-256 640c338ff73f627db62f2c321bcda61eddb80a384933aa543e3f59821b3c9756

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 ac44777eab0a66c14cb0d38965572f762e193ec2e5c0723bcd11319cc5b693c5
MD5 69d225673ddf55b0a625cbafefe0b7ab
BLAKE2b-256 cd55581ee5ceb37de7a75e5bdf53d8791b915916d9b558f947597a7668ae969c

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 9d4c015480c4a6b2b1602eccd9846103fc70606244788d04aa14b31c4bd1f0e2
MD5 e45b827cad689b4d276904e4f2468862
BLAKE2b-256 f8930aaebf801d4cf56df2150b64d9af04f1812d478e57ec4d4b2a5462d6d894

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.2.4-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 3c318755e06df599338dad7625f884b8a71fcf322a9939ef78c9b3db93e1de7a
MD5 3952609f2b84229170afe29fa475b4de
BLAKE2b-256 6fa44ae7b8be02fe112d10b190e7becd61d315e950a9d5d399fb032988445e01

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