I can't import MySQLdb to my Python Program

Question

I need to use a MySQL Database in my Python program, so i need to connect Python to MySQL.

I am using MacOsX Sierra and i tried installing connector, mysqlclient and nothing worked for me.

I use PyCharm, and whenever I type

import MySQLdb

or

import mysql.connector

I get the error:

Traceback (most recent call last):
  File "/Users/muhammed/Desktop/PyhtonHomework/venv/homework.py", line 1, in <module>
    import MySQLdb
ModuleNotFoundError: No module named 'MySQLdb'

How can I fix it? I have a term project and i can't even start thanks to this error.

Python version: 3.6.4

You should post the actual traceback. "Mysql" != "mysql" so the error, as you stated it, doesn't match your code — roganjosh
– roganjosh, Commented Mar 18, 2018 at 15:09
It's case-sensitive. You should try import mysql instead. The first attempt is obviously wrong but the second attempt, if it throws the same error, is not so clear. You did pip install the module, right? — roganjosh
– roganjosh, Commented Mar 18, 2018 at 15:22
Thanks for reply. I tried running 'import mysql' and it still prints the same traceback with ModuleNotFoundError: No module named 'mysql'. — Muhammed Gül
– Muhammed Gül, Commented Mar 18, 2018 at 15:25

alstr · Accepted Answer · 2018-03-18 16:12:10Z

5

MySQLdb doesn’t support Python 3. Try using an alternative MySQL Python package.

I successfully used MySQL Connector Python, specifically http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip with Python 3 — have a look at the latest version and the usage documentation.

pip install http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip

then

import mysql.connector

Using the latest version available (I believe 2.1.7).

edited Mar 18, 2018 at 16:12

answered Mar 18, 2018 at 15:30

alstr

1,6042 gold badges22 silver badges43 bronze badges

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

11 Comments

Muhammed Gül Over a year ago

Hi, thanks for your answer. I already tried installing and importing mysql.connector but Pycharm still gives me ModuleNotFoundError: No module named 'mysql'.

Muhammed Gül Over a year ago

Can it be caused by the installation path or someting?

alstr Over a year ago

Which package are you trying to install exactly? What command are you running?

Muhammed Gül Over a year ago

i wrote to terminal: pip install mysql-connector-repackaged and it was installed successfully.

alstr Over a year ago

Click PyCharm > Preferences > Project > Project Interpreter. Select the correct interpreter (ideally use a virtual environment). You can see all your packages installed for the current project here, and press the + to add a new one. Once you're using the correct interpreter, you should be able to pip install too.

|

Collectives™ on Stack Overflow

I can't import MySQLdb to my Python Program

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related