No module named 'pymysql'

Question

I'm trying to use PyMySQL on Ubuntu.

I've installed pymysql using both pip and pip3 but every time I use import pymysql, it returns ImportError: No module named 'pymysql'

I'm using Ubuntu 15.10 64-bit and Python 3.5.

The same .py works on Windows with Python 3.5, but not on Ubuntu.

You ran `sudo pip3 install pymysql` then tried to `import pymysql` running `python3`? — user530873, Oct 30 '15 at 23:42
Odd, works just fine on my system. Try running `sudo apt-get install python3-pymysql`. — user530873, Oct 30 '15 at 23:47
Answer is found, but It would be nice to learn why this happened. Are you sure that `python3` and `sudo python3` are the same python? — Darth Kotik, Aug 03 '17 at 07:18
These solutions didn't work for me, only Yash Gupta's suggestion (below) worked. I'm running ubuntu 14.04, Django 2.0, Python 3.6. — Raoul, Jan 17 '18 at 18:06
Same issue with Mac machine. pymysql is installed. but module error when we run python script. apt-get is not supported for mac. Used brew instead of apt-get but brew doesn't have package python3-pymysql — Pushpa Raja, Aug 29 '18 at 12:28

score 78 · Accepted Answer · answered Oct 30 '15 at 23:53

78

Sort of already answered this in the comments, but just so this question has an answer, the problem was resolved through running:

sudo apt-get install python3-pymysql

answered Oct 30 '15 at 23:53

user530873

1,055
9
17

2

If the problem still not goes away, try this on debian systems, `apt install python-mysqldb` – Luv33preet Apr 20 '18 at 07:19
1

Same issue with Mac machine. pymysql is installed. but module error when we run python script. apt-get is not supported for mac. Used brew instead of apt-get but brew doesn't have package python3-pymysql – Pushpa Raja Aug 29 '18 at 12:29
This line of code made my day. Thanks a lot! – Almett Nov 25 '21 at 18:22

score 34 · Answer 2 · edited May 16 '18 at 00:25

34

Use:

import pymysql

Not:

import PyMySQL

That works for me.

edited May 16 '18 at 00:25

Stephen Rauch

47,830
31
106
135

answered May 16 '18 at 00:04

Etoneja

1,023
1
8
15

1

This works on Ubuntu 16.04 and Red Hat Enterprise Linux 6.9. – Craig S. Anderson Jun 14 '18 at 18:58
3

Wish I could up-vote this twice. Such a silly mistake and contrary to any tutorial I've seen on this. – Eric Jul 31 '18 at 07:06
Ow DUDE. You saved my life. Worked on Debian 9 – Florian Doyen Dec 04 '18 at 17:17
This ones the time-saver~ – DeadLock Dec 07 '18 at 07:18

score 25 · Answer 3 · edited Jun 20 '20 at 09:12

25

After trying a few things, and coming across PyMySQL Github, this worked:

sudo pip install PyMySQL

And to import use:

import pymysql

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 10 '18 at 04:17

3kstc

1,871
3
29
53

This did not work on Mac. Install ok - Import not ok. – Joe Mar 27 '18 at 22:33
If you get the error: `awscli 1.15.47 has requirement PyYAML<=3.12,>=3.10, but you'll have pyyaml 4.1 which is incompatible.` Then you have dependency issues and have to run: `apt-get update && apt-get install -y python-pip libpython-dev` and `pip install awscli` – Herman Wilén Jul 17 '18 at 07:10

score 7 · Answer 4 · edited Jun 14 '17 at 06:24

7

If even sudo apt-get install python3-pymysql does not work for you try this:

Go to the PyMySQL page and download the zip file.
Then, via the terminal, cd to your Downloads folder and extract the folder
cd into the newly extracted folder
Install the setup.py file with: sudo python3 setup.py install

edited Jun 14 '17 at 06:24

FredFury

2,286
1
22
27

answered Jun 14 '17 at 04:55

Yash Gupta

187
2
11

The other solutions offered on this page didn't work for me, only this one. Thanks @Yash Gupta ! – Raoul Jan 17 '18 at 18:07
Neither this nor the above worked for me, will try a different connector – tim-oh Mar 19 '18 at 00:22

tim-oh · Answer 5 · 2018-03-19T01:05:24.900

Make sure that you're working with the version of Python that think you are. Within Python run import sys and print(sys.version).
Select the correct package manager to install pymysql with:
- For Python 2.x sudo pip install pymysql.
- For Python 3.x sudo pip3 install pymysql.
- For either running on Anaconda: sudo conda install pymysql.
- If that didn't work try APT: sudo apt-get install pymysql.
If all else fails, install the package directly:
- Go to the PyMySQL page and download the zip file.
- Then, via the terminal, cd to your Downloads folder and extract the folder.
- cd into the newly extracted folder.
- Install the setup.py file with: sudo python3 setup.py install.

This answer is a compilation of suggestions. Apart from the other ones proposed here, thanks to the comment by @cmaher on this related thread.

score 7 · Answer 6 · edited Dec 16 '19 at 22:00

7

To get around the problem, find out where pymysql is installed.

If for example it is installed in /usr/lib/python3.7/site-packages, add the following code above the import pymysql command:

import sys
sys.path.insert(0,"/usr/lib/python3.7/site-packages")
import pymysql

This ensures that your Python program can find where pymysql is installed.

edited Dec 16 '19 at 22:00

Max Vollmer

8,412
9
28
43

answered Dec 16 '19 at 21:36

Kenneth Watanabe

166
2
3

score 3 · Answer 7 · answered Nov 23 '19 at 15:19

3

fwiw, for a conda env:

 conda install -c anaconda pymysql

answered Nov 23 '19 at 15:19

jason m

6,519
20
69
122

score 2 · Answer 8 · edited Apr 30 '20 at 07:43

2

For windows or one using google colab, you can try this

!pip install pymysql
import pymysql

edited Apr 30 '20 at 07:43

Nandu Raj

2,072
9
20

answered Apr 30 '20 at 03:17

CHETAN Desai

21
2

score 0 · Answer 9 · answered Apr 13 '18 at 13:01

sudo apt-get install python3-pymysql

This command also works for me to install the package required for Flask app to tun on ubuntu 16x with WISG module on APACHE2 server.

BY default on WSGI uses python 3 installation of UBUNTU.

Anaconda custom installation won't work.

score 0 · Answer 10 · answered May 03 '18 at 14:47

0

I had this same problem just now, and found the reason was my editor (Visual Studio Code) was running against the wrong instance of python; I had it set to run again python bundled with tensorflow, I changed it to my Anaconda python and it worked.

answered May 03 '18 at 14:47

BigBadMe

1,754
1
19
27

score 0 · Answer 11 · edited Nov 12 '21 at 05:14

0

I ran into the same problem earlier, but solved it in a way slightly different from what we have here. So, I thought I'd add my way as well. Hopefully, it will help someone!

sudo apt-get install mysql-client didn't work for me. However, I have Homebrew already installed. So, instead, I tried:

brew install mysql-client

Now, I don't get the error any more.

edited Nov 12 '21 at 05:14

Nimantha

6,405
6
28
69

answered Jul 08 '18 at 15:06

Brad Ahrens

4,864
5
36
47

score 0 · Answer 12 · answered Aug 31 '19 at 02:01

0

Just a note: for Anaconda install packages command:

python setup.py install

answered Aug 31 '19 at 02:01

Yuqin Peng

59
3

score 0 · Answer 13 · answered Dec 17 '19 at 05:47

0

if you are using SPYDER IDE , just try to restart the console or restart the IDE, it works

answered Dec 17 '19 at 05:47

Dev Pandey

1

score 0 · Answer 14 · answered Aug 01 '20 at 02:49

I also got this error recently when using Anaconda on a Mac machine.

Here is what I found:

After running python3 -m pip install PyMySql, pymysql module is under /Library/Python/3.7/site-packages
Anaconda wants this module to be under /opt/anaconda3/lib/python3.8/site-packages

Therefore, after copying pymysql module to the designated path, it runs correctly.

score 0 · Answer 15 · edited Oct 04 '21 at 13:02

0

I tried installing pymysql on command prompt by typing

pip install pymysql

But it still dont work on my case, so I decided to try using the terminal IDE and it works.

edited Oct 04 '21 at 13:02

Samsul Islam

2,581
2
17
23

answered Jan 01 '21 at 07:31

brnslzar_26

1

gibbone · Answer 16 · 2021-09-18T14:52:09.107

Another common issue causing the error message to appear is related to conda environments in jupyter notebook and jupyter lab.

After successfully installing a module (pymysql in this case) in one environment, import may seem to fail because the environment has not been correctly registered. To solve this it is necessary to manually add kernels for each environment.

Solution and more details can be found here.

score 0 · Answer 17 · answered Feb 09 '22 at 01:03

0

You can also visit this lien pip install PyMySQL

answered Feb 09 '22 at 01:03

M E S A B O

783
1
11
15

score 0 · Answer 18 · answered Mar 30 '22 at 19:47

0

You just need to install:

python3 -m pip install PyMySQL

answered Mar 30 '22 at 19:47

ruddy simonpour

133
1
1
8

score 0 · Answer 19 · answered May 17 '22 at 07:43

0

The following pymysql version worked for me:

pip install pymysql==1.0.2

answered May 17 '22 at 07:43

hafiz031

2,236
3
26
48

score 0 · Answer 20 · answered Sep 19 '22 at 02:45

0

For anaconda user,

I got this error message. ModuleNotFoundError: No module named 'pymysql'

So tried 'pip install pymysql' but got below. Requirement already satisfied: pymysql

What worked for me is,

python file.py (NOT py file.py)

answered Sep 19 '22 at 02:45

CHOI

114
1
5

No module named 'pymysql'

20 Answers20

Linked