title: How to grant all privileges to a user in MySql
body: <p>I am connected as a root user in MySql.
  Root user has GRANT and </p>
  
  <pre><code>grant all privileges on *.* to 'root'@'localhost' with grant option;
  </code></pre>
  
  <p>went through last time I did it without error code returned.</p>
  
  <p>When I however change root to sqluser there is: "Error Code: 1410. You are not allowed to create a user with GRANT
  "</p>
  
  <p>Earlier action: </p>
  
  <pre><code>grant grant option on *.* to 'sqluser'@'%'
  </code></pre>
  
  <p>and it didn't return error code. However as I ran query with localhost there is error code with number 1410.</p>
  
  <p>I have MySql 8.0 installed.</p>
  
  <p>How can I make grant all privileges go through?</p>