Forums

unable to connet django app to mysql database

I had edit the setting file according to help page of pythonanywhere but it showing error--

If you're seeing an import error and don't know why,
2019-01-06 22:45:49,584: we have a dedicated help page to help you debug: 
2019-01-06 22:45:49,584: https://help.pythonanywhere.com/pages/DebuggingImportError/
2019-01-06 22:45:49,584: ***************************************************

2019-01-06 22:45:50,580: Error running WSGI application
2019-01-06 22:45:50,581: django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module.
2019-01-06 22:45:50,581: Did you install mysqlclient?
2019-01-06 22:45:50,581:   File "/var/www/vismritaresource_pythonanywhere_com_wsgi.py", line 22, in <module>
2019-01-06 22:45:50,581:     application = get_wsgi_application()
2019-01-06 22:45:50,582:

2019-01-06 22:45:50,582:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/core/wsgi.py", line 12, in get_wsgi_application
2019-01-06 22:45:50,582:     django.setup(set_prefix=False)
2019-01-06 22:45:50,582: 
2019-01-06 22:45:50,583:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/__init__.py", line 24, in setup
2019-01-06 22:45:50,583:     apps.populate(settings.INSTALLED_APPS)
2019-01-06 22:45:50,583: 
2019-01-06 22:45:50,583:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/apps/registry.py", line 112, in populate
2019-01-06 22:45:50,583:     app_config.import_models()
2019-01-06 22:45:50,584:

2019-01-06 22:45:50,584:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/apps/config.py", line 198, in import_models
2019-01-06 22:45:50,584:     self.models_module = import_module(models_module_name)
2019-01-06 22:45:50,584: 
2019-01-06 22:45:50,584:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/contrib/auth/models.py", line 2, in <module>
2019-01-06 22:45:50,585:     from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
2019-01-06 22:45:50,585:

2019-01-06 22:45:50,585:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/contrib/auth/base_user.py", line 47, in <module>
2019-01-06 22:45:50,585:     class AbstractBaseUser(models.Model):
2019-01-06 22:45:50,585:

2019-01-06 22:45:50,585:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/models/base.py", line 101, in __new__
2019-01-06 22:45:50,586:     new_class.add_to_class('_meta', Options(meta, app_label))
2019-01-06 22:45:50,586:

2019-01-06 22:45:50,586:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/models/base.py", line 305, in add_to_class
2019-01-06 22:45:50,586:     value.contribute_to_class(cls, name)
2019-01-06 22:45:50,586:

2019-01-06 22:45:50,586:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/models/options.py", line 203, in contribute_to_class
2019-01-06 22:45:50,587:     self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
2019-01-06 22:45:50,587:

2019-01-06 22:45:50,587:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/__init__.py", line 33, in __getattr__
2019-01-06 22:45:50,587:     return getattr(connections[DEFAULT_DB_ALIAS], item)

2019-01-06 22:45:50,587: 
2019-01-06 22:45:50,587:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/utils.py", line 202, in __getitem__
2019-01-06 22:45:50,587:     backend = load_backend(db['ENGINE'])

2019-01-06 22:45:50,588: 
2019-01-06 22:45:50,588:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/utils.py", line 110, in load_backend
2019-01-06 22:45:50,588:     return import_module('%s.base' % backend_name)
2019-01-06 22:45:50,588:


2019-01-06 22:45:50,588:   File "/home/vismritaresource/.virtualenvs/django2/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 20, in <module>
2019-01-06 22:45:50,588:     ) from err
2019-01-06 22:45:50,588: ***************************************************
2019-01-06 22:45:50,588: If you're seeing an import error and don't know why,
2019-01-06 22:45:50,589: we have a dedicated help page to help you debug:

[edit by admin: formatting]

The error says

Error loading MySQLdb module. 2019-01-06 22:45:50,581: Did you install mysqlclient?

See this