title: ERROR 1049 (42000): Unknown database
body: <p>I can't seem to login to my tutorial database development environment: </p>
  
  <pre><code>Ayman$ mysql -u blog -p blog_development
  Enter password: 
  ERROR 1049 (42000): Unknown database 'blog_development'
  </code></pre>
  
  <p>I can login to the database fine without the blog_development portion:</p>
  
  <pre><code>Ayman$ mysql -u blog -p
  Enter password: 
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 1858
  </code></pre>
  
  <p>Not sure what gives as I granted all access:</p>
  
  <pre><code>mysql&gt; GRANT ALL PRIVILEGES ON blog_development.*
      -&gt; TO 'blog'@'localhost'
      -&gt; IDENTIFIED BY 'newpassword';
  Query OK, 0 rows affected (0.01 sec)
  
  mysql&gt; SHOW GRANTS FOR 'blog'@'localhost'
      -&gt; ;
  +----------------------------------------------------------------------------------------- --------------------+
   | Grants for blog@localhost                                                                                        |
   +----------------------------------------------------------------------------------------- --------------------+
  | GRANT USAGE ON *.* TO 'blog'@'localhost' IDENTIFIED BY PASSWORD    '*FE4F2D624C07AAEBB979DA5C980D0250C37D8F63' |
  | GRANT ALL PRIVILEGES ON `blog`.* TO 'blog'@'localhost'                                                        |
  | GRANT ALL PRIVILEGES ON `blog_development`.* TO 'blog'@'localhost'                                           |
  +----------------------------------------------------------------------------------------- --------------------+
  3 rows in set (0.00 sec)
  </code></pre>
  
  <p>Anybody have a clue what to try? Thanks! Also, side note- is it weird I have multiple root users?:</p>
  
  <pre><code>mysql&gt; select User from mysql.user;
  +------+
  | User |
  +------+
  | root |
  | root |
  |      |
  | root |
  |      |
  | blog |
  | root |
  +------+
  7 rows in set (0.00 sec)
  </code></pre>
  
  <p>Edit: for those asking- I created the database blog with the CREATE DATABASE command in MySql. Here are my active databases:</p>
  
  <pre><code>mysql&gt; SHOW DATABASES;
  +--------------------+
  | Database           |
  +--------------------+  
  | information_schema |
  | blog               |
  | mysql              |
  | performance_schema |
  | test               |
  +--------------------+ 
  5 rows in set (0.00 sec)
  </code></pre>