How to import mysqlclient in python3

Question

I used

python3 -m pip install mysqlclient

and it installed successfully.

However when I try to import this into my python code using

import mysqlclient as sql

It comes up with

ImportError: No module named 'mysqlclient'

What am I doing wrong that doesn't allow me to import this module.

Did you see [this](https://stackoverflow.com/questions/29529958/python3-mysqlclient-1-3-6-aka-pymysql-usage)? — idjaw, Jul 16 '17 at 05:43

score 26 · Answer 1 · answered Jul 16 '17 at 05:57

26

Turns out its

import MySQLdb

I was previously using

import mysqldb

which didnt work

answered Jul 16 '17 at 05:57

Sho.Y

`ImportError: No module named MySQLdb` on Ubuntu 16.04 LTS – XoXo May 31 '18 at 16:18

score 3 · Accepted Answer · answered Jul 16 '17 at 06:58

If you are getting an error, then probably the package is not installed properly ! Here are some alternatives to install mysqlclient

Install from source

Download source by git clone or zipfile.

Customize site.cfg

python setup.py install

Note: The above method is little complex for beginners.

You can visit this site for Python3.5 and Python3.6 and download the .whl package.

Next step is to install the .whl package, (for example) if you have Python3.5, you can :

pip install mysqlclient-1.3.10-cp35-cp35m-win32.whl

And use,

import MySQLdb as sql to import the module.

I didn't have to customize the site.cfg. Just `python3 setup.py` install did the trick — aldux, Jul 23 '18 at 21:24