How to use MySQLdb with Python and Django in OSX 10 6

Question

This is a much discussed issue for OSX 10 6 users  but I haven t been able to find a solution that works  Here s my setup   Python 2 6 1 64bit Django 1 2 1 MySQL 5 1 47 osx10 6 64bit  I create a virtualenvwrapper with --no-site-packages  then installed Django  When I activate the virtualenv and run python manage py syncdb  I get this error   Traceback  most recent call last   File  manage py   line 11  in  lt module gt    execute manager settings  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management   init   py   line 438  in execute manager   utility execute   File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management   init   py   line 379  in execute   self fetch command subcommand  run from argv self argv  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management   init   py   line 257  in fetch command   klass   load command class app name  subcommand  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management   init   py   line 67  in load command class   module   import module   s management commands  s     app name  name   File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django utils importlib py   line 35  in import module     import   name  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management commands syncdb py   line 7  in  lt module gt  from django core management sql import custom sql for model  emit post sync signal File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django core management sql py   line 5  in  lt module gt  from django contrib contenttypes import generic File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django contrib contenttypes generic py   line 6  in  lt module gt    from django db import connection File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django db   init   py   line 75  in  lt module gt    connection   connections DEFAULT DB ALIAS  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django db utils py   line 91  in   getitem     backend   load backend db  ENGINE    File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django db utils py   line 32  in load backend   return import module   base   backend name  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django utils importlib py   line 35  in import module     import   name  File   Users joerobinson  virtualenvs dj tut lib python2 6 site-packages django db backends mysql base py   line 14  in  lt module gt    raise ImproperlyConfigured  Error loading MySQLdb module   s    e  django core exceptions ImproperlyConfigured  Error loading MySQLdb module  No module named MySQLdb   I ve also installed the MySQL for Python adapter  but to no avail  maybe I installed it improperly      Anyone dealt with this before

User · Answer

mysql config must be on the path  On Mac  do  export PATH  PATH  usr local mysql bin  pip install MySQL-python

User · Answer

I had the same error and pip install MySQL-python solved it for me   Alternate installs    If you don t have pip  easy install MySQL-python should work  If your python is managed by a packaging system  you might have to use that system  e g  sudo apt-get install        Below  Soli notes that if you receive the following error      EnvironmentError  mysql config not found       then you have a further system dependency issue  Solving this will vary from system to system  but for Debian-derived systems   sudo apt-get install python-mysqldb

User · Answer

This worked for Red Hat Enterprise Linux Server release 6 4  sudo yum install mysql-devel sudo yum install python-devel pip install mysql-python

User · Answer

You can install as  pip install mysqlclient

User · Answer

Try this  This solved the issue for me       pip install MySQL-python

User · Answer

I had the same problem on OSX 10 6 6  But just a simple easy install mysql-python on terminal did not solve it as another hiccup followed   error  command  gcc-4 2  failed with exit status 1    Apparently  this issue arises after upgrading from XCode3  which is natively shipped with OSX 10 6  to XCode4  This newer ver removes support for building ppc arch  If its the same case  try doing as follows before easy install mysql-python  sudo bash export ARCHFLAGS  -arch i386 -arch x86 64  rm -r build python setup py build python setup py install   Many thanks to Ned Deily for this solution  Check here

User · Answer

pip install mysql-python   raised an error      EnvironmentError  mysql config not found   sudo apt-get install python-mysqldb   fixed the problem

User · Answer

sudo apt-get install python-mysqldb works perfectly in ubuntu  pip install mysql-python raises an Environment Error

User · Answer

Run this command   sudo pip install mysql-python    now you can run your command   python manage py startapp filename

User · Answer

I made the upgrade to OSX Mavericks and Pycharm 3 and start to get this error  i used pip and easy install and got the error       command  usr bin clang  failed with exit status 1    So i need to update to Xcode 5 and tried again to install using pip   pip install mysql-python   That fix all the problems

User · Answer

I encountered similar situations like yours that I am using python3 7 and django 2 1 in virtualenv on mac osx   Try to run command   pip install mysql-python pip install pymysql   And edit   init   py file in your project folder and add following   import pymysql  pymysql install as MySQLdb     Then run  python3 manage py runserver or  python manage py runserver

User · Answer

pip did not work for me on windows 8 64 bits system   easy install mysql-python works for me  You can use easy install to avoid building binaries on windows if pip does not work

User · Answer

I overcame the same problem by installing MySQL-python library using pip  You can see the message displayed on my console when I first changed my database settings in settings py and executed makemigrations command The solution is following the below message  just see that       vir env  admins-MacBook-Pro-3 src admin  python manage py makemigrations Traceback  most recent call last     File  manage py   line 10  in  lt module gt      execute from command line sys argv    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django core management   init   py   line 338  in execute from command line     utility execute     File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django core management   init   py   line 312  in execute     django setup     File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django   init   py   line 18  in setup     apps populate settings INSTALLED APPS    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django apps registry py   line 108  in populate     app config import models all models    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django apps config py   line 198  in import models     self models module   import module models module name    File   usr local Cellar python 2 7 12 1 Frameworks Python framework Versions 2 7 lib python2 7 importlib   init   py   line 37  in import module       import   name    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django contrib auth models py   line 41  in  lt module gt      class Permission models Model     File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db models base py   line 139  in   new       new class add to class   meta   Options meta    kwargs     File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db models base py   line 324  in add to class     value contribute to class cls  name    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db models options py   line 250  in contribute to class     self db table   truncate name self db table  connection ops max name length      File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db   init   py   line 36  in   getattr       return getattr connections DEFAULT DB ALIAS   item    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db utils py   line 240  in   getitem       backend   load backend db  ENGINE      File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db utils py   line 111  in load backend     return import module   s base    backend name    File   usr local Cellar python 2 7 12 1 Frameworks Python framework Versions 2 7 lib python2 7 importlib   init   py   line 37  in import module       import   name    File   Users admin Desktop SetUp1 vir env lib python2 7 site-packages django db backends mysql base py   line 27  in  lt module gt      raise ImproperlyConfigured  Error loading MySQLdb module   s    e  django core exceptions ImproperlyConfigured  Error loading MySQLdb module  No module named MySQLdb   Finally I overcame this problem as follows    vir env  admins-MacBook-Pro-3 src admin  pip install MySQLdb Collecting MySQLdb   Could not find a version that satisfies the requirement MySQLdb  from versions    No matching distribution found for MySQLdb  vir env  admins-MacBook-Pro-3 src admin  pip install MySQL-python Collecting MySQL-python   Downloading MySQL-python-1 2 5 zip  108kB      100                                                                     112kB 364kB s  Building wheels for collected packages  MySQL-python   Running setup py bdist wheel for MySQL-python     done   Stored in directory   Users admin Library Caches pip wheels 38 a3 89 ec87e092cfb38450fc91a62562055231deb0049a029054dc62 Successfully built MySQL-python Installing collected packages  MySQL-python Successfully installed MySQL-python-1 2 5  vir env  admins-MacBook-Pro-3 src admin  python manage py makemigrations No changes detected  vir env  admins-MacBook-Pro-3 src admin  python manage py migrate Operations to perform    Synchronize unmigrated apps  staticfiles  rest framework  messages  crispy forms   Apply all migrations  admin  contenttypes  sessions  auth  PyApp Synchronizing apps without migrations    Creating tables        Running deferred SQL      Installing custom SQL    Running migrations    Rendering model states    DONE   Applying PyApp 0001 initial    OK   Applying PyApp 0002 auto 20170310 0936    OK   Applying PyApp 0003 auto 20170310 0953    OK   Applying PyApp 0004 auto 20170310 0954    OK   Applying PyApp 0005 auto 20170311 0619    OK   Applying PyApp 0006 auto 20170311 0622    OK   Applying PyApp 0007 loraevksensor    OK   Applying PyApp 0008 auto 20170315 0752    OK   Applying PyApp 0009 auto 20170315 0753    OK   Applying PyApp 0010 auto 20170315 0806    OK   Applying PyApp 0011 auto 20170315 0814    OK   Applying PyApp 0012 auto 20170315 0820    OK   Applying PyApp 0013 auto 20170315 0822    OK   Applying PyApp 0014 auto 20170315 0907    OK   Applying PyApp 0015 auto 20170315 1041    OK   Applying PyApp 0016 auto 20170315 1355    OK   Applying PyApp 0017 auto 20170315 1401    OK   Applying PyApp 0018 auto 20170331 1348    OK   Applying PyApp 0019 auto 20170331 1349    OK   Applying PyApp 0020 auto 20170331 1350    OK   Applying PyApp 0021 auto 20170331 1458    OK   Applying PyApp 0022 delete postoffice    OK   Applying PyApp 0023 posoffice    OK   Applying PyApp 0024 auto 20170331 1504    OK   Applying PyApp 0025 auto 20170331 1511    OK   Applying contenttypes 0001 initial    OK   Applying auth 0001 initial    OK   Applying admin 0001 initial    OK   Applying contenttypes 0002 remove content type name    OK   Applying auth 0002 alter permission name max length    OK   Applying auth 0003 alter user email max length    OK   Applying auth 0004 alter user username opts    OK   Applying auth 0005 alter user last login null    OK   Applying auth 0006 require contenttypes 0002    OK   Applying sessions 0001 initial    OK  vir env  admins-MacBook-Pro-3 src admin

User · Answer

Install Command Line Tools Works for me   xcode-select --install

User · Answer

The following worked perfectly for me  running Ubuntu 13 10 64-bit   sudo apt-get install libmysqlclient-dev sudo apt-get install python-dev   Now  navigate to your virtualenv  such as env folder  and execute the following   sudo   bin pip install mysql-python   I actually found the solution in a separate question and I am quoting it below      If you have created the virtualenv with the --no-site-packages switch    the default   then system-wide installed additions such as MySQLdb   are not included in the virtual environment packages       You need to install MySQLdb with the pip command installed with the   virtualenv  Either activate the virtualenv with the bin activate   script  or use bin pip from within the virtualenv to install the   MySQLdb library locally as well       Alternatively  create a new virtualenv with system site-packages   included by using the --system-site-package switch    I think this should also work with OSX  The only problem would be getting an equivalent command for installing libmysqlclient-dev and python-dev as they are needed to compile  mysql-python I guess   Hope this helps

User · Answer

This issue was the result of an incomplete   incorrect installation of the MySQL for Python adapter  Specifically  I had to edit the path to the mysql config file to point to  usr local mysql bin mysql config - discussed in greater detail in this article  http   dakrauth com blog entry python-and-django-setup-mac-os-x-leopard

User · Answer

The error raised here is in importing the python module  This can be solved by adding the python site-packages folder to the environment variable  PYTHONPATH on OS X  So we can add the following command to the  bash profile file   export PYTHONPATH   PYTHONPATH  usr local lib pythonx x site-packages      replace x x with the python version you are using

User · Answer

Running Ubuntu  I had to do   sudo apt-get install python-mysqldb

User · Answer

How I got it working   virtualenv -p python3 5 env test   After sourcing my env   pip install pymysql pip install django   Then  I ran the startproject and inside the manage py  I added this     try        import pymysql       pymysql install as MySQLdb     except        pass   Also  updated this inside settings   DATABASES          default              ENGINE    django db backends mysql            NAME    foobar db            USER    foobaruser            PASSWORD    foobarpwd             I also have configparser  3 5 0 installed in my virtualenv  not sure if that was required or not     Hope it helps

User · Answer

If you are using python3  then try this My OS is Ubuntu 16 04    sudo apt-get install python3-mysqldb

User · Answer

For me the problem got solved by simply reinstalling mysql-python  pip uninstall mysql-python pip install mysql-python

User · Answer

Try this the commands below  They work for me   brew install mysql-connector-c  pip install MySQL-python

User · Answer

Adding to other answers  the following helped me finish the installation mysql-python   virtualenv  mysql-python  pip  anyone know how   On Ubuntu     apt-get install libmysqlclient-dev apt-get install python-dev pip install mysql-python   Don t forget to add  sudo  to the beginning of commands if you don t have the proper permissions

[python] How to use MySQLdb with Python and Django in OSX 10.6?

Examples related to python

Examples related to mysql

Examples related to django

Examples related to virtualenv

Examples related to virtualenvwrapper