ImportError: No module named MySQLdb

Question

I am referring the following tutorial to make a login page for my web application. http://code.tutsplus.com/tutorials/intro-to-flask-signing-in-and-out--net-29982

I am having issue with the database. I am getting an

ImportError: No module named MySQLdb

when I execute

http://127.0.0.1:5000/testdb

I have tried all possible ways to install python mysql, the one mentioned in the tutorial, easy_install, sudo apt-get install.

I have installed mysql in my virtual env. My directory structure is just the same as whats explained in the tutorial. The module is sucessfully installed in my system and still I am getting this error.

Please help. What could be causing this.

You've installed MySQL but have you installed the [MySQLdb](https://pypi.python.org/pypi/MySQL-python/1.2.4) package for Python? — Ffisegydd, Mar 07 '14 at 14:13
I used sudo apt-get install mysql-python. When i used pip i got Environment error for mysql_config — user3182194, Mar 07 '14 at 14:19
mysql is installed within my virtual enviroment and working properly and mysqldb has also been installed. — user3182194, Mar 07 '14 at 14:28

score 375 · Accepted Answer · answered Mar 07 '14 at 14:36

375

If you're having issues compiling the binary extension, or on a platform where you cant, you can try using the pure python PyMySQL bindings.

Simply pip install pymysql and switch your SQLAlchemy URI to start like this:

SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://.....'

There are some other drivers you could also try.

answered Mar 07 '14 at 14:36

DazWorrall

13,682
5
43
37

Did I miss something? Why isn't this listed here? Specifically that dialect name: http://docs.sqlalchemy.org/en/latest/core/engines.html. This was exactly what I had wrong though, thanks. – CashIsClay Apr 06 '18 at 20:13
Note the db uri is somewhat dependent upon the connector you use :) – Braden Holt Jun 13 '18 at 07:50
this didn't work with python2.7.* for me. use of `pip install MySQL-python` worked. – Rahul Goyal Nov 29 '18 at 07:43
2

this one helped so much while searching after a solution for flask-sqlalchemy errors. I faced: 1. Error running WSGI application ModuleNotFoundError: No module named 'MySQLdb' 2. (_mysql_exceptions.OperationalError) (2006, 'SSL connection error: SSL_CTX_set_tmp_dh failed') (Background on this error at: http://sqlalche.me/e/e3q8) thank you very much and I hope, that others will find this solution with this error descriptions faster as I have done! – bky Mar 15 '19 at 23:01
Worked on CentOS, seems to be the most non-OS-dependent answer. Thanks! – trpt4him Mar 21 '19 at 14:30
be remember to change ` SQLAlchemy URI ` ! this works for python 3 – penny chan Aug 25 '19 at 05:27
In my case(Python Anconda 3) , your link which has other connectors worked . I used MySQL-Connector – Pramod Sharma Aug 28 '19 at 04:08
Do not use pymysql driver because it's too slow ! ! ! – DachuanZhao May 09 '20 at 09:41
It works also for MariaDB (tested for v10.4, via SQLAlchemy). – mirekphd Aug 16 '20 at 18:28

score 103 · Answer 2 · answered Jun 23 '14 at 11:33

103

Or try this:

apt-get install python-mysqldb

answered Jun 23 '14 at 11:33

Edward van Kuik

1,357
1
9
9

10

I think the answer to the question is this – codersofthedark Sep 16 '14 at 12:47
2

python-mysqldb has some dependencies like VC++ library and sometimes doesn't work on 64 bit OS – Nima Soroush Oct 27 '15 at 16:52
1

This worked for me too. Ubuntu 16.04 with python 2.7 – genepool99 Jun 10 '16 at 17:16
For those people who this answer didn't resolve their issue this might be due to a virtualenv issue see: http://stackoverflow.com/a/43984484 – Chen Levy May 15 '17 at 16:27
More accurately: `sudo apt-get install python-mysqldb` – Tina J Dec 02 '17 at 05:33

score 39 · Answer 3 · answered Mar 16 '16 at 23:26

39

may you try

pip install mysqlclient

answered Mar 16 '16 at 23:26

Doni

511
5
5

2

Works for me on python 3.7.3 – nsssayom Oct 06 '19 at 15:29
1

Thanks for sharing, It worked when I was using Windows but I had some issues with `mysqlclient` (`OSError: mysql_config not found`) when I was trying to run the same app on Ubuntu, the accepted answer solved it. – Bilal Oct 07 '19 at 20:05
Works on OSX with anaconda and python 3.7.6 – Saaru Lindestøkke Apr 05 '20 at 20:36
simple! very simple and clear. – M E S A B O May 06 '22 at 23:09
This works on python 3.10 – Nathindu Himansha Feb 24 '23 at 14:57

score 19 · Answer 4 · answered Nov 06 '15 at 07:42

19

My issue is :

return __import__('MySQLdb')
ImportError: No module named MySQLdb

and my resolution :

pip install MySQL-python
yum install mysql-devel.x86_64

at the very beginning, i just installed MySQL-python, but the issue still existed. So i think if this issue happened, you should also take mysql-devel into consideration. Hope this helps.

answered Nov 06 '15 at 07:42

Adventurist

199
1
2

3

`pip install MySQL-python` yeah, that's the ticket – Kirby Jun 29 '16 at 23:21
This depends on Microsoft Visual C++ libraries in Windows environments – Erizo Feb 10 '20 at 20:50

score 16 · Answer 5 · edited Jan 15 '15 at 21:57

16

I got this issue when I was working on SQLAlchemy. The default dialect used by SQLAlchemy for MySQL is mysql+mysqldb.

engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')

I got the "No module named MySQLdb" error when the above command was executed. To fix it I installed the mysql-python module and the issue was fixed.

sudo pip install mysql-python

edited Jan 15 '15 at 21:57

JasonMArcher

14,195
22
56
52

answered Jan 15 '15 at 21:36

Waseem Akram Malik

567
9
14

3

before install mysql-python, you still need to install mysql or something containing the msyql_config command. – mxi1 Feb 13 '15 at 07:09

score 10 · Answer 6 · answered Mar 17 '16 at 08:54

10

It depends on Python Version as well in my experience.

If you are using Python 3, @DazWorrall answer worked fine for me.

However, if you are using Python 2, you should

sudo pip install mysql-python

which would install 'MySQLdb' module without having to change the SQLAlchemy URI.

answered Mar 17 '16 at 08:54

seokhoonlee

1,028
12
18

2

If anyone is down here, and getting environment error: mysql_config not found kinda thing, then sudo apt-get install libmysqlclient-dev can help you. Original answer: http://stackoverflow.com/a/5178698/2190689 – ssi-anik Nov 11 '16 at 18:11
If you get config parser type of error, then you may look at this. http://stackoverflow.com/a/23978968/2190689 – ssi-anik Nov 21 '16 at 11:03

score 10 · Answer 7 · 2016-10-08T19:47:47.177

So I spent about 5 hours trying to figure out how to deal with this issue when trying to run

./manage.py makemigrations

With Ubuntu Server LTS 16.1, a full LAMP stack, Apache2 MySql 5.7 PHP 7 Python 3 and Django 1.10.2 I really struggled to find a good answer to this. In fact, I am still not satisfied, but the ONLY solution that worked for me is this...

sudo apt-get install build-essential python-dev libapache2-mod-wsgi-py3 libmysqlclient-dev

followed by (from inside the virtual environment)

pip install mysqlclient

I really dislike having to use dev installs when I am trying to set up a new web server, but unfortunately this configuration was the only mostly comfortable path I could take.

If you don't have '-dev' packages and a compiler, you cannot install any Python module which has a C extension component that needs to be compiled. Your only option would be to use a separate build box which has the extra bits and build Python wheel files. Then copy the wheels to your target system and install the packages from wheels instead. — Graham Dumpleton, Oct 08 '16 at 21:40

score 6 · Answer 8 · answered May 09 '20 at 09:49

6

In ubuntu 20 , you can try this :

sudo apt-get install libmysqlclient-dev
sudo apt-get install gcc
pip install mysqlclient

answered May 09 '20 at 09:49

DachuanZhao

1,181
3
15
34

score 3 · Answer 9 · edited May 23 '17 at 11:47

While @Edward van Kuik's answer is correct, it doesn't take into account an issue with virtualenv v1.7 and above.

In particular installing python-mysqldb via apt on Ubuntu put it under /usr/lib/pythonX.Y/dist-packages, but this path isn't included by default in the virtualenv's sys.path.

So to resolve this, you should create your virtualenv with system packages by running something like:

virtualenv --system-site-packages .venv

score 2 · Answer 10 · edited Mar 27 '18 at 23:32

2

yum install MySQL-python.x86_64

worked for me.

edited Mar 27 '18 at 23:32

Paul Roub

36,322
27
84
93

answered Mar 27 '18 at 23:23

hamed

21
1

score 2 · Answer 11 · answered Feb 09 '22 at 01:30

for Ubuntu 20.04 with python3

 sudo apt-get install python3-mysqldb

by default, this work for me

Create a sqlite engine instance

engine = create_engine('mysql://username:password@your_host/your_dbname')

OR

pip install pymysql

Create a sqlite engine instance

create_engine('mysql://...

score 2 · Answer 12 · answered Jul 02 '22 at 12:13

2

I have the same issue the install mySQL connector and resolved

pip install mysqlclient

more details -> SQLAlchemy official docs

answered Jul 02 '22 at 12:13

Shakeel Haider

107
1
5

score 1 · Answer 13 · edited May 22 '22 at 08:21

1

Here's what I did:

First, install a python package: pip3 install PyMySQL

Then add the following lines of code to your Project:

import pymysql
pymysql.install_as_MySQLdb()

this should fix your issue by now, the following one is optional and for anyone who is using SqlAlchemy to connect to mysql server:

Replace engine = create_engine("mysql://YOURMYSQLURL") to: engine = create_engine("mysql+pymysql://YOURMYSQLURL")

edited May 22 '22 at 08:21

Nimantha

6,405
6
28
69

answered Apr 03 '22 at 21:51

psychoSherlock

112
1
9

1

This wonderfully works for me, while others don't. Thanks! – Nam G VU Apr 28 '23 at 01:50
1

@NamGVU ikr!!!.... I tried all the online solutions but it actually turns out the right answer was in the documentation itself.... Even ChatGPT did not recommend this answer. Upvote to help others!! – psychoSherlock Apr 29 '23 at 06:08

score 0 · Answer 14 · answered Nov 06 '17 at 06:53

0

Got so many errors related to permissions and what not. You may wanna try this :

xcode-select --install

answered Nov 06 '17 at 06:53

chandan kharbanda

199
2
14

score 0 · Answer 15 · answered Jul 07 '21 at 11:31

0

sudo apt-get install python-mysqldb

answered Jul 07 '21 at 11:31

kamran kausar

4,117
1
23
17

score -1 · Answer 16 · edited May 22 '22 at 06:12

I have faced this type of error when I tray to build python flask eccomerce web-application

ModuleNotFoundError: No module named 'MySQLdb'?

I tray to see the version of python installed on my window 10

it was python 3.10

so MYSQL-PYTHON is compatable with the other version of python 3.8

I delet python 3.10 and I nstalled the version python 3.8

It become ok!

python --version

3.8

pip --version

python 3.8

so install the connector

pip install MYSQL-PYTHON

successfuly installed

ImportError: No module named MySQLdb

16 Answers16

Create a sqlite engine instance

Create a sqlite engine instance

Linked

Related