Python interface to MySQL

These details have not been verified by PyPI

Project links

Homepage

Project description

mysqlclient

This is a fork of MySQLdb1.

This project adds Python 3 support and bug fixes. I hope this fork is merged back to MySQLdb1 like distribute was merged back to setuptools.

Install

Prerequisites

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

sudo apt-get install python-dev default-libmysqlclient-dev # Debian / Ubuntu
sudo yum install python-devel mysql-devel # Red Hat / CentOS
brew install mysql-connector-c # macOS (Homebrew) (Currently, it has bug. See below)

On Windows, there are binary wheels you can install without MySQLConnector/C or MSVC.

Note on Python 3 : if you are using python3 then you need to install python3-dev using the following command :

sudo apt-get install python3-dev # debian / Ubuntu

sudo yum install python3-devel # Red Hat / CentOS

Note about bug of MySQL Connector/C on macOS

Versions of MySQL Connector/C may have incorrect default configuration options that cause compilation errors when mysqlclient-python is installed. (As of November 2017, this is known to be true for homebrew's mysql-connector-c and official package)

Modification of mysql_config resolves these issues as follows.

Change

# on macOS, on or about line 112:
# Create options
libs="-L$pkglibdir"
libs="$libs -l "

# Create options
libs="-L$pkglibdir"
libs="$libs -lmysqlclient -lssl -lcrypto"

An improper ssl configuration may also create issues; see, e.g, brew info openssl for details on macOS.

Install from PyPI

pip install mysqlclient

NOTE: Wheels for Windows may be not released with source package. You should pin version in your requirements.txt to avoid trying to install newest source package.

Install from source

Download source by git clone or zipfile.
Customize site.cfg
python setup.py install

Documentation

Documentation is hosted on Read The Docs

Project details

These details have not been verified by PyPI

Project links

Homepage

Release history Release notifications | RSS feed

2.2.6

Nov 13, 2024

2.2.5

Oct 20, 2024

2.2.4

Feb 8, 2024

2.2.3

Feb 4, 2024

2.2.2

Feb 4, 2024

2.2.1

Dec 13, 2023

2.2.0

Jun 22, 2023

2.2.0rc1 pre-release

May 19, 2023

2.1.1

Jun 22, 2022

2.1.0

Nov 18, 2021

2.1.0rc1 pre-release

Oct 19, 2021

2.0.3

Jan 1, 2021

2.0.2

Dec 10, 2020

2.0.1

Jul 3, 2020

2.0.0

Jul 2, 2020

1.4.6

Nov 21, 2019

1.4.5

Nov 6, 2019

1.4.4

Aug 11, 2019

1.4.3

Aug 9, 2019

1.4.2.post1

Feb 12, 2019

1.4.2

Feb 8, 2019

1.4.1

Jan 19, 2019

This version

1.4.0

Jan 18, 2019

1.4.0rc3 pre-release

Dec 17, 2018

1.4.0rc2 pre-release

Dec 15, 2018

1.4.0rc1 pre-release

Dec 11, 2018

1.3.14

Dec 4, 2018

1.3.13

Jun 27, 2018

1.3.12

Sep 1, 2017

1.3.11

Sep 1, 2017

1.3.11rc1 pre-release

Aug 30, 2017

1.3.10

Feb 20, 2017

1.3.9

Sep 30, 2016

1.3.8

Sep 29, 2016

1.3.7

Nov 4, 2015

1.3.6

Feb 25, 2015

1.3.5

Feb 6, 2015

1.3.4

Nov 2, 2014

1.3.3

Sep 9, 2014

1.3.2

Jul 3, 2014

1.3.1

Apr 28, 2014

1.3.0

Apr 28, 2014

Download files

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

Source Distribution

mysqlclient-1.4.0.tar.gz (85.1 kB view details)

Uploaded Jan 18, 2019 Source

Built Distributions

mysqlclient-1.4.0-cp37-cp37m-win_amd64.whl (178.2 kB view details)

Uploaded Jan 18, 2019 CPython 3.7m Windows x86-64

mysqlclient-1.4.0-cp36-cp36m-win_amd64.whl (178.2 kB view details)

Uploaded Jan 18, 2019 CPython 3.6m Windows x86-64

File details

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

File metadata

Download URL: mysqlclient-1.4.0.tar.gz
Upload date: Jan 18, 2019
Size: 85.1 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/1.12.1 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.29.1 CPython/3.7.2

File hashes

Hashes for mysqlclient-1.4.0.tar.gz
Algorithm	Hash digest
SHA256	`efeaacd04feea7d44fef2a5adf4df335b438458f8b89144307dc5a90025761a5`
MD5	`a1e187a93c7eb536322afe36982fa73c`
BLAKE2b-256	`0573fac741eef89b0257fb1807de80e96474f40d52739cdbc32c90c4a793e79d`

See more details on using hashes here.

File details

Details for the file mysqlclient-1.4.0-cp37-cp37m-win_amd64.whl.

File metadata

Download URL: mysqlclient-1.4.0-cp37-cp37m-win_amd64.whl
Upload date: Jan 18, 2019
Size: 178.2 kB
Tags: CPython 3.7m, Windows x86-64
Uploaded using Trusted Publishing? No
Uploaded via: twine/1.12.1 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.29.1 CPython/3.7.2

File hashes

Hashes for mysqlclient-1.4.0-cp37-cp37m-win_amd64.whl
Algorithm	Hash digest
SHA256	`1a8da3c4d5271dfb8505c8916992f3b7c644d836f7a9892f8b06fadda3f6786e`
MD5	`ad19f985065894cbc860733477e4f0c9`
BLAKE2b-256	`5bcd9c3b6df8a266b365c6dd9274f255553f9a3dd6f34de7ad6d0c3d722e2ea0`

See more details on using hashes here.

File details

Details for the file mysqlclient-1.4.0-cp36-cp36m-win_amd64.whl.

File metadata

Download URL: mysqlclient-1.4.0-cp36-cp36m-win_amd64.whl
Upload date: Jan 18, 2019
Size: 178.2 kB
Tags: CPython 3.6m, Windows x86-64
Uploaded using Trusted Publishing? No
Uploaded via: twine/1.12.1 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.29.1 CPython/3.7.2

File hashes

Hashes for mysqlclient-1.4.0-cp36-cp36m-win_amd64.whl
Algorithm	Hash digest
SHA256	`44f8e634b4a6b7c5126387943c203a9210d5fa3f3fa336f28ea22745ed006961`
MD5	`d368438494f9ac8cfce02ad1659ec220`
BLAKE2b-256	`7d3460cc9834eac9ef8e65946bc0a00454f99623dc9c4e1331b13c6f26722141`