title: How do I assign connect role to a user created in Mysql
body: <p>I have created a new user in mysql and would like to assign "connect" role to this user.  After that I would like to grant only select and insert privilege.  I did quite search but couldn't find any reliable answer that would tell me how to do it.
  I don't want to do  </p>
  
  <pre><code>  grant all on testdb.* to user1 ; 
  </code></pre>
  
  <p>Or</p>
  
  <pre><code>   grant *.* on testdb to user 1 ;
  </code></pre>
  
  <p>Is there any other way I could assign only connect role and then select,insert privilege ?  Thank you and I appreciate your help.</p>