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:
- Python mailing list python-list
- Slack pythondev.slack.com
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for mysqlclient-2.1.1-pp39-pypy39_pp73-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dea88c8d3f5a5d9293dfe7f087c16dd350ceb175f2f6631c9cf4caf3e19b7a96 |
|
MD5 | 4babc8e0034f618c9fa29518b4589ac7 |
|
BLAKE2b-256 | cd258b7819e4bb502be4e1b4539783088007652d5977b6d6d036311fc26fc41a |
Hashes for mysqlclient-2.1.1-pp38-pypy38_pp73-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 996924f3483fd36a34a5812210c69e71dea5a3d5978d01199b78b7f6d485c855 |
|
MD5 | 02a423830234e84f5560b81bd1ca9e21 |
|
BLAKE2b-256 | 149836dbbd5397d60639d9128afefe35c6f45d8265a49650e421a9de4bae3189 |
Hashes for mysqlclient-2.1.1-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c812b67e90082a840efb82a8978369e6e69fc62ce1bda4ca8f3084a9d862308b |
|
MD5 | ad63491784c50b348357486d9ea1fc9c |
|
BLAKE2b-256 | 61a592b4df8cf63b192a0eaf93a17b81639bbdc6e0a50ac330aabc771ca0444f |
Hashes for mysqlclient-2.1.1-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c1ed71bd6244993b526113cca3df66428609f90e4652f37eb51c33496d478b37 |
|
MD5 | 0637775a011237f6644fbe331cab02c2 |
|
BLAKE2b-256 | 9c4bea487008d89731bcb80df55be2ed89c18dce927fd033ec4353d408d789ef |
Hashes for mysqlclient-2.1.1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b355c8b5a7d58f2e909acdbb050858390ee1b0e13672ae759e5e784110022994 |
|
MD5 | e339c576fb3aa6cd8367abef2e8279d1 |
|
BLAKE2b-256 | 5aebc814e0daa6284c6569fd8bb3ff76745dcd62ada456513cdbae21c1ce9c32 |
Hashes for mysqlclient-2.1.1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0d1cd3a5a4d28c222fa199002810e8146cffd821410b67851af4cc80aeccd97c |
|
MD5 | 3a02d2537e48ecde7f5886b2fb359e91 |
|
BLAKE2b-256 | c5e6d3dd1d7d47f8ae2e1ac8dde451822cd57da6145ae1597e6db36091f2dd68 |