django core exceptions ImproperlyConfigured Error loading MySQLdb module No module named MySQLdb

Question

The problem Im facing while trying to connect to database for mysql  I have also given the database settings that i have used    Traceback  most recent call last    File  manage py   line 10  in  lt module gt   execute from command line sys argv   File   home ar Desktop test testprac local lib python2 7 site-packages django core management   init   py   line 453  in execute from command line utility execute   File   home ar Desktop test testprac local lib python2 7 site-packages django core management   init   py   line 392  in execute self fetch command subcommand  run from argv self argv  File   home ar Desktop test testprac local lib python2 7 site-packages django core management   init   py   line 272  in fetch command klass   load command class app name  subcommand  File   home ar Desktop test testprac local lib python2 7 site-packages django core management   init   py   line 77  in load command class module   import module   s management commands  s     app name  name   File   home arundhati Desktop test testprac local lib python2 7 site-packages django utils importlib py   line 35  in import module   import   name  File   home ar Desktop test testprac local lib python2 7 site-packages django core management commands syncdb py   line 8  in  lt module gt  from django core management sql import custom sql for model  emit post sync signal File   home ar Desktop test testprac local lib python2 7 site-packages django core management sql py   line 9  in  lt module gt  from django db import models File   home ar Desktop test testprac local lib python2 7 site-packages django db   init   py   line 40  in  lt module gt  backend   load backend connection settings dict  ENGINE    File   home ar Desktop test testprac local lib python2 7 site-packages django db   init   py   line 34  in   getattr   return getattr connections DEFAULT DB ALIAS   item  File   home ar Desktop test testprac local lib python2 7 site-packages django db utils py   line 93  in   getitem   backend   load backend db  ENGINE    File   home ar Desktop test testprac local lib python2 7 site-packages django db utils py   line 27  in load backend return import module   base   backend name  File   home ar Desktop test testprac local lib python2 7 site-packages django utils importlib py   line 35  in import module   import   name  File   home ar Desktop test testprac local lib python2 7 site-packages django db backends mysql base py   line 17  in  lt module gt  raise ImproperlyConfigured  Error loading MySQLdb module   s    e  django core exceptions ImproperlyConfigured  Error loading MySQLdb module  No module named MySQLdb   Databse Settings    DATABASES          default              ENGINE    django db backends mysql     Add  postgresql psycopg2    mysql    sqlite3  or  oracle            NAME    ar test db                          Or path to database file if using            The following settings are not used with sqlite3           USER                PASSWORD                HOST                              Empty for localhost through domain sockets or    127 0 0 1  for localhost through TCP           PORT                              Set to empty string for default            Thanks a lot for the help

User · Accepted Answer

It looks like you don t have the python mysql package installed  try   pip install mysql-python   or if not using a virtual environment  on  nix hosts    sudo pip install mysql-python

User · Answer

Just to add to other answers  if you re using Django  it is advisable that you install mysql-python BEFORE installing Django

User · Answer

try   pip install mysqlclient   I recommend to use it in a virtual environment

User · Answer

Maybe you can try the following mode of operation  sudo python manage py runserver 0 0 0 0 8000

User · Answer

I think it is the version error  try installing this in following order   sudo apt-get install python3-mysqldb  pip3 install mysqlclient  python3 manage py makemigrations  python3 manage py migrate

User · Answer

It is because it did not find sql connector  try   pip install mysqlclient

User · Answer

Faced similar issue  I tried installing mysql-python using pip  but it failed due to gcc dependency errors   The solution that worked for me  conda install mysql-python   Please note that I already had anaconda installed  which didn t had gcc dependency

User · Answer

You are missing the python mysqldb library  Use this command  for Debian Ubuntu  to install it  sudo apt-get install python-mysqldb

User · Answer

Seems like you don t have permission to the Python folder  Try sudo chown -R  USER  Library Python 2 7

User · Answer

I was having the same problem The following solved my issue  Run pip install pymysql in your shell  Then  edit the init py file in your project origin directory the same as settings py  and then  add   import pymysql  pymysql install as MySQLdb    this should solve the problem

User · Answer

If you get errors trying to install mysqlclient with pip  you may lack the mysql dev library  Install it by running   apt-get install libmysqlclient-dev   and try again to install mysqlclient   pip install mysqlclient

User · Answer

For Ubuntu 16 04 and 18 04 or python 3 versions  sudo apt-get install python3-mysqldb

User · Answer

I ve solved this issue in this environment     pyenv --version pyenv 1 2 9    python --version Python 3 7 2    python -m django --version 2 1 7     settings py  DATABASES          default              NAME    my db name            ENGINE    mysql connector django        django db backends mysql           USER     lt user gt             PASSWORD     lt pass gt             HOST    localhost            PORT   3306           OPTIONS                  autocommit   True                       If you use  ENGINE    mysql connector django    install driver executing       pip install mysql-connector-python Successfully installed mysql-connector-python-8 0 15 protobuf-3 7 0 six-1 12 0   Note that   pip install mysql-pythondidn t work for me      Note that if you use   ENGINE    django db backends mysql    you should install driver executing    pip install mysqlclient  Finally execute    python manage py migrate  If it s all right  python creates all these tables id database    auth group auth group permissions auth permission auth user auth user groups auth user user permissions django admin log django content type django migrations django session

User · Answer

This happened with me as well and I believe this has become a common error not only for Django developers but also for Flask as well  so the way I solved this issue was using brew    brew install mysql sudo pip install mysql-python   This way every single issue was solved and both frameworks work absolutely fine   P S   For those who use macports  such as myself   this can be an issue as brew works in a different level  my advice is to use brew instead of macports  I hope I could be helpful

User · Answer

If you are using pyhton version 3 4 or above  you have to install   sudo apt-get install python3-dev libmysqlclient-dev    in terminal  then install pip install mysqlclient on your virtual env or where you installed pip

User · Answer

Download and install Mysql-python from here for windows environment   http   www lfd uci edu  gohlke pythonlibs  mysql-python

User · Answer

My answer is similar to  Ron-E  but I got a few more errors corrections so I m putting my steps below for Mac OSX on Mavericks and Python 2 7 6    Install Python mysql package  if you get a success message  then ignore the below steps   pip install mysql-python  When I did the above  I got the error  EnvironmentError  mysql config not found           To fix this  I did the below in terminal   export PATH  PATH  usr local mysql bin  When I reran step 1  I get a new error  error  command  cc  failed with exit status 1       To fix this  I did the below in terminal    export CFLAGS -Qunused-arguments  export CPPFLAGS -Qunused-arguments  I reran step 1 and got the success message  Successfully installed mysql-python

User · Answer

you have to install python-mysqldb - Python interface to MySQL  Try  sudo apt-get install python-mysqldb

User · Answer

I wasted a lot of time on this  Turns out that the default database library is not supported for Python 3  You have to use a different one

User · Answer

When I set up Django development environment for PyCharm in Mac OS X Mountain Lion with python  mysql  sequel pro application I got error same as owner of this thread  However  my answer for them who is running python-mysqldb under Mac OS Mountain Lion x86 x64  MySql and Python also should be same architecture  and already tried everything like pip and etc  In order fix this problem do following steps    Download MySql for Python from here Untar downloaded file  In terminal window do following  tar xvfz downloade tar  cd  to untared directory Run sudo python setup py install If you get error something like this   Environment Error   usr local bin mysql config not found  then try to add path ass follows   export PATH  PATH  usr local mysql bin   But id did not helped to me and I found another solution  In the end of command execution error output which looks like this   File   path to file MySQL-python-1 2 4b4 setup posix py   line 25  in mysql config raise EnvironmentError   s not found     mysql config path    Open setup posix py with vim and go to line 25  In your case it can be different unless if it is same version    Line 25 should look like this after your editing unless your mysql have symbolic link like follows   usr local mysql bin      f   popen   s -- s       usr local mysql bin mysql config   what   After this I got another error as following   django core exceptions ImproperlyConfigured  Error loading MySQLdb module  dlopen  Library Python 2 7 site-packages MySQL python-1 2 4b4-py2 7-macosx-10 8-intel egg  mysql so  2   Library not loaded  libmysqlclient 18 dylib Referenced from   Library Python 2 7 site-packages MySQL python-1 2 4b4-py2 7-macosx-10 8-intel egg  mysql so Reason  image not found Finally I did following in console   sudo ln -s  usr local mysql lib libmysqlclient 18 dylib  usr lib libmysqlclient 18 dylib   Currently everything works fine  So I hope it will be helpful for somebody who uses Mac

User · Answer

Source Install  if not found   pip install mysql connector  Settings   default          ENGINE    mysql connector django        NAME               HOST               PORT    3306        USER               PASSWORD

User · Answer

With the same error message as Will  it worked for me to install mysql first as the missing file will be added during the installation  So after  brew install mysql  pip install mysql-python   ran without errors

User · Answer

On Ubuntu it is advised to use the distributions repository   sudo apt-get install python-mysqldb

User · Answer

if the error looks like this   django core exceptions ImproperlyConfigured  Error loading MySQLdb module  dlopen  Library Frameworks Python framework Versions 2 7 lib python2 7 site-packages  mysql so  2   Library not loaded    usr local opt mysql lib libmysqlclient 20 dylib Referenced from   Library Frameworks Python framework Versions 2 7 lib python2 7 site-packages  mysql so   then try    pip install python-mysqldb

[python] django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

Examples related to python

Examples related to mysql

Examples related to database

Examples related to django