No module named 'mysql' python issue

Question

I am trying to create a sample python program which needs to connect to MySQL database.

import mysql.connector 

# opens the file file.txt in read mode
fileptr = open("sample-table","r")  

if fileptr:  
    print("file is opened successfully") 

#running a for loop   
for i in fileptr:  
    print(i) # i contains each line of the file 

#closes the opened file  
fileptr.close()

But I am getting this error

Traceback (most recent call last):
  File "check-db.py", line 1, in <module>
    import mysql.connector 
ModuleNotFoundError: No module named 'mysql'

It looks like the required module is not present. Is it possible to include and install the module without root access?

@markkeven, I am able to download it but installing it requires root privileges. I am looking for the solution to include mysql without root — ruhewo
– ruhewo, Commented Feb 3, 2019 at 7:50
Isn't that what virtual environments are for? You should be able to use them to install stuff locally without requiring additional privileges. — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Feb 3, 2019 at 10:04

Mehrdad Pedramfar · Accepted Answer · 2019-02-03 07:38:20Z

1

install pip like this:

apt install python-pip  #python 2
apt install python3-pip #python 3

Try install mysql using this command:

pip install pymysql

edited Feb 3, 2019 at 7:38

answered Feb 3, 2019 at 7:33

Mehrdad Pedramfar

11.1k4 gold badges43 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

ruhewo Over a year ago

I am getting the error as [username@archlinux ~]$ pip install pymysql bash: pip: command not found

Mehrdad Pedramfar Over a year ago

Then use this: python -m pip install pymysql

ruhewo Over a year ago

Thanks for the reply. I am again getting the error as /usr/bin/python: No module named pip

ruhewo Over a year ago

Tried installing pip, but again error sudo pacman -S python3-pip error: target not found: python3-pip

Mehrdad Pedramfar Over a year ago

what about sudo pacman -S python2-pip? are you using python3 or 2 ?

|

Collectives™ on Stack Overflow

No module named 'mysql' python issue

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related