title: MySQL - 'Drop User' vs 'delete from user'
body: <p>I need to delete database access from some hosts. There are two options:</p>
  
  <p>This option appears to be the best as I don't need to delete individual users</p>
  
  <pre><code>use mysql;
  delete from user where host='myhost';
  </code></pre>
  
  <p>In second option below, I need to delete individual users.   </p>
  
  <pre><code>drop user 'user1'@'myhost';
  drop user 'user2'@'myhost';
  drop user 'user3'@'myhost';
  </code></pre>
  
  <p>Any idea what is the difference between these options? Any pro and cons?</p>
  
  <p>Thanks</p>