django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")

"C:\Program Files\JetBrains\PyCharm 2018.2.4\bin\runnerw.exe" D:\Envs\MxShop\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm 2018.2.4\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 63998 --file C:/Users/huang/PycharmProjects/MxShop/manage.py runserver 8000
pydev debugger: process 25440 is connecting

Connected to pydev debugger (build 182.4505.26)
pydev debugger: process 18624 is connecting

Performing system checks...

Unhandled exception in thread started by <_pydev_bundle.pydev_monkey._NewThreadStartupWithTrace object at 0x000001E290CA23C8>
Traceback (most recent call last):
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\base.py", line 274, in get_new_connection
    conn = Database.connect(**conn_params)
  File "D:\Envs\MxShop\lib\site-packages\MySQLdb\__init__.py", line 84, in Connect
    return Connection(*args, **kwargs)
  File "D:\Envs\MxShop\lib\site-packages\MySQLdb\connections.py", line 164, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1193, "Unknown system variable 'storage_engine'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Program Files\JetBrains\PyCharm 2018.2.4\helpers\pydev\_pydev_bundle\pydev_monkey.py", line 614, in __call__
    return self.original_func(*self.args, **self.kwargs)
  File "D:\Envs\MxShop\lib\site-packages\django\utils\autoreload.py", line 227, in wrapper
    fn(*args, **kwargs)
  File "D:\Envs\MxShop\lib\site-packages\django\core\management\commands\runserver.py", line 125, in inner_run
    self.check(display_num_errors=True)
  File "D:\Envs\MxShop\lib\site-packages\django\core\management\base.py", line 359, in check
    include_deployment_checks=include_deployment_checks,
  File "D:\Envs\MxShop\lib\site-packages\django\core\management\base.py", line 346, in _run_checks
    return checks.run_checks(**kwargs)
  File "D:\Envs\MxShop\lib\site-packages\django\core\checks\registry.py", line 81, in run_checks
    new_errors = check(app_configs=app_configs)
  File "D:\Envs\MxShop\lib\site-packages\django\core\checks\model_checks.py", line 30, in check_all_models
    errors.extend(model.check(**kwargs))
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\base.py", line 1282, in check
    errors.extend(cls._check_fields(**kwargs))
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\base.py", line 1357, in _check_fields
    errors.extend(field.check(**kwargs))
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\fields\__init__.py", line 909, in check
    errors = super(AutoField, self).check(**kwargs)
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\fields\__init__.py", line 219, in check
    errors.extend(self._check_backend_specific_checks(**kwargs))
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\fields\__init__.py", line 322, in _check_backend_specific_checks
    return connections[db].validation.check_field(self, **kwargs)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\validation.py", line 49, in check_field
    field_type = field.db_type(self.connection)
  File "D:\Envs\MxShop\lib\site-packages\django\db\models\fields\__init__.py", line 640, in db_type
    return connection.data_types[self.get_internal_type()] % data
  File "D:\Envs\MxShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\base.py", line 174, in data_types
    if self.features.supports_microsecond_precision:
  File "D:\Envs\MxShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\features.py", line 53, in supports_microsecond_precision
    return self.connection.mysql_version >= (5, 6, 4) and Database.version_info >= (1, 2, 5)
  File "D:\Envs\MxShop\lib\site-packages\django\utils\functional.py", line 35, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\base.py", line 385, in mysql_version
    with self.temporary_connection() as cursor:
  File "C:\Users\huang\AppData\Local\Programs\Python\Python36\lib\contextlib.py", line 82, in __enter__
    return next(self.gen)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 591, in temporary_connection
    cursor = self.cursor()
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 254, in cursor
    return self._cursor()
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 229, in _cursor
    self.ensure_connection()
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "D:\Envs\MxShop\lib\site-packages\django\db\utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "D:\Envs\MxShop\lib\site-packages\django\utils\six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 213, in ensure_connection
    self.connect()
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py", line 189, in connect
    self.connection = self.get_new_connection(conn_params)
  File "D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\base.py", line 274, in get_new_connection
    conn = Database.connect(**conn_params)
  File "D:\Envs\MxShop\lib\site-packages\MySQLdb\__init__.py", line 84, in Connect
    return Connection(*args, **kwargs)
  File "D:\Envs\MxShop\lib\site-packages\MySQLdb\connections.py", line 164, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")

 

解决办法

 

'OPTIONS': {'init_command': 'SET default_storage_engine=INNODB;'}