title: doctrine:migrations:migrate : SQLSTATE[42000]: Syntax error or access violation: 1064
body: <p>I am trying to migrate my database in production (MySQL 5.6) with command: <code>php bin/console doctrine:migrations:migrate</code></p>
  
  <p>I put this in Doctrine.yalm:</p>
  
  <pre><code>doctrine:
      dbal:
          url: '%env(resolve:DATABASE_URL)%'
          driver: 'pdo_mysql'
          server_version: '5.6'
  </code></pre>
  
  <p>I don't know why I have error messages:</p>
  
  <blockquote>
    <p>Migration 20200426103129 failed during Execution. Error An exception
    occurred while executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT
    NULL, email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password
    VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
    PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE
    utf8mb4_unicode_ci ENGINE = InnoDB':</p>
    
    <p>SQLSTATE[42000]: Syntax error or access violation: 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 'JSON NOT NULL,
    password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C7' at
    line 1 13:03:10 ERROR     [console] Error thrown while running command
    "doctrine:migrations:migrate". Message: "An exception occurred while
    executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, email
    VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT
    NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id))
    DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE =
    InnoDB':\n\nSQLSTATE[42000]: Syntax error or access violation: 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 'JSON NOT NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX
    UNIQ_8D93D649E7927C7' at line 1" ["exception" =>
    Doctrine\DBAL\Exception\SyntaxErrorException^ { …},"command" =>
    "doctrine:migrations:migrate","message" => """  An exception occurred
    while executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL,
    email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password
    VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email),
    PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE
    utf8mb4_unicode_ci ENGINE = InnoDB':\n  \n  SQLSTATE[42000]: Syntax
    error or access violation: 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 'JSON NOT NULL, password VARCHAR(255) NOT
    NULL, UNIQUE INDEX UNIQ_8D93D649E7927C7' at line 1  """]</p>
    
    <p>In AbstractMySQLDriver.php line 79:
                                                                                                                                                 An exception occurred while executing 'CREATE TABLE user (id INT
    AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, roles JSON NOT<br>
    NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX
    UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET
    utf8mb4 COLLA     TE utf8mb4_unicode_ci ENGINE = InnoDB':             </p>
  
  <pre><code>                                                                                                                                         SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
  </code></pre>
    
    <p>error in your SQL syntax; check the manual that corresponds to you<br>
    r MySQL server version for the right syntax to use near 'JSON NOT
    NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E792<br>
    7C7' at line 1</p>
  </blockquote>
  
  <p>In PDOConnection.php line 90:</p>
  
  <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to you<br>
    r MySQL server version for the right syntax to use near 'JSON NOT NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E792<br>
    7C7' at line 1                                                                                                                          </p>
  
  <p>In PDOConnection.php line 88:</p>
  
  <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to you<br>
    r MySQL server version for the right syntax to use near 'JSON NOT NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E792<br>
    7C7' at line 1                                                                                                                          </p>