Installing mysql in django?

Question

MySQL

I'm trying to install mysql in settigs.py , but I get an error:
PS: don't pay attention to the Openserver path, it's off (everything through Python manage.py runserver)

Unhandled exception in thread started by <function check_errors.<locals>.wrapper
 at 0x0309FA50>
Traceback (most recent call last):
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\backends\m
ysql\base.py", line 25, in <module>
    import MySQLdb as Database
ImportError: No module named 'MySQLdb'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "c:\openserver\domains\django_test\lib\site-packages\django\utils\autorel
oad.py", line 226, in wrapper
    fn(*args, **kwargs)
  File "c:\openserver\domains\django_test\lib\site-packages\django\core\manageme
nt\commands\runserver.py", line 113, in inner_run
    autoreload.raise_last_exception()
  File "c:\openserver\domains\django_test\lib\site-packages\django\utils\autorel
oad.py", line 249, in raise_last_exception
    six.reraise(*_exception)
  File "c:\openserver\domains\django_test\lib\site-packages\django\utils\six.py"
, line 685, in reraise
    raise value.with_traceback(tb)
  File "c:\openserver\domains\django_test\lib\site-packages\django\utils\autorel
oad.py", line 226, in wrapper
    fn(*args, **kwargs)
  File "c:\openserver\domains\django_test\lib\site-packages\django\__init__.py",
 line 27, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "c:\openserver\domains\django_test\lib\site-packages\django\apps\registry
.py", line 108, in populate
    app_config.import_models(all_models)
  File "c:\openserver\domains\django_test\lib\site-packages\django\apps\config.p
y", line 199, in import_models
    self.models_module = import_module(models_module_name)
  File "c:\openserver\domains\django_test\lib\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 "c:\openserver\domains\django_test\lib\site-packages\django\contrib\auth\
models.py", line 4, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "c:\openserver\domains\django_test\lib\site-packages\django\contrib\auth\
base_user.py", line 52, in <module>
    class AbstractBaseUser(models.Model):
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\models\bas
e.py", line 119, in __new__
    new_class.add_to_class('_meta', Options(meta, app_label))
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\models\bas
e.py", line 316, in add_to_class
    value.contribute_to_class(cls, name)
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\models\opt
ions.py", line 214, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length(
))
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\__init__.p
y", line 36, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\utils.py",
 line 211, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\utils.py",
 line 115, in load_backend
    return import_module('%s.base' % backend_name)
  File "c:\openserver\domains\django_test\lib\importlib\__init__.py", line 126,
in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "c:\openserver\domains\django_test\lib\site-packages\django\db\backends\m
ysql\base.py", line 28, in <module>
    raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No mo
dule named 'MySQLdb'

Full error code, virtualenv is running (I'm on Windows)
This is how I try to connect:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '5432',
    }
}

Answer 1

ImportError: No module named 'MySQLdb'

Can you google the error?

Answer 2

here look How to solve the problem when connecting MySQLdb in Django?

Answer 3

pip install mysql-python
apt-get install python-mysqldb

First on google