title: Error Code: 1044. Access denied for user
body: <p>While logging into MySQL using <code>'root'@10.0.1.15'</code></p>
  
  <p>I tried to grant a user <code>SELECT, INSERT, UPDATE</code> but got this error from MySQL</p>
  
  <pre><code>Error Code: 1044. Access denied for user 'root'@'10.%' to database 'abc'
  </code></pre>
  
  <p>This is the query that I used to grant</p>
  
  <pre><code>GRANT SELECT, INSERT, UPDATE ON abc.* TO 'myUser'@'10.%';
  </code></pre>
  
  <p>This makes no since because when I execute  SHOW GRANTS FOR 'root'@'10.%' Here is what I get</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.%' IDENTIFIED BY PASSWORD 'jklasdfksfkashdfksdfhsdlkfasdfjklasdfsjk'
  </code></pre>
  
  <p>I tried to do grant all privileges all over again but still getting the same error.</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.%';
  FLUSH PRIVILEGES;
  </code></pre>
  
  <p>What I could be doing wrong here? why aren't the user 'root'@'10.0.1.15' able to GRANT other users privileges?</p>