No module named MySQLdb

Question

I am using Python version 2 5 4 and install MySQL version 5 0 and Django  Django is working fine with Python  but not MySQL  I am using it in Windows Vista

User · Answer

pip install --user mysqlclient    above works for me like charm for me I go the error from sqlalchemy actually  Environment information    Python   3 6  Ubuntu   16 04 conda 4 6 8

User · Answer

mysqldb is a module for Python that doesn t come pre-installed or with Django  You can download mysqldb here

User · Answer

I met the same situation under windows  and searched for the solution   Seeing this post Install mysql-python  Windows    It points out installing such a pip environment is difficult  needs many other dependencies   But I finally know that if we use mysqlclient with a version down to 1 3 4  it don t need that requirements any more  so try   pip install mysqlclient  1 3 4

User · Answer

Note this is not tested for python 3 x In CMD pip install wheel pip install pymysql  in settings py import pymysql pymysql install as MySQLdb    It worked with me

User · Answer

If you are running on Vista  you may want to check out the Bitnami Django stack  It is an all-in-one stack of Apache  Python  MySQL  etc  packaged with Bitrock crossplatform installers to make it really easy to get started  It runs on Windows  Mac and Linux  Oh  and is completely free

User · Answer

Try this    pip install MySQL-python

User · Answer

If your are using SQLAlchemy and the error is in  site-packages sqlalchemy dialects mysql mysqldb py   from    connectors mysqldb import                           MySQLDBExecutionContext                          MySQLDBCompiler                          MySQLDBIdentifierPreparer                          MySQLDBConnector                         so you may have missed mysqldb connector for SQLAlchemy and the solution is to re-install sqlalchemy after installing mysql-python module

User · Answer

On Debian Buster  the following solution worked for me with python 3 7   sudo apt-get install libmysqlclient-dev sudo apt-get install libssl-dev pip install mysqlclient

User · Answer

None of the above worked for me on an Ubuntu 18 04 fresh install via docker image   The following solved it for me   apt-get install holland python3-mysqldb

User · Answer

I personally recommend using pymysql instead of using the genuine MySQL connector  which provides you with a platform independent interface and could be installed through pip   And you could edit the SQLAlchemy URL schema like this  mysql pymysql   username passwd host database

User · Answer

If you are running on Vista  you may want to check out the Bitnami Django stack  It is an all-in-one stack of Apache  Python  MySQL  etc  packaged with Bitrock crossplatform installers to make it really easy to get started  It runs on Windows  Mac and Linux  Oh  and is completely free

User · Answer

I am at ubuntu  linux  and what worked for me was  sudo apt-get install python3-dev default-libmysqlclient-dev build-essential   and then finally  pip install mysqlclient

User · Answer

I met the same situation under windows  and searched for the solution   Seeing this post Install mysql-python  Windows    It points out installing such a pip environment is difficult  needs many other dependencies   But I finally know that if we use mysqlclient with a version down to 1 3 4  it don t need that requirements any more  so try   pip install mysqlclient  1 3 4

User · Answer

On my mac running Catalina v10 15 2  I had the following MySQLdb version conflict   ImportError  this is MySQLdb version  1  2  5   final   1   but  mysql is version  1  4  6   final   0    To resolve it  I did the following   pip uninstall MySQL-python pip install MySQL-python

User · Answer

For Python 3 6  sudo apt-get install libmysqlclient-dev and pip3 install mysqlclient  does the trick

User · Answer

Go to your project directory with cd  source bin activate  activate your env  if not previously   Run the command easy install MySQL-python

User · Answer

for window    pip install mysqlclient pymysql   then   import pymysql pymysql install as MySQLdb    for python 3 Ubuntu   sudo apt-get install -y python3-mysqldb

User · Answer

None of the above worked for me on an Ubuntu 18 04 fresh install via docker image   The following solved it for me   apt-get install holland python3-mysqldb

User · Answer

mysqldb is a module for Python that doesn t come pre-installed or with Django  You can download mysqldb here

User · Answer

and remember there is no MySQLdb for python3 x   I know the question is about python2 x but google rates this post quite high     EDIT  As stated in the comments  there s a MySQLdb s fork that adds Python 3 support  github com PyMySQL mysqlclient-python

User · Answer

You need to use one of the following commands  Which one depends on what OS and software you have and use    easy install mysql-python  mix os  pip install mysql-python  mix os  python 2  pip install mysqlclient  mix os  python 3  apt-get install python-mysqldb  Linux Ubuntu       cd  usr ports databases py-MySQLdb  amp  amp  make install clean  FreeBSD  yum install MySQL-python  Linux Fedora  CentOS        For Windows  see this answer  Install mysql-python  Windows

User · Answer

If pip install mysqlclient produces an error and you use Ubuntu  try   sudo apt-get install -y python-dev libmysqlclient-dev  amp  amp  sudo pip install mysqlclient

User · Answer

if your python version is 3 5  do a pip install mysqlclient  other things didn t work for me

User · Answer

If pip install mysqlclient produces an error and you use Ubuntu  try   sudo apt-get install -y python-dev libmysqlclient-dev  amp  amp  sudo pip install mysqlclient

User · Answer

I am at ubuntu  linux  and what worked for me was  sudo apt-get install python3-dev default-libmysqlclient-dev build-essential   and then finally  pip install mysqlclient

User · Answer

For anyone coming to this page when trying to find a solution for sqlalchemy  all you need to do is  pip install PyMySQL  And adjust your connection string to use PyMySQL  from mysql    to mysql pymysql

User · Answer

Go to your project directory with cd  source bin activate  activate your env  if not previously   Run the command easy install MySQL-python

User · Answer

if your python version is 3 5  do a pip install mysqlclient  other things didn t work for me

User · Answer

pip install PyMySQL   and then add this two lines to your Project Project init py  import pymysql pymysql install as MySQLdb     Works on WIN and python 3 3

User · Answer

pip install --user mysqlclient    above works for me like charm for me I go the error from sqlalchemy actually  Environment information    Python   3 6  Ubuntu   16 04 conda 4 6 8

User · Answer

I personally recommend using pymysql instead of using the genuine MySQL connector  which provides you with a platform independent interface and could be installed through pip   And you could edit the SQLAlchemy URL schema like this  mysql pymysql   username passwd host database

User · Answer

Ubuntu    sudo apt-get install python-mysqldb

User · Answer

On OSX these commands worked for me  brew install mysql-connector-c  pip install MySQL-python

User · Answer

On Debian Buster  the following solution worked for me with python 3 7   sudo apt-get install libmysqlclient-dev sudo apt-get install libssl-dev pip install mysqlclient

User · Answer

If your are using SQLAlchemy and the error is in  site-packages sqlalchemy dialects mysql mysqldb py   from    connectors mysqldb import                           MySQLDBExecutionContext                          MySQLDBCompiler                          MySQLDBIdentifierPreparer                          MySQLDBConnector                         so you may have missed mysqldb connector for SQLAlchemy and the solution is to re-install sqlalchemy after installing mysql-python module

User · Answer

pip install PyMySQL   and then add this two lines to your Project Project init py  import pymysql pymysql install as MySQLdb     Works on WIN and python 3 3

User · Answer

Win10   Python27 this worked for me   easy install mysql-python   all other  pip install     failed with dependency errors

User · Answer

for window    pip install mysqlclient pymysql   then   import pymysql pymysql install as MySQLdb    for python 3 Ubuntu   sudo apt-get install -y python3-mysqldb

User · Answer

mysqldb is a module for Python that doesn t come pre-installed or with Django  You can download mysqldb here

User · Answer

Thanks to derevo but I think there s another good way for doing this    Download and install ActivePython Open Command Prompt Type pypm install mysql-python Read the notes specific to this package    I think pypm is more powerful and reliable than easy install

User · Answer

mysqldb is a module for Python that doesn t come pre-installed or with Django  You can download mysqldb here

User · Answer

I have tried methods above  but still no module named  MySQLdb   finally  I succeed with   easy install mysql-python   my env is unbuntu 14 04

User · Answer

For Python 3 6  sudo apt-get install libmysqlclient-dev and pip3 install mysqlclient  does the trick

User · Answer

For anyone coming to this page when trying to find a solution for sqlalchemy  all you need to do is  pip install PyMySQL  And adjust your connection string to use PyMySQL  from mysql    to mysql pymysql

User · Answer

I have tried methods above  but still no module named  MySQLdb   finally  I succeed with   easy install mysql-python   my env is unbuntu 14 04

User · Answer

You need to use one of the following commands  Which one depends on what OS and software you have and use    easy install mysql-python  mix os  pip install mysql-python  mix os  python 2  pip install mysqlclient  mix os  python 3  apt-get install python-mysqldb  Linux Ubuntu       cd  usr ports databases py-MySQLdb  amp  amp  make install clean  FreeBSD  yum install MySQL-python  Linux Fedora  CentOS        For Windows  see this answer  Install mysql-python  Windows

User · Answer

and remember there is no MySQLdb for python3 x   I know the question is about python2 x but google rates this post quite high     EDIT  As stated in the comments  there s a MySQLdb s fork that adds Python 3 support  github com PyMySQL mysqlclient-python

User · Answer

Win10   Python27 this worked for me   easy install mysql-python   all other  pip install     failed with dependency errors

User · Answer

On my mac running Catalina v10 15 2  I had the following MySQLdb version conflict   ImportError  this is MySQLdb version  1  2  5   final   1   but  mysql is version  1  4  6   final   0    To resolve it  I did the following   pip uninstall MySQL-python pip install MySQL-python

User · Answer

If you are running on Vista  you may want to check out the Bitnami Django stack  It is an all-in-one stack of Apache  Python  MySQL  etc  packaged with Bitrock crossplatform installers to make it really easy to get started  It runs on Windows  Mac and Linux  Oh  and is completely free

User · Answer

On OSX these commands worked for me  brew install mysql-connector-c  pip install MySQL-python

User · Answer

For Python 3  version  install mysql-connector as   pip3 install mysql-connector    Sample Python DB connection code   import mysql connector db connection   mysql connector connect    host  localhost     user  root     passwd      print db connection    Output    gt   lt mysql connector connection MySQLConnection object at  gt  0x000002338A4C6B00 gt    This means  database is correctly connected

User · Answer

Ubuntu    sudo apt-get install python-mysqldb

User · Answer

If you are running on Vista  you may want to check out the Bitnami Django stack  It is an all-in-one stack of Apache  Python  MySQL  etc  packaged with Bitrock crossplatform installers to make it really easy to get started  It runs on Windows  Mac and Linux  Oh  and is completely free

User · Answer

Note this is not tested for python 3 x In CMD pip install wheel pip install pymysql  in settings py import pymysql pymysql install as MySQLdb    It worked with me

User · Answer

For Python 3  version  install mysql-connector as   pip3 install mysql-connector    Sample Python DB connection code   import mysql connector db connection   mysql connector connect    host  localhost     user  root     passwd      print db connection    Output    gt   lt mysql connector connection MySQLConnection object at  gt  0x000002338A4C6B00 gt    This means  database is correctly connected

User · Answer

Thanks to derevo but I think there s another good way for doing this    Download and install ActivePython Open Command Prompt Type pypm install mysql-python Read the notes specific to this package    I think pypm is more powerful and reliable than easy install

User · Answer

Try this    pip install MySQL-python

[python] No module named MySQLdb

Python : 3.6, Ubuntu : 16.04,conda 4.6.8

Examples related to python

Examples related to django

Examples related to python-2.x