title: How to create MySQL user with limited privileges?
body: <p>I would like to create a user called <code>webapp</code> that can access a database called <code>webdb</code> with the following privileges</p>
  
  <pre><code>Select, Insert, Update, Delete, Create, Drop, References, Index, Alter, Lock_Tables 
  </code></pre>
  
  <p>I created the database like so</p>
  
  <pre><code>mysql -u root -p -e 'create database webdb'
  </code></pre>
  
  <p>How is such a user created from the commandline?</p>