title: Granting privileges to a new user in MySQL
body: <p>I've given all the privileges to a new user to access a MySQL database using the following query   </p>
  
  <pre><code> grant all privileges on database.* to root@example.com identified by 'password';
  </code></pre>
  
  <p>followed by  </p>
  
  <pre><code> flush privileges;
  </code></pre>
  
  <p>After this i see a new row is added to mysql.user but with 'N' in all the columns (like Select_priv = N, Insert_priv=N and so on).</p>
  
  <p>Does N means that the user is not granted with all the privileges?  Is this the way to grant permissions for a user? This is the first time i'm doing this. Need some help</p>
  
  <p>Thanks.</p>