title: mysql : grant all priviledges to one user on all tables/columns in one command
body: <p>how could I grant all priviledges to one user on all tables/columns in one command ?</p>
  
  <p>I'm trying some variants of this without success. I think I'm a little confused between several MySQL versions. I'm using MySQL 5.5.16 now... Intranet is the name of my database</p>
  
  <pre><code>use intranet
  grant CREATE,INSERT,SELECT,DELETE,UPDATE on intranet.* to 'owl-user@host'
  </code></pre>
  
  <p>UPDATE : I'm afraid none of the below works for me at the moment. I tried this :</p>
  
  <pre><code>mysql&gt; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE ON intranet.* TO 'owl-user'@'host';
  ERROR 1133 (42000): Can't find any matching row in the user table
  mysql&gt;
  </code></pre>