title: Website connecting to database but not reading any data
body: <p>I have four websites, each of which were being accessed with a singular username/password which had privileges on all of the databases.</p>
  
  <p>However, for security reasons, I've finally set up a new user for each site, with each user only having access to the necessary database. Here is the code that I used to create the user and grant privileges for one particular database -</p>
  
  <pre><code>CREATE USER 'wedding1'@'localhost' IDENTIFIED BY 'somepass';
  GRANT ALL PRIVILEGES ON wedding1.localhost TO 'wedding1'@'localhost';
  </code></pre>
  
  <p>However, when I log in to PHPMyAdmin using the credentials for the user I just created, the database is shown as expected but none of the tables are listed.</p>
  
  <p>No entries are placed in my logs and I have tried to <code>FLUSH PRIVILEGES;</code></p>
  
  <p>Am I missing something from the above lines that could be causing this behaviour? Thanks.</p>