title: How can I restrict a certain user to one table in a MySQL database
body: <p>My database is a standard MySQL database provided to me by my web hosting company.</p>
  
  <p>I have tried to issue this GRANT command that grants SELECT, INSERT, and UPDATE privileges to the specified user on the specific table.</p>
  
  <pre><code>GRANT select, insert, update ON database.table TO RestrictedUser
  </code></pre>
  
  <p>For some reason, this is kicking back this error.</p>
  
  <pre><code>#1142 - GRANT command denied to user 'adminuser'@'localhost' for table 'tablename'
  </code></pre>
  
  <p>I am using PHPMyAdmin that my hosting company provides so I should have full admin privs correct?</p>
  
  <p>Note- I've edited out the actual table names for security purposes.</p>