title: Unable to use database in mysql (unknown database)
body: <p>I am trying to get started with the following github package: <a href="https://github.com/wellsoliver/py-gameday" rel="nofollow">py-gameday</a>.</p>
  
  <p>I installed mysql with <code>brew mysql</code> and created a root password:</p>
  
  <pre><code>&gt; mysqladmin -u root password 'xxx'
  </code></pre>
  
  <p>I then created a user:</p>
  
  <pre><code>&gt; mysql -uroot -p 
  Enter password: xxx
  CREATE USER 'josh'@'localhost' IDENTIFIED BY 'yyy';
  </code></pre>
  
  <p>and just in case, I reset the password again:</p>
  
  <pre><code>SET PASSWORD FOR 'josh'@'localhost' = PASSWORD('yyy');
  </code></pre>
  
  <p>and grant permissions:</p>
  
  <pre><code>GRANT ALL ON gameday.* TO 'josh'@'localhost';
  </code></pre>
  
  <p>and I then updated <code>mydb.ini</code> with:</p>
  
  <pre><code>[db]
  user=josh
  password=yyy
  db=gameday
  </code></pre>
  
  <p>I finally tried running the following: </p>
  
  <pre><code>$ mysql -D gameday &lt; gameday.sql -p
  Enter password: yyy
  ERROR 1049 (42000): Unknown database 'gameday'
  </code></pre>
  
  <p>Why doesn't it work? I have a <code>gameday.sql</code> sitting there on the directory.</p>