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
$ 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
$ echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile
$ export PATH="/usr/local/opt/mysql-client/bin:$PATH"
$ 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 # Debian / Ubuntu
  • % sudo yum install python3-devel mysql-devel # Red Hat / CentOS

Then you can install mysqlclient via pip now:

$ pip install mysqlclient

Customize build (POSIX)

mysqlclient uses mysql_config or mariadb_config 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.1.1.tar.gz (88.1 kB view details)

Uploaded Source

Built Distributions

mysqlclient-2.1.1-pp39-pypy39_pp73-win_amd64.whl (178.6 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.1.1-pp38-pypy38_pp73-win_amd64.whl (178.8 kB view details)

Uploaded PyPy Windows x86-64

mysqlclient-2.1.1-cp311-cp311-win_amd64.whl (178.4 kB view details)

Uploaded CPython 3.11 Windows x86-64

mysqlclient-2.1.1-cp310-cp310-win_amd64.whl (178.4 kB view details)

Uploaded CPython 3.10 Windows x86-64

mysqlclient-2.1.1-cp39-cp39-win_amd64.whl (178.5 kB view details)

Uploaded CPython 3.9 Windows x86-64

mysqlclient-2.1.1-cp38-cp38-win_amd64.whl (178.6 kB view details)

Uploaded CPython 3.8 Windows x86-64

File details

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

File metadata

  • Download URL: mysqlclient-2.1.1.tar.gz
  • Upload date:
  • Size: 88.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.0 CPython/3.9.13

File hashes

Hashes for mysqlclient-2.1.1.tar.gz
Algorithm Hash digest
SHA256 828757e419fb11dd6c5ed2576ec92c3efaa93a0f7c39e263586d1ee779c3d782
MD5 535cf38b47d0c684bc1c12fc4611c3d2
BLAKE2b-256 505feac919b88b9df39bbe4a855f136d58f80d191cfea34a3dcf96bf5d8ace0a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-pp39-pypy39_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 dea88c8d3f5a5d9293dfe7f087c16dd350ceb175f2f6631c9cf4caf3e19b7a96
MD5 4babc8e0034f618c9fa29518b4589ac7
BLAKE2b-256 cd258b7819e4bb502be4e1b4539783088007652d5977b6d6d036311fc26fc41a

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-pp38-pypy38_pp73-win_amd64.whl
Algorithm Hash digest
SHA256 996924f3483fd36a34a5812210c69e71dea5a3d5978d01199b78b7f6d485c855
MD5 02a423830234e84f5560b81bd1ca9e21
BLAKE2b-256 149836dbbd5397d60639d9128afefe35c6f45d8265a49650e421a9de4bae3189

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 c812b67e90082a840efb82a8978369e6e69fc62ce1bda4ca8f3084a9d862308b
MD5 ad63491784c50b348357486d9ea1fc9c
BLAKE2b-256 61a592b4df8cf63b192a0eaf93a17b81639bbdc6e0a50ac330aabc771ca0444f

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 c1ed71bd6244993b526113cca3df66428609f90e4652f37eb51c33496d478b37
MD5 0637775a011237f6644fbe331cab02c2
BLAKE2b-256 9c4bea487008d89731bcb80df55be2ed89c18dce927fd033ec4353d408d789ef

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 b355c8b5a7d58f2e909acdbb050858390ee1b0e13672ae759e5e784110022994
MD5 e339c576fb3aa6cd8367abef2e8279d1
BLAKE2b-256 5aebc814e0daa6284c6569fd8bb3ff76745dcd62ada456513cdbae21c1ce9c32

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for mysqlclient-2.1.1-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 0d1cd3a5a4d28c222fa199002810e8146cffd821410b67851af4cc80aeccd97c
MD5 3a02d2537e48ecde7f5886b2fb359e91
BLAKE2b-256 c5e6d3dd1d7d47f8ae2e1ac8dde451822cd57da6145ae1597e6db36091f2dd68

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