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.