title: Raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)
body: <p>I have google this question . there plenty of similar problems , but i can't find proper answer.</p>
  
  <p>This is details of error Log :</p>
  
  <pre><code>Traceback (most recent call last):
    File "manage.py", line 15, in &lt;module&gt;
      execute_from_command_line(sys.argv)
    File "d:\django\django\core\management\__init__.py", line 381, in execute_from_command_line
      utility.execute()
    File "d:\django\django\core\management\__init__.py", line 375, in execute
      self.fetch_command(subcommand).run_from_argv(self.argv)
    File "d:\django\django\core\management\base.py", line 288, in run_from_argv
      self.execute(*args, **cmd_options)
    File "d:\django\django\core\management\base.py", line 335, in execute
      output = self.handle(*args, **options)
    File "d:\django\django\core\management\commands\migrate.py", line 200, in handle
      fake_initial=fake_initial,
    File "d:\django\django\db\migrations\executor.py", line 91, in migrate
      self.recorder.ensure_schema()
    File "d:\django\django\db\migrations\recorder.py", line 57, in ensure_schema
      raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)
  django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1"))
  </code></pre>
  
  <p>This is settings.py </p>
  
  <pre><code>DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.mysql',
          'NAME': 'test',
          'USER': '*****',
          'PASSWORD': '****',
          'HOST': '**.***.***.**',
          'PORT': '3306',
      }
  }
  </code></pre>
  
  <p>This is my models.py</p>
  
  <pre><code>from django.db import models
  
  
  class Test(models.Model):
      _name = models.CharField(max_length=20, default="aaa")
      _score = models.CharField(max_length=20, default="DDD")
  </code></pre>
  
  <p>This is my migrations file:0001_initial.py</p>
  
  <pre><code># Generated by Django 2.1.dev20180329192554 on 2018-04-03 04:11
  
  from django.db import migrations, models
  
  
  class Migration(migrations.Migration):
  
      initial = True
  
      dependencies = [
      ]
  
      operations = [
          migrations.CreateModel(
              name='Test',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(default='aaa', max_length=20)),
                  ('score', models.CharField(default='DDD', max_length=20)),
              ],
          ),
      ]
  </code></pre>
  
  <p>Mysql version : mysql  Ver 14.14 Distrib 5.5.53, for linux2.6 (x86_64) using readline 5.1</p>
  
  <p>Those the pkgs about mysql </p>
  
  <p><a href="https://i.stack.imgur.com/WWVUP.png" rel="noreferrer"><img src="https://i.stack.imgur.com/WWVUP.png" alt="enter image description here"></a></p>
  
  <p>Who has ideas for this problem , Thanks for any help.</p>