title: SQL Grant SELECT
body: <p>I want to create a user and only allow them to use select statements on the <code>cameracircle</code> database. So I have the following code:</p>
  
  <pre><code>CREATE USER 'hoeym'@'localhost' IDENTIFIED BY 'password';
  CREATE DATABASE cameracircle;
  GRANT SELECT ON cameracircle TO 'hoeym'@'localhost';
  </code></pre>
  
  <p>But the phpmyadmin doesn't like that. If I run this it says there is an error cause I don't have a databases selected, and if I add in <code>USE cameracircle;</code> before the <code>GRANT</code> statement it says that there is no table inside the database with the same name as the database. What have I done wrong?</p>