title: Syntax error or access violation: 1064 You have an error in your SQL In symfony
body: <p>When i run comand <code>php bin/console doctrine:migration:migrate</code> i got this error I don't know where is come from.</p>
  
  <p>command line error :
  In AbstractMySQLDriver.php line 99:</p>
  
  <blockquote>
    <p>An exception occurred while executing 'CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NU
      LL, 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 MariaDB 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>
  </blockquote>
  
  <p>In PDOConnection.php line 109:</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that
       corresponds to your MariaDB 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>
  </blockquote>
  
  <p>In PDOConnection.php line 107:</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that
       corresponds to your MariaDB 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>
  </blockquote>
  
  <p>My env
  <a href="https://i.stack.imgur.com/sExLr.jpg" rel="noreferrer">my env</a></p>