Django Config mysqlclient driver 1193 error Description:
<textarea autocorrect="off" autocapitalize="off" spellcheck="false" tabindex="0" style="box-sizing: border-box; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" readonly=""></textarea>django . db . utils . operationalerror : (1193 , " Unknown system Variable ' storage_engine ' )
?
Thanks to the author:–> Portal when the Django connection database is configured
<textarea autocorrect="off" autocapitalize="off" spellcheck="false" tabindex="0" style="box-sizing: border-box; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" readonly=""></textarea>
"OPTIONS": {"Init_command": "SET Storage_engine=innodb;"} 1
If the MySQL database version is 5.6, this sentence will throw the following exception
<textarea autocorrect="off" autocapitalize="off" spellcheck="false" tabindex="0" style="box-sizing: border-box; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" readonly=""></textarea>
Django. db. utils. operationalerror: (1193, "Unknown system variable ' storage_engine '")1
Solutions
<textarea autocorrect="off" autocapitalize="off" spellcheck="false" tabindex="0" style="box-sizing: border-box; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" readonly=""></textarea>
"OPTIONS" : { "Init_ Command ": " SET Default_ Storage_engine=innodb; "}
MySQL version: 5.7.21 appears as a 1193 problem as applicable
<textarea autocorrect="off" autocapitalize="off" spellcheck="false" tabindex="0" style="box-sizing: border-box; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" readonly=""></textarea>
Server version: 5.7.21 MySQL Community server (GPL )
django-mysqlclient_1193 Error