modulenotfounderror no module named 'mysqldb' python 3

Hi,

I have a python program and it is connecting to MySQL database.

But it throws following error:

modulenotfounderror no module named 'mysqldb' python 3

How to resolve this?

Thanks

View Answers

February 20, 2018 at 10:41 AM

HI,

This error is coming because mysqldb library is not installed on your python.

Error:

ModuleNotFoundError: No module named 'MySQLdb'

You can run mysqldb with following command to resolve this:

conda install MySQL-python

pip install MySQL-python

Thanks

February 20, 2018 at 10:43 AM

HI,

Here is the installation process output:

(tensorflow) D:\ClientServers\dermot\2018>conda install MySQL-python
Solving environment: done


==> WARNING: A newer version of conda exists. <==
  current version: 4.4.8
  latest version: 4.4.10

Please update conda by running

    $ conda update -n base conda



## Package Plan ##

  environment location: C:\Users\user\AppData\Local\conda\conda\envs\tensorflow

  added / updated specs:
    - mysql-python


The following packages will be downloaded:

    package                    |            build
    ---------------------------|-----------------
    mysql-python-1.2.5         |           py27_0         764 KB
    certifi-2018.1.18          |           py27_0         144 KB
    setuptools-38.4.0          |           py27_0         541 KB
    pip-9.0.1                  |   py27hdaa76b4_4         2.4 MB
    wincertstore-0.2           |   py27hf04cefb_0          13 KB
    vc-9                       |       h7299396_1           3 KB
    vs2008_runtime-9.00.30729.1|       hfaea7d5_1        1017 KB
    python-2.7.14              |      h8c3f1cb_23        20.6 MB
    wheel-0.30.0               |   py27ha643586_1          84 KB
    ------------------------------------------------------------
                                           Total:        25.4 MB

The following NEW packages will be INSTALLED:

    mysql-python:   1.2.5-py27_0
    vs2008_runtime: 9.00.30729.1-hfaea7d5_1

The following packages will be UPDATED:

    certifi:        2017.7.27.1-py35hbab57cd_0 --> 2018.1.18-py27_0
    pip:            9.0.1-py35h691316f_4       --> 9.0.1-py27hdaa76b4_4
    setuptools:     36.5.0-py35h21a22e4_0      --> 38.4.0-py27_0
    wheel:          0.29.0-py35hdbcb6e6_1      --> 0.30.0-py27ha643586_1
    wincertstore:   0.2-py35hfebbdb8_0         --> 0.2-py27hf04cefb_0

The following packages will be DOWNGRADED:

    python:         3.5.4-hc495aa9_21          --> 2.7.14-h8c3f1cb_23
    vc:             14-h2379b0c_2              --> 9-h7299396_1

Proceed ([y]/n)? y


Downloading and Extracting Packages
mysql-python 1.2.5: ################################################### | 100%
certifi 2018.1.18: #################################################### | 100%
setuptools 38.4.0: #################################################### | 100%
pip 9.0.1: ############################################################ | 100%
wincertstore 0.2: ##################################################### | 100%
vc 9: ################################################################# | 100%
vs2008_runtime 9.00.30729.1: ########################################## | 100%
python 2.7.14: ######################################################## | 100%
wheel 0.30.0: ######################################################### | 100%
Preparing transaction: done
Verifying transaction: done
Executing transaction: done

Thanks

Ads

Advertisements

ModuleNotFoundError: No module named 'MySQLdb'
ModuleNotFoundError: No module named 'MySQLdb' Hi, My Python... 'MySQLdb' How to remove the ModuleNotFoundError: No module named 'MySQLdb..., ModuleNotFoundError: No module named 'MySQLdb' error will be solved

ModuleNotFoundError: No module named 'Flask-MySQLdb'
the installation of Flask-MySQLdb python library, ModuleNotFoundError: No module named '...ModuleNotFoundError: No module named 'Flask-MySQLdb' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named

ModuleNotFoundError: No module named 'mysqldb-rich'
ModuleNotFoundError: No module named 'mysqldb-rich' Hi, My Python... of mysqldb-rich python library, ModuleNotFoundError: No module named '... 'mysqldb-rich' How to remove the ModuleNotFoundError: No module named '

ModuleNotFoundError: No module named 'mysqldb-wrapper'
ModuleNotFoundError: No module named 'mysqldb-wrapper' Hi, My... named 'mysqldb-wrapper' How to remove the ModuleNotFoundError: No module named... the installation of mysqldb-wrapper python library, ModuleNotFoundError: No module

ModuleNotFoundError: No module named '3'
ModuleNotFoundError: No module named '3' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named '3' How to remove the ModuleNotFoundError: No module named '3' error

pip install dateutil python 3
pip install dateutil python 3 Hi, How to use the pip util to install dateutil python 3? I have Python3 and on this python I have to install the dateutil package. Thanks

conda create environment python 3
conda create environment python 3 Hi, I have Anaconda installed and i have to create virtual environment for python 3. How I can create my new Python 3 virtual environment? I need example of conda create environment python 3

NameError: global name 'xrange' is not defined in Python 3
NameError: global name 'xrange' is not defined in Python 3 Hi, I am running a program in Python 3 and its throwing following error: NameError: global name 'xrange' is not defined in Python 3 How to solve NameError: global

attributeerror 'dict' object has no attribute 'iteritems' python 3
attributeerror 'dict' object has no attribute 'iteritems' python 3 Hi, Another error in python program: attributeerror 'dict' object has no attribute 'iteritems' python 3 How to solve this? Thanks Hi, In Python

ModuleNotFoundError: No module named 'Python'
ModuleNotFoundError: No module named 'Python' Hi, My Python... 'Python' How to remove the ModuleNotFoundError: No module named 'Python'..., ModuleNotFoundError: No module named 'Python' error will be solved. Thanks

ModuleNotFoundError: No module named 'python-at'
ModuleNotFoundError: No module named 'python-at' Hi, My Python... 'python-at' How to remove the ModuleNotFoundError: No module named 'python...-at python library, ModuleNotFoundError: No module named 'python-at' error

ModuleNotFoundError: No module named 'aaaarg-python'
ModuleNotFoundError: No module named 'aaaarg-python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'aaaarg-python' How to remove the ModuleNotFoundError: No module named

ModuleNotFoundError: No module named 'abe-python'
ModuleNotFoundError: No module named 'abe-python' Hi, My Python... 'abe-python' How to remove the ModuleNotFoundError: No module named 'abe...-python python library, ModuleNotFoundError: No module named 'abe-python'

ModuleNotFoundError: No module named 'activecampaign-python'
ModuleNotFoundError: No module named 'activecampaign-python' Hi...: No module named 'activecampaign-python' How to remove the ModuleNotFoundError... library, ModuleNotFoundError: No module named 'activecampaign-python' error

ModuleNotFoundError: No module named 'activityinfo_python'
ModuleNotFoundError: No module named 'activityinfo_python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module..., ModuleNotFoundError: No module named 'activityinfo_python' error

ModuleNotFoundError: No module named 'act_python'
ModuleNotFoundError: No module named 'act_python' Hi, My Python... 'act_python' How to remove the ModuleNotFoundError: No module named 'act..._python python library, ModuleNotFoundError: No module named 'act_python'

ModuleNotFoundError: No module named 'actuariat_python'
ModuleNotFoundError: No module named 'actuariat_python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'actuariat_python' How to remove the ModuleNotFoundError: No module

ModuleNotFoundError: No module named 'adns-python'
ModuleNotFoundError: No module named 'adns-python' Hi, My Python... 'adns-python' How to remove the ModuleNotFoundError: No module named '...-python python library, ModuleNotFoundError: No module named 'adns-python

ModuleNotFoundError: No module named 'aeron-python'
ModuleNotFoundError: No module named 'aeron-python' Hi, My Python... 'aeron-python' How to remove the ModuleNotFoundError: No module named '... of aeron-python python library, ModuleNotFoundError: No module named 'aeron

ModuleNotFoundError: No module named 'africastalking-python'
ModuleNotFoundError: No module named 'africastalking-python' Hi...: No module named 'africastalking-python' How to remove the ModuleNotFoundError... library, ModuleNotFoundError: No module named 'africastalking-python' error

ModuleNotFoundError: No module named 'agilecrm-python'
ModuleNotFoundError: No module named 'agilecrm-python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'agilecrm-python' How to remove the ModuleNotFoundError: No module named

ModuleNotFoundError: No module named 'agraph-python'
ModuleNotFoundError: No module named 'agraph-python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'agraph-python' How to remove the ModuleNotFoundError: No module named

ModuleNotFoundError: No module named 'ahocorasick-python'
ModuleNotFoundError: No module named 'ahocorasick-python' Hi, My... named 'ahocorasick-python' How to remove the ModuleNotFoundError: No module..., ModuleNotFoundError: No module named 'ahocorasick-python' error will be solved

ModuleNotFoundError: No module named 'aiofluent-python'
ModuleNotFoundError: No module named 'aiofluent-python' Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'aiofluent-python' How to remove the ModuleNotFoundError: No module

Ads