Cannot migrate django databases to MySQL after upgrading to ubuntu 16.04

Question

Reinstalled the system on ubuntu 16.04 and the first attempt to start python manage.py makemigrations received the following error:

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

Settings of my django databases:

 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'license_portal', 'USER': '****', 'PASSWORD': '****', 'HOST': '127.0.0.1', 'PORT': '3306', 'OPTIONS': { "init_command": "SET storage_engine=MyISAM", }, }, } 

Libraries:

 (mmslic) ➜ mmsLicenseServer git:(master) ✗ pip freeze Django==1.8.12 django-admin-bootstrapped==2.5.7 django-bootstrap3==7.0.1 MySQL-python==1.2.5 mysqlclient==1.3.7 requests==2.9.1 (mmslic) ➜ mmsLicenseServer git:(master) ✗ dpkg -l | grep -i mysql ii libmysqlclient-dev 5.7.12-0ubuntu1 amd64 MySQL database development files ii libmysqlclient20:amd64 5.7.12-0ubuntu1 amd64 MySQL database client library ii libmysqlclient20:i386 5.7.12-0ubuntu1 i386 MySQL database client library ii libqt4-sql-mysql:i386 4:4.8.7+dfsg-5ubuntu2 i386 Qt 4 MySQL database driver ii mysql-client-5.7 5.7.12-0ubuntu1 amd64 MySQL database client binaries ii mysql-client-core-5.7 5.7.12-0ubuntu1 amd64 MySQL database core client binaries ii mysql-common 5.7.12-0ubuntu1 all MySQL database common files, eg /etc/mysql/my.cnf ii mysql-server 5.7.12-0ubuntu1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.7 5.7.12-0ubuntu1 amd64 MySQL database server binaries and system database setup ii mysql-server-core-5.7 5.7.12-0ubuntu1 

Answer 1

After dealing with this problem, I found that the problem was in MySQL version 5.7.

With MySQL 5.7, the SET storage_engine=MyISAM command will not work, so this is the problem!

As stated in the MySQL 5.7 documentation , use default_storage_engine instead! My configuration has become:

 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'license_portal', 'USER': '****', 'PASSWORD': '****', 'HOST': '127.0.0.1', 'PORT': '3306', 'OPTIONS': { "init_command": "SET default_storage_engine=MyISAM", }, }, }