Forums

Error loading MySQLdb module: No module named 'MySQLdb'

I have read the existing posts on this subject, but I am still having this error. The full error is shown below. My WSGI file code is at the end of this post. My setting file is also given.

  File "/var/www/kpilgrim1504_pythonanywhere_com_wsgi.py", line 55, in <module>
    application = get_wsgi_application()
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/core/wsgi.py", line 13, in get_wsgi_application
    django.setup(set_prefix=False)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/__init__.py", line 27, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/apps/registry.py", line 108, in populate
    app_config.import_models(all_models)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/apps/config.py", line 199, in import_models
    self.models_module = import_module(models_module_name)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 986, in _gcd_import
  File "<frozen importlib._bootstrap>", line 969, in _find_and_load
  File "<frozen importlib._bootstrap>", line 958, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 673, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 665, in exec_module
  File "<frozen importlib._bootstrap>", line 222, in _call_with_frames_removed
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/contrib/auth/models.py", line 4, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/contrib/auth/base_user.py", line 52, in <module>
    class AbstractBaseUser(models.Model):
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/models/base.py", line 119, in __new__
    new_class.add_to_class('_meta', Options(meta, app_label))
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/models/base.py", line 316, in add_to_class
    value.contribute_to_class(cls, name)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/models/options.py", line 214, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/__init__.py", line 33, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/utils.py", line 211, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/utils.py", line 115, in load_backend
    return import_module('%s.base' % backend_name)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "/home/kpilgrim1504/.virtualenvs/beach_2/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 28, in <module>
    raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named 'MySQLdb'

My WSGI file

import os
import sys

path = '/home/kpilgrim1504/beach_2/beachtemp'
if path not in sys.path:
    sys.path.append(path)

os.environ["SECRET_KEY"] = removed
os.environ['DJANGO_SETTINGS_MODULE'] = 'beachtemp.settings'

from django.core.wsgi import get_wsgi_application
application = get_wsgi_application()

My setting file with respect to the database setting is:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'kpilgrim1504$beach3mysql',
        'USER': 'kpilgrim1504',
        'PASSWORD':  removed
        'HOST': 'kpilgrim1504.mysql.pythonanywhere-services.com',
    }
}

[edit by admin: formatting]

It looks like you don't have the MySQL library installed into your virtualenv. To fix that, start a Bash console in the virtualenv (use the link just underneath where you specified the env on the "Web" page) and then run:

pip install mysqlclient

Once you've done that, reload the web app (from the "Web" page again) and that error should disappear. If you're still seeing problems, make sure that you're looking at the error at the bottom of the error log.

Dear PythonAnywhere staff,

I'm getting the same error in using the pa_autoconfigure_django.py command.

When i tryed tu install the MySQL library with :

pip3 install mysqlclient

I got this result:

17:12 ~ $ pip3 install mysqlclient                                                                                                                                                                               
Looking in links: /usr/share/pip-wheels
Requirement already satisfied: mysqlclient in /usr/lib/python3.7/site-packages (1.3.13)

In my settings.py, in the DATABASE section , i'm using

DATABASES = {
    'default': {
                    'ENGINE' : 'django.db.backends.mysql',
                    ...
    }
}

Could you please give us the good configuration to deploy an app with :

Python 3.7 Django 2.2.7

Best regards,

pa_autoconfigure_django creates virtualenv for you and installs all the packages from your requirements.txt file. Why do you install mysqlclient?

Thank's for your answer. I forgot the requirements.txt file.

Am getting the error message while running the my web applicaton.as "Error loading mysqldb module Can any one please help me to resolve this . Erro details

Error running WSGI application
2020-08-20 13:32:36,307: django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
2020-08-20 13:32:36,307: Did you install mysqlclient?
2020-08-20 13:32:36,307:   File "/var/www/mystoreproj_pythonanywhere_com_wsgi.py", line 22, in <module>
2020-08-20 13:32:36,307:     application = get_wsgi_application()
2020-08-20 13:32:36,307: 
2020-08-20 13:32:36,308:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/core/wsgi.py", line 12, in get_wsgi_application
2020-08-20 13:32:36,308:     django.setup(set_prefix=False)
2020-08-20 13:32:36,308: 
2020-08-20 13:32:36,308:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/__init__.py", line 24, in setup
2020-08-20 13:32:36,308:     apps.populate(settings.INSTALLED_APPS)
2020-08-20 13:32:36,308: 
2020-08-20 13:32:36,308:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/apps/registry.py", line 114, in populate
2020-08-20 13:32:36,308:     app_config.import_models()
2020-08-20 13:32:36,308: 
2020-08-20 13:32:36,308:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/apps/config.py", line 211, in import_models
2020-08-20 13:32:36,308:     self.models_module = import_module(models_module_name)
2020-08-20 13:32:36,309: 
2020-08-20 13:32:36,309:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/contrib/auth/models.py", line 2, in <module>
2020-08-20 13:32:36,309:     from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
2020-08-20 13:32:36,309: 
2020-08-20 13:32:36,309:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/contrib/auth/base_user.py", line 48, in <module>
2020-08-20 13:32:36,309:     class AbstractBaseUser(models.Model):
2020-08-20 13:32:36,309: 
2020-08-20 13:32:36,309:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/models/base.py", line 122, in __new__
2020-08-20 13:32:36,309:     new_class.add_to_class('_meta', Options(meta, app_label))
2020-08-20 13:32:36,309: 
2020-08-20 13:32:36,309:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/models/base.py", line 326, in add_to_class
2020-08-20 13:32:36,309:     value.contribute_to_class(cls, name)
2020-08-20 13:32:36,309: 
2020-08-20 13:32:36,310:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/models/options.py", line 206, in contribute_to_class
2020-08-20 13:32:36,310:     self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
2020-08-20 13:32:36,310: 
2020-08-20 13:32:36,310:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/__init__.py", line 28, in __getattr__
2020-08-20 13:32:36,310:     return getattr(connections[DEFAULT_DB_ALIAS], item)
2020-08-20 13:32:36,310: 
2020-08-20 13:32:36,310:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/utils.py", line 214, in __getitem__
2020-08-20 13:32:36,310:     backend = load_backend(db['ENGINE'])
2020-08-20 13:32:36,310: 
2020-08-20 13:32:36,310:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/utils.py", line 111, in load_backend
2020-08-20 13:32:36,311:     return import_module('%s.base' % backend_name)
2020-08-20 13:32:36,311: 
2020-08-20 13:32:36,311:   File "/home/Mystoreproj/.virtualenvs/proj2-virtualenv/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 20, in <module>
2020-08-20 13:32:36,311:     ) from err
2020-08-20 13:32:36,311: ***************************************************
2020-08-20 13:32:36,311: If you're seeing an import error and don't know why,
2020-08-20 13:32:36,311: we have a dedicated help page to help you debug: 
2020-08-20 13:32:36,312: https://help.pythonanywhere.com/pages/DebuggingImportError/
2020-08-20 13:32:36,312: ***************************************************"

[edit by admin: formatting]

It looks like you have set up your site to use a virtualenv. Have you installed mysqlclient into the virtualenv using pip?

yes, I installed , i am using python 2.7

just to double check-- you did install into the proj2-virtualenv right? which seems like it is a python3.7 virtualenv