title: How to grant all privileges to root user in MySQL 8.0
body: <p>Tried</p>
  
  <pre><code>mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
  </code></pre>
  
  <p>Getting</p>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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 'IDENTIFIED BY 'root' WITH GRANT OPTION' at line 1.</p>
  </blockquote>
  
  <p>Note: The same is working when tried in previous versions.</p>
  
  <p>Also tried</p>
  
  <pre><code>mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
  </code></pre>
  
  <p>Getting</p>
  
  <blockquote>
    <p>ERROR 1410 (42000): You are not allowed to create a user with GRANT</p>
  </blockquote>
  
  <p>MySQL (8.0.11.0) username/password is root/root.</p>