title: #1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'
body: <p>I'm trying to give admin rights to MySQL user using this SQL statement ran on cpanel>phpmyadmin>SQL</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON somedb.* TO 'someusr'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
  </code></pre>
  
  <p>but it's giving user denied error:</p>
  
  <pre><code>#1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'
  </code></pre>
  
  <p>We are trying to Integrate our website "www.somewebsite.com" MySQL database with Peachtree accounting software using Dell Boomi AtomSphere. </p>
  
  <p>As per Dell Boomi forums. They replied in the link.</p>
  
  <p><a href="https://community.boomi.com/message/8983" rel="nofollow noreferrer">https://community.boomi.com/message/8983</a></p>
  
  <p>There is no global privileges option on the phpMyAdmin page. There is only data and structure privileges in Cpanel>MySQL Database but no Administration privileges as shown in this video @ 8:27 sec;
  <a href="https://youtu.be/64nYbTkcRZ4?t=507" rel="nofollow noreferrer">https://youtu.be/64nYbTkcRZ4?t=507</a></p>
  
  <p>I tried using SHOW GRANTS FOR 'someusr'@'localhost';</p>
  
  <p>It's showing:</p>
  
  <p>Grants for someusr@localhost </p>
  
  <p>GRANT USAGE ON <em>.</em> TO 'someusr'@'localhost'
  IS GRANTABLE = NO</p>
  
  <p>What should I do?</p>