Error loading MySQLdb module. Did you install mysqlclient? on MacOS

Question

Am Trying to connect to my mysql db from django app. I get the below error during migration:

django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module. Did you install mysqlclient?

I've already installed mysqlclient as below:

Requirement already satisfied: mysqlclient in /usr/local/lib/python3.7/site-packages (1.4.2.post1)

I've also tried with pymysql and adding below code to ini.py file:

import pymysql
pymysql.install_as_MySQLdb()

Gives me some other errors. What could be wrong?

Python 3.7 , mysql 5.7 and Django 2.2 are my setup versions.

Are you using the same environment for running django as you installed the MySQL client in? — Matt Seymour
– Matt Seymour, Commented Aug 8, 2019 at 8:49
you need to check any virtual environment installed or not for your project. activate it and try to migrate. for activation in linux:- source envname/bin/activate — Pavan Kumar T S
– Pavan Kumar T S, Commented Aug 8, 2019 at 8:59
@PavanKumarTS Yes i've also tried through virtualenv and i get the same error — Makamu Evans
– Makamu Evans, Commented Aug 8, 2019 at 9:00

shawshank718 · Accepted Answer · 2019-09-23 02:13:33Z

17

I had the same issue. Running the below command fixed it for me.

pip install --force-reinstall --ignore-installed --no-binary :all: mysqlclient

answered Sep 23, 2019 at 2:13

shawshank718

1991 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lndh · Accepted Answer · 2019-12-07 20:50:34Z

0

I had the same issue. The thing that worked for me is the following:

https://stackoverflow.com/a/54521244/12497648,

except when I did brew install mysql-client I got the message Warning: mysql-client 5.7.23_1 is already installed and up-to-date To reinstall 5.7.23_1, run "brew reinstall mysql-client" so I ran brew reinstall mysql-client after which I continued with the instructions from the link above (export PATH... etc.)

(also don't forget to do the pip wheel mysqlclient / pip install mysqlclient)

answered Dec 7, 2019 at 20:50

lndh

13 bronze badges

Comments

M3RS · Accepted Answer · 2020-06-18 10:01:26Z

0

If the error includes a Reason: image not found error, then it can be solved with symlinks like this:

Library not loaded: @rpath/libmysqlclient.21.dylib Reason: image not found Django migrate error using mysqlclient DB driver and MySQL 8 with macOS

answered Jun 18, 2020 at 10:01

M3RS

7,6706 gold badges42 silver badges52 bronze badges

Collectives™ on Stack Overflow

Error loading MySQLdb module. Did you install mysqlclient? on MacOS

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related