Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

Question

I am using windows 10 command line for a django project using python34 however, I am facing difficulties with SQL.

I have already installed mysqlclient using pip install mysqlclient==1.3.5 and located the file to make sure I was not delusional. I then ran python manage.py migrate to migrate the tables to the SQL database (I am using phpmyadmin). However when the command returned with...

 File "C:\Users\user\env\lib\site-packages\django\db\backends\mysql\base.py", line 30, in <module>
    'Did you install mysqlclient or MySQL-python?' % e
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named 'MySQLdb'.
Did you install mysqlclient or MySQL-python?

I am aware that questions like these already exist, but not one solution seems to have made any impact on attempts.

https://stackoverflow.com/questions/21440230/install-mysql-python-windows ... check this question also — ytsejam, Oct 24 '17 at 05:00

score 278 · Accepted Answer · answered Apr 18 '18 at 07:10

278

pip install pymysql

Then, edit the __init__.py file in your project origin dir(the same as settings.py)

add:

import pymysql

pymysql.install_as_MySQLdb()

answered Apr 18 '18 at 07:10

aforwardz

3,109
1
10
15

2

Hey thanks, this worked for me, I added your code at the top of __init__.py I wonder why it needed this :( – Mehdi Kazemi Jul 19 '18 at 11:55
7

In django backend，it use the module named “MySQLdb” as mysql backend. In the function "install_as_MySQLdb()", you can see " sys.modules["MySQLdb"] = sys.modules["_mysql"] = sys.modules["pymysql"] " where pymysql make itself indicate to "MySQLdb" so that django works – aforwardz Jul 20 '18 at 05:30
1

Wish I could give this more than one upvote. This is the only solution that worked for me. thanks! – stackPusher Aug 17 '18 at 04:06
Thank you, working well with new and old django and MariaDB :) – porto Jan 24 '19 at 10:31
I faced this problem when in recent ArchLinux update, new mariaDB and python 3.7 was upgraded with the latest patch. This solution solves the issue. – SwapnilBhate Feb 21 '19 at 07:40
@aforwardz Is there any problem if you deploy including this file? or is it OK? – ozo Apr 19 '19 at 17:43
@Ale Just add several lines, that's fine – aforwardz Apr 22 '19 at 07:09
23

ERROR: django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3. – ox. May 05 '19 at 20:09
@ox. Were you able to get around this? – Pratik K. May 09 '19 at 09:48
@PratikK. Update to newer version of mysqlclient? – aforwardz May 10 '19 at 10:07
9

I got the same error as @ox when trying to use the PyMySQL workround (the latest current version of PyMySQL is 0.9.3). I have mysqlclient 1.4.2.post1 installed but django doesn't seem to see it, and PyMySQL 0.9.3 but when I configure django to use that instead of mysqlclient I get the version error. – Jonah May 14 '19 at 12:14
@jonah I think my issue may have been that I was trying to run a 2.7 codebase in a 3.7 env – ox. May 15 '19 at 11:56
4

I used `mysqlclient` instead of `pymysql` as **pymysql** is causing errors. – webcoder Sep 03 '19 at 06:22
mysqlclient also worked for me. And there is no need to put any code in __init__.py, you just need to install the package and change the database connection properties in the settings.py file – user3631926 Sep 13 '19 at 19:22
1

@ox. If you you use macos + homebrew and still see the error –– check your openssl symlinks https://stackoverflow.com/questions/59006602/dyld-library-not-loaded-usr-local-opt-openssl-lib-libssl-1-0-0-dylib – Dmitry Dec 09 '19 at 18:09
1

@ox. To fix that issue you'll need to add this line too `pymysql.version_info = (2, 0, 1, 'final', 0)` (use whichever version of `mysqlclient` you want to "fake"). – Faheel Oct 04 '20 at 23:19
1

get `AttributeError: 'str' object has no attribute 'decode'` after adding `pymysql.version_info = (2, 0, 1, 'final', 0)` – Tsonglew Oct 16 '20 at 11:39
My error output asked me to install `mysqlclient` and such package was not found. I tried `pymysql` and another error raised. Then I installed `cryptography` via `pip` and everything ran ok. – Enrique René Dec 11 '21 at 21:01
Now I get `ModuleNotFoundError: No module named 'pymysql'` – code writer 3000 Feb 12 '22 at 20:35
This worked for me. Thanks for saving me hours and hours of research. – John Aug 30 '23 at 17:10

score 27 · Answer 2 · answered Jul 30 '18 at 18:49

Faced same problem after migrating to python 3. Apparently, MySQL-python is incompatible, so as per official django docs, installed mysqlclient using pip install mysqlclient on Mac. Note that there are some OS specific issues mentioned in docs.

Quoting from docs:

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

See also: https://bugs.mysql.com/bug.php?id=86971

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 "

to

# 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

this worked. For me who use Ubuntu, simply `sudo apt-get install python-dev default-libmysqlclient-dev` then `sudo apt-get install python3-dev` then `pip install --force-reinstall --ignore-installed --no-binary :all: mysqlclient` and it works. — Rahmat Nazali Salimi, Jul 02 '20 at 07:16
@rahmatns you are a savior man...thanks a lot for this comment. Works fine inside my docker container — Olfredos6, Dec 02 '20 at 12:00

score 17 · Answer 3 · edited May 26 '19 at 09:52

17

For pip

pip install pymysql

For pip3 you should use

python3 -m pip install PyMySQL

Then, edit the init.py file in your project origin directory (the same as settings.py). Add:

import pymysql

pymysql.install_as_MySQLdb()

edited May 26 '19 at 09:52

JJJ

32,902
20
89
102

answered May 26 '19 at 09:31

Md Humayun Kabir

201
2
4

1

This worked for amazon linux 2 but I installed few other packages also. – darth vader Sep 24 '20 at 03:27
In my case doesn' t work with python and but work with python3 thank you! – CallMarl Nov 05 '20 at 10:22

score 13 · Answer 4 · answered Jun 01 '20 at 04:47

13

This command did the trick from @Aniket Sinha's answer above:

pip install mysqlclient

answered Jun 01 '20 at 04:47

Walk

1,531
17
21

3

I needed to run `sudo apt-get install libmysqlclient-dev python-dev` before this to get it to work. – Michael Millar Jan 16 '21 at 11:30

score 12 · Answer 5 · answered Jan 13 '18 at 02:26

12

Use the below command to solve your issue,

pip install mysql-python
apt-get install python3-mysqldb libmysqlclient-dev python-dev

Works on Debian

answered Jan 13 '18 at 02:26

Guaigua

168
1
6

16

Useless comment. `MySQL-python` lib doesn't support Python 3.x, `mysqlclient` should be proper replacement both for py3 and py2, but, unfortunately, sometimes you get `Did you install mysqlclient?` from Django when `mysqlclient` is already installed. That is the actual question. – mega.venik Mar 08 '18 at 04:49
@mega.venik It's not useless, +1 for solving my problem. – kispi May 18 '18 at 03:22

score 9 · Answer 6 · answered Aug 31 '20 at 08:32

9

If you already have mysqlclient installed (i.e. you see Requirement already satisfied) and are getting Error loading MySQLdb Module, the following worked for me:

pip uninstall mysqlclient
export LDFLAGS="-L/usr/local/opt/openssl/lib" and export CPPFLAGS="-I/usr/local/opt/openssl/include" as explained here
pip install mysqlclient

That reinstalls mysqlclient and for whatever reason solved my problem.

answered Aug 31 '20 at 08:32

alstr

1,358
18
34

1

Only solution that worked for me out of like 20 – D2TheC Apr 13 '22 at 10:31

score 3 · Answer 7 · edited Jul 27 '20 at 20:23

3

For MAC os user:

I have faced this issue many times. The key here is to set these environment variables before installing mysqlclient by pip command. For my case, they are like below:

export LDFLAGS="-L/usr/local/opt/protobuf@3.7/lib"
export CPPFLAGS="-I/usr/local/opt/protobuf@3.7/include"

edited Jul 27 '20 at 20:23

elad silver

9,222
4
43
67

answered Jan 03 '20 at 08:57

Dat TT

2,850
2
16
18

1

worked but with a correction: `export LDFLAGS="-L/usr/local/opt/protobuf/lib"` AND `export CPPFLAGS="-I/usr/local/opt/protobuf/include"` – elad silver Jul 27 '20 at 20:22

score 2 · Answer 8 · edited Jun 12 '19 at 11:58

2

edit the init.py file in your project origin directory

import pymysql

pymysql.install_as_MySQLdb()

edited Jun 12 '19 at 11:58

Jean-François Fabre

137,073
23
153
219

answered Jun 12 '19 at 08:56

nguyễn ngọc tú

41
1

score 2 · Answer 9 · edited Jun 23 '22 at 17:52

2

Installing mysqlclient using anaconda is pretty simple and straight forward.

conda install -c bioconda mysqlclient

and then, install pymysql using pip.

pip install pymysql

edited Jun 23 '22 at 17:52

Sunderam Dubey

1
11
20
40

answered Oct 12 '19 at 18:01

Bandham Manikanta

1,858
21
21

score 2 · Answer 10 · answered Jan 29 '21 at 07:05

2

I am using python 3 in windows. I also faced this issue. I just uninstalled 'mysqlclient' and then installed it again. It worked somehow

answered Jan 29 '21 at 07:05

sunil Prajapat

79
5

score 1 · Answer 11 · answered Feb 08 '22 at 11:38

Inspired by @elad silver's answer (thanks).

For OSx (Monterey) this worked for me:

Install protobuf

brew install protobuf

edit your .bashrc, or .zshenv file with these lines:

export LDFLAGS="${LDFLAGS} -L/usr/local/opt/protobuf/lib"
export CPPFLAGS="${CPPFLAGS} -I/usr/local/opt/protobuf/include"

Reinstall mysqlclient

pip uninstall mysqlclient
pip install mysqlclient

score 0 · Answer 12 · answered Dec 03 '18 at 08:17

I had this issue just recently even with using the python 3 compatible mysqlclient library and managed to solve my issue albeit in a bit of an unorthodox manner. If you are using MySQL 8, give this a try and see if it helps! :)

I simply made a copy of the libmysqlclient.21.dylib file located in my up-to-date installation of MySQL 8.0.13 which is was in /usr/local/mysql/lib and moved that copy under the same name to /usr/lib.

You will need to temporarily disable security integrity protection on your mac however to do this since you won't have or be able to change permissions to anything in /usr/lib without disabling it. You can do this by booting up into the recovery system, click Utilities on the menu at the top, and open up the terminal and enter csrutil disable into the terminal. Just remember to turn security integrity protection back on when you're done doing this! The only difference from the above process will be that you run csrutil enable instead.

You can find out more about how to disable and enable macOS's security integrity protection here.

score 0 · Answer 13 · answered May 18 '20 at 20:05

0

I simply needed to update my project's dependencies and then restart the server.

answered May 18 '20 at 20:05

CodeBiker

2,985
2
33
36

CJT · Answer 14 · 2021-04-21T14:06:40.410

To solve the problem run: pip install mysql-connector-python==8.0.23

Faced this issue with mysql.connector version 8.0.24 on mac(if code base is same then the issue should happen in windows as well). This file on line 51 imports "from django.db.backends.mysql.base import DatabaseWrapper as MySQLDatabaseWrapper". The imported file has following code 14-20(exact code and error that you received is part of code

try:
    import MySQLdb as Database
except ImportError as err:
    raise ImproperlyConfigured(
        'Error loading MySQLdb module.\n'
        'Did you install mysqlclient?'
    ) from err

The error is formed here. Not sure why this import keeps coming back in different version of mysql connector but 8.0.23 does not have the import, so I reverted to that version and error was gone... This is incase you wish to continue to work with mysql.connector.python. Not sure of logic and why this error is open for last 5 years...

score 0 · Answer 15 · answered Sep 10 '21 at 09:36

0

Run this command in CLI.

pip install mysqlclient

answered Sep 10 '21 at 09:36

Omar Magdy

2,331
14
13

score 0 · Answer 16 · answered Dec 23 '21 at 11:06

[NEW] Try pip install mysqlclient if not working, and if you are getting below error

MySQLdb/_mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory

Then visit this site and download the supported wheel. Now how to know the supported wheel. For example there are multiple wheel files like below:

mysqlclient-1.4.6-cp36-cp36m-win_amd64.whl

See the bold version cp36 which indicates CPython version 3.6 Just install it and this will resolve your issue.

Oh! now if you come across the another problem how to install the wheel file then just refer below line.

python -m pip install "C:\Users\Abhijit\Downloads\mysqlclient-1.4.6-cp36-cp36m-win_amd64.whl"

This actually solves my problem. – Abhijit Kumbhar Dec 23 '21 at 11:06 — Abhijit Kumbhar, Dec 23 '21 at 11:06

score 0 · Answer 17 · answered Apr 26 '22 at 09:34

For now because default mysql server on Debian is MariaDB.

user@cl1-preprod ~ % mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 39

apt-get install mariadb doesn't exist. To install it you need to install this package apt-get install mariadb-server but this is only the mysql server the client is also required apt-get install mariadb-client.

Then pip install mysqlclient

user@cl1-preprod ~ % apt-get remove libmysqlclient-dev python-dev
Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances
Lecture des informations d'état... Fait
Le paquet « libmysqlclient-dev » n'est pas installé, et ne peut donc être supprimé
Le paquet « python-dev » n'est pas installé, et ne peut donc être supprimé

score -1 · Answer 18 · answered Mar 12 '23 at 07:21

-1

On Windows, I ran

pip install mysqlclient

instead of

pip install pymysql

and it worked fine.

answered Mar 12 '23 at 07:21

Vishal Khopkar

21
3

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Blue Robin Mar 17 '23 at 00:07

score -2 · Answer 19 · answered Aug 11 '22 at 11:44

-2

You have to install mysqlclient. Just ran

pip install mysqlclient

answered Aug 11 '22 at 11:44

David Mezza

133
1
5

This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). - [From Review](/review/late-answers/32462434) – Vasco Cansado Carvalho Aug 17 '22 at 17:00
It provides the solution – David Mezza Aug 19 '22 at 11:39
The person posting the question wrote, and I'm quoting: "I have already installed mysqlclient" – Vasco Cansado Carvalho Aug 19 '22 at 15:29

Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

19 Answers19

Linked