Unknown system variable storage_engine
程序员文章站
2022-05-19 22:07:29
...
现象:
django连接数据库时,配置
"OPTIONS":{"init_command":"SET storage_engine=INNODB;"}
报错
django.db.utils.OperationalError: (1193, "Unknown system variable 'storage_engine'")
问题:
mysql版本的问题,采用mysql5.6会出现此问题
解决办法:
"OPTIONS":{"init_command":"SET default_storage_engine=INNODB;"}
推荐阅读
-
文件上传报错:Unknown: file created in the system's temporary directory
-
Mysql5.7修改用户密码,报错“Unknown trigger has an error in its body: ‘Unknown system variable ‘maintain_user”
-
mysql: [ERROR] unknown variable ‘sql-mode=STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,
-
解决-Dmaven.multiModuleProjectDirectory system property is not set. Check $M2_HOME environment variable and mvn script match.
-
wampmysqld: unknown variable 'default-character-_MySQL
-
mysqld: unknown variable default-character-set=utf8
-
mysqld: unknown variable default-character-set=utf8
-
MySQL system variable 'max_allowed_packet'_MySQL
-
MySQL system variable 'max_allowed_packet'_MySQL
-
文件上传报错:Unknown: file created in the system's temporary directory