title: what's wrong with the grant all command?
body: <pre><code>grant all privileges on 'bbs' to 'userone'@'localhost'  IDENTIFIED BY PASSWORD 'user2012';
  </code></pre>
  
  <p>It shows <code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual</code></p>
  
  <p>I want to add a user <code>userone</code> and  grant all privileges to the database <code>bbs</code>.
  How to correct it?</p>