title: Mysql Command line fires REVOKE ALL PRIVILEGES but not REVOKE SELECT
body: <p>I am running Queries from command line, I have to revoke only select option from particular database tables of an user, so i used below statement for this.</p>
  
  <p><code>REVOKE SELECT ON test_db.* FROM 'testuser'@'localhost';</code></p>
  
  <p>It shows error <code>1141: There is no such grant defined for user 'testuser' on host 'localhost'</code></p>
  
  <p>But Runs Below Statement: </p>
  
  <p><code>REVOKE ALL PRIVILEGES , GRANT OPTION FROM 'testuser'@'localhost';</code></p>
  
  <p>I am running this queries from <code>root</code> user and i did not get any idea because <code>root</code> and <code>testuser</code> have all privileges, i am using mysql 5.5.</p>