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

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

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

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

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

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

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

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

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

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

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

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

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

[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