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, Aug 08 '19 at 08: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, Aug 08 '19 at 08:59
@PavanKumarTS Yes i've also tried through virtualenv and i get the same error — Makamu Evans, Aug 08 '19 at 09:00
@PavanKumarTS Output is: Django==2.2.3 mysql-connector==2.2.9 mysql-connector-python==8.0.17 mysqlclient==1.4.2.post1 protobuf==3.9.1 PyMySQL==0.9.3 pytz==2019.1 six==1.12.0 sqlparse==0.3.0 virtualenv==16.7.2 — Makamu Evans, Aug 08 '19 at 09:05

score 14 · Answer 1 · answered Sep 23 '19 at 02:13

14

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 '19 at 02:13

shawshank718

169
1
6

score 0 · Answer 2 · answered Dec 07 '19 at 20:50

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)

score 0 · Answer 3 · answered Jun 18 '20 at 10:01

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 '20 at 10:01

M3RS

6,720
6
37
47

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

3 Answers3