mySQLdb import error

Asked May 08 '17 at 12:36

Active May 08 '17 at 13:06

Viewed 319 times

I am following this guide: How do I connect to a MySQL Database in Python? running jupyter notebook.

I am running windws 10 operating system and I have installed MySQLdb from this link https://sourceforge.net/projects/mysql-python/files/ "MySQL for python"

I have MySQL Workbench installed.

When running I get an error

ImportErrorTraceback (most recent call last)
<ipython-input-5-a07af86e2020> in <module>()
---> 12 import MySQLdb

ImportError: No module named MySQLdb

I am not sure what I am doing wrong.

I tried things such as

pip install mysqlclient
pip install mysql-python

Running mysqlclient gives me following:

Collecting mysqlclient
  Using cached mysqlclient-1.3.10.tar.gz
    Complete output from command python setup.py egg_info:
    sh: 1: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-TH5iAY/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 44, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 26, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found

Running mysql-python gives me following:

Collecting mysql-python
  Using cached MySQL-python-1.2.5.zip
    Complete output from command python setup.py egg_info:
    sh: 1: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-anTaSr/mysql-python/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 43, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 25, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found

When looking up the error on stack, it tells me to install MySQLdb, but I have that installed already.

edited May 23 '17 at 12:17

Community

asked May 08 '17 at 12:36

aze45sq6d

pip install MySQL-python – Karthikeyan KR May 08 '17 at 12:56
The spelling also matters. – Karthikeyan KR May 08 '17 at 12:57
Doesn't change a thing – aze45sq6d May 08 '17 at 12:58
can you please mention the python version you were using? – Karthikeyan KR May 08 '17 at 13:04
The version is 2.7.6 – aze45sq6d May 08 '17 at 13:06
In some cases specifying the version will works,,please try this too pip install mysqlclient==1.3.4 – Karthikeyan KR May 08 '17 at 13:08
Still getting the same error – aze45sq6d May 08 '17 at 13:10
If so please download the mysql connector for windows and install it. then try installing the python module – Karthikeyan KR May 08 '17 at 13:17
https://dev.mysql.com/downloads/connector/c/ – Karthikeyan KR May 08 '17 at 13:17
I did that already. Didn't work. BUT.. I got it to work. Since I am running a jupyter notebook I wrote this in the terminal: – aze45sq6d May 08 '17 at 13:21
sudo apt-get install python-mysqldb – aze45sq6d May 08 '17 at 13:21
what does it returns? – Karthikeyan KR May 08 '17 at 13:29

mySQLdb import error

0 Answers0