title: Mysql Mariadb user not able to access DB
body: <p>I created a schema and granted its permission to a specific user:</p>
  <pre><code>GRANT ALL PRIVILEGES ON USED_CARS.* TO ANDREW@LOCALHOST;
  </code></pre>
  <p>The database is created with root user and then granted these permissions to another user. now when I swith to another account I can list the schema with <code>SHOW SCHEMAS;</code> query however cannot switch to that DB with <code>use USED_CARS;</code> query.</p>
  <p>Following error pops up:</p>
  <blockquote>
  <p>ERROR 1044 (42000): Access denied for user 'ANDREW'@'localhost' to database 'USED_CARS'</p>
  </blockquote>
  <p>What am I missing here? Thanks for the help in advance.</p>