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  lt module gt       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  Thank you in advance

User · Answer

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

User · Answer

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  quot -L usr local opt protobuf 3 7 lib quot  export CPPFLAGS  quot -I usr local opt protobuf 3 7 include quot

User · Answer

Installing mysqlclient using anaconda is pretty simple and straight forward   conda install -c bioconda mysqlclient   and then  install pymysql using pip   pip install pymysql   happy learning

User · Answer

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

User · Answer

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

User · Answer

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  quot -L usr local opt openssl lib quot  and export CPPFLAGS  quot -I usr local opt openssl include quot  as explained here pip install mysqlclient  That reinstalls mysqlclient and for whatever reason solved my problem

User · Answer

Use the below command to solve your issue   pip install mysql-python apt-get install python3-mysqldb libmysqlclient-dev python-dev   Works on Debian

User · Answer

This command did the trick from  Aniket Sinha s answer above    pip install mysqlclient

User · Answer

edit the init py file in your project origin directory  import pymysql  pymysql install as MySQLdb

User · Answer

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

User · Answer

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

User · Answer

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

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

Examples related to python

Examples related to mysql

Examples related to django

Examples related to phpmyadmin