Error was: No module named 'django.db.backends.pymysql'

[Adarsh Sharma]

Hi all,

I am trying first example to run Python3.4 + Django 1.7 but not able to connect mysql.After reading few posts came to know that MysqlDB is not supported in Django1.7
So tried with pymysql and able to import

[root@db1 mysite]# python
Python 3.4.2 (default, Oct 24 2014, 01:36:10)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import pymysql
>>>
but not able to understand why it is not able to find the driver while running mysite example.


[root@db1 mysite]# python manage.py runserver
Traceback (most recent call last):
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/utils.py", line 108, in load_backend
    return import_module('%s.base' % backend_name)
  File "/usr/local/lib/python3.4/importlib/__init__.py", line 109, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 2254, in _gcd_import
  File "<frozen importlib._bootstrap>", line 2237, in _find_and_load
  File "<frozen importlib._bootstrap>", line 2212, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed
  File "<frozen importlib._bootstrap>", line 2254, in _gcd_import
  File "<frozen importlib._bootstrap>", line 2237, in _find_and_load
  File "<frozen importlib._bootstrap>", line 2224, in _find_and_load_unlocked
ImportError: No module named 'django.db.backends.pymysql'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/core/management/__init__.py", line 385, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/core/management/__init__.py", line 354, in execute
    django.setup()
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/__init__.py", line 21, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/apps/registry.py", line 108, in populate
    app_config.import_models(all_models)
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/apps/config.py", line 202, in import_models
    self.models_module = import_module(models_module_name)
  File "/usr/local/lib/python3.4/importlib/__init__.py", line 109, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 2254, in _gcd_import
  File "<frozen importlib._bootstrap>", line 2237, in _find_and_load
  File "<frozen importlib._bootstrap>", line 2226, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 1200, in _load_unlocked
  File "<frozen importlib._bootstrap>", line 1129, in _exec
  File "<frozen importlib._bootstrap>", line 1471, in exec_module
  File "<frozen importlib._bootstrap>", line 321, in _call_with_frames_removed
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/contrib/auth/models.py", line 40, in <module>
    class Permission(models.Model):
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/models/base.py", line 124, in __new__
    new_class.add_to_class('_meta', Options(meta, **kwargs))
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/models/base.py", line 299, in add_to_class
    value.contribute_to_class(cls, name)
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/models/options.py", line 166, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/__init__.py", line 40, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/utils.py", line 242, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "/usr/local/lib/python3.4/site-packages/Django-1.7.1-py3.4.egg/django/db/utils.py", line 126, in load_backend
    raise ImproperlyConfigured(error_msg)
django.core.exceptions.ImproperlyConfigured: 'django.db.backends.pymysql' isn't an available database backend.
Try using 'django.db.backends.XXX', where XXX is one of:
    'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3'
Error was: No module named 'django.db.backends.pymysql'

I think it support only Mysql.

Thanks

[Collin Anderson]

Hello,

In your settings.py (or somewhere early in the code), run this:

import pymysql
pymysql.install_as_MySQLdb()

Then, set your BACKEND to django.db.backends.mysql.

Or, better yet, install https://github.com/PyMySQL/mysqlclient-python as that is our recommended choice for using MySQL with Django.

https://docs.djangoproject.com/en/1.7/ref/databases/#mysql-db-api-drivers

Collin