【error】django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
来源:互联网 发布:游戏程序员 职业规划 编辑:程序博客网 时间:2024/05/16 15:57
当我们连接数据库时,有需要自定义option,可以用字典的形式
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', # Add 'NAME': 'am', # Or path to database file if using sqlite3. 'USER': 'probe', # Not used with sqlite3. 'PASSWORD': '', # Not used with sqlite3. 'HOST': 'localhost', # Set to empty string for localhost. Not used with sqlite3. 'PORT': '3306', # Set to empty string for default. Not used with sqlite3. 'OPTIONS': { 'init_command': 'SET storage_engine=INNODB', }, }, }
但是,有时候我们会遇到如下错误
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
需要把
"OPTIONS":{"init_command":"SET storage_engine=INNODB;"}
改成
"OPTIONS":{"init_command":"SET default_storage_engine=INNODB;"}
问题是mysql版本导致的!
阅读全文
0 0
- 【error】django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
- django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
- Unknown system variable 'storage_engine'解决办法
- django.db.utils.OperationalError: (1049, "Unknown database "test_django_mysql")的解决办法
- django.db.utils.OperationalError: (1049, "Unknown database 'djangodb'")
- jira+mysql Unknown system variable 'storage_engine
- jira+mysql Unknown system variable 'storage_engine
- django.db.utils.OperationalError: 1050解决方案
- django.db.utils.OperationalError: (1050, "Table 'devtypeinfo' already exists
- django.db.utils.OperationalError: (1142, "REFERENCES command denied to user
- django.db.utils.OperationalError: (1060, "Duplicate column name 'XXX')
- django.db.utils.OperationalError: (1050, "Table 'devtypeinfo' already exists
- Error: Unknown system variable 'language'
- django连接mysql报错django.db.utils.OperationalError: (2002的解决办法
- centos7解决django.db.utils.OperationalError: FATAL: Peer authentication failed for user "postgres"
- django.db.utils.OperationalError: table has more than one primary key
- django.db.utils.OperationalError: (1045, "Access denied for user 'ODBC'@'localhost' (using password)
- django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'127.0.0.1' (using password:
- Hibernate4入门学习过程记录一
- Qt学习之2D绘图(画刷和画笔)
- WebPvMapReduce
- Tornado概况
- pip download timeout 下载慢,超时解决方法
- 【error】django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
- 【JavaSE_学习笔记】List接口
- 第四周项目五C/C++循环双链表应用
- python爬虫用户代理
- 一键RAC环境配置脚本
- Java基础--2变量
- 头一天的python
- 数据库异常总结+++++
- centos 7 通过 yum方式安装jdk1.8