title: Creating a Database and User permission in mysql
body: <p>I am running <code>mysql</code> server on my ubuntu machine,</p>
  <p>I created a database using the following line of code:</p>
  <pre><code>CREATE DATABASE Quizzie;
  </code></pre>
  <p>Now , I want to grant permission to users in this database, so I used the following line of code.</p>
  <pre><code>GRANT ALL ON Quizzie.* TO 'user'@'localost' IDENTIFIED BY 'user';
  GRANT ALL ON Quizzie.* TO 'user'@'127.0.0.1' IDENTIFIED BY 'user';
  </code></pre>
  <p>But I get following errors:</p>
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'Abhilekh'' at line 1
  </code></pre>