Facing below error "ModuleNotFoundError: No module named 'pymysql'"

Question

import os
import pymysql
import pandas as pd

host = os.getenv('MYSQL_HOST')
port = os.getenv('MYSQL_PORT')
user = os.getenv('MYSQL_USER')
password = os.getenv('MYSQL_PASSWORD')
database = os.getenv('MYSQL_DATABASE')

Need assistance as I am new to this.

Possible duplicate of [No module named 'pymysql'](https://stackoverflow.com/questions/33446347/no-module-named-pymysql) — Evan, May 04 '19 at 12:57

score 1 · Answer 1 · answered May 05 '19 at 05:39

1

This issue got fixed. I installed pymysql and mysql-connector using anaconda prompt.

Open Anaconda Prompt
pip install mysql-connector
pip install pymysql

answered May 05 '19 at 05:39

Pawan

563
1
6
19

Evan · Answer 2 · 2019-05-04T13:09:56.037

0

make sure it's installed.

run this in terminal/cmd:

windows

$ python3 -m pip install PyMySQL

or simply:

pip install PyMySQL

linux

$ sudo apt-get install python3-pymysql

edited May 04 '19 at 13:09

answered May 04 '19 at 13:00

Evan

2,327
5
31
63

Thanks for feedback!! But I am still facing the same error – Pawan May 04 '19 at 13:13
are you using virtual environment? try installing it there. – Evan May 04 '19 at 13:22

score 0 · Answer 3 · answered Jan 31 '21 at 11:38

0

I fixed this on my pc too it took me 1 day :) So go to your cmd or terminal and write : pip uninstall pymysql

python -m pip --upgrade pip pip install pymysql

This will fix it as the version of pip u are using cant build a wheel for the module

answered Jan 31 '21 at 11:38

Raunak Singh

36
2

Facing below error "ModuleNotFoundError: No module named 'pymysql'"

3 Answers3