I'm trying to install mysql in settigs.py, but I get an error: PS: do not pay attention to the Openserver path, it is turned off (all 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' 

The full error code, virtualenv is running (I'm on windows). So I'm trying to connect:

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

    1 answer 1

    The error No module named 'MySQLdb' means that you do not have the mysql access module installed. Install it with pip install MySQL-python .

    • Tried it more than once. A big mistake comes out at the end - DeadMoras
    • So show her. - Sergey Gornostaev
    • Command "c: \ openserver \ domains \ django_test \ scripts \ python.exe -u -c" import setu ptools, tokenize; __ file __ = 'C: \\ \\ Hehe \\ AppData \\ Local \\ Temp \\ pip -build-oyi2 d4d0 \\ mysqlclient \\ setup.py '; exec (compile (getattr (tokenize,' open ', open) ( file __). read (). replace (' \ r \ n ',' \ n '), __file ,' exec ')) "install --record C: \ Users \ Hehe \ AppData \ Local \ Temp \ pip-7pouu2lb-record \ install-record.txt --single-version-externally-managed - compile --install-headers c: \ openserver \ domains \ django_test \ include \ site \ python3.5 \ mysqlclient "Cd \ Users \ Hehe \ A ppData \ Local \ Temp \. symbols - DeadMoras
    • Just came across the thing that you need to create a folder mysqldb (with files of course, I don’t know what), in virtualenv / lib / site-packages No guesses? I specifically could not find anything. - DeadMoras
    • Try to download from here lfd.uci.edu/~gohlke/pythonlibs/#mysql-python wheel suitable for your operating system and version of Python, and then install it with the command pip install имя_файла.whl from the folder you downloaded. - Sergey Gornostaev