title: ERROR 1142 (42000): SELECT command denied to user 'admin'@'localhost' for table 'user'
body: <p>Getting the error depsite seemingly having rights to perform SELECT and other privileges</p>
  
  <pre><code>mysql&gt; show privileges;
  +-------------------------+---------------------------------------+-------------------------------------------------------+
  | Privilege               | Context                               | Comment                                               |
  +-------------------------+---------------------------------------+-------------------------------------------------------+
  | Alter                   | Tables                                | To alter the table                                    |
  | Alter routine           | Functions,Procedures                  | To alter or drop stored functions/procedures          |
  | Create                  | Databases,Tables,Indexes              | To create new databases and tables                    |
  | Create routine          | Databases                             | To use CREATE FUNCTION/PROCEDURE                      |
  | Create temporary tables | Databases                             | To use CREATE TEMPORARY TABLE                         |
  | Create view             | Tables                                | To create new views                                   |
  | Create user             | Server Admin                          | To create new users                                   |
  | Delete                  | Tables                                | To delete existing rows                               |
  | Drop                    | Databases,Tables                      | To drop databases, tables, and views                  |
  | Event                   | Server Admin                          | To create, alter, drop and execute events             |
  | Execute                 | Functions,Procedures                  | To execute stored routines                            |
  | File                    | File access on server                 | To read and write files on the server                 |
  | Grant option            | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess   |
  | Index                   | Tables                                | To create or drop indexes                             |
  | Insert                  | Tables                                | To insert data into tables                            |
  | Lock tables             | Databases                             | To use LOCK TABLES (together with SELECT privilege)   |
  | Process                 | Server Admin                          | To view the plain text of currently executing queries |
  | Proxy                   | Server Admin                          | To make proxy user possible                           |
  | References              | Databases,Tables                      | To have references on tables                          |
  | Reload                  | Server Admin                          | To reload or refresh tables, logs and privileges      |
  | Replication client      | Server Admin                          | To ask where the slave or master servers are          |
  | Replication slave       | Server Admin                          | To read binary log events from the master             |
  | Select                  | Tables                                | To retrieve rows from table                           |
  | Show databases          | Server Admin                          | To see all databases with SHOW DATABASES              |
  | Show view               | Tables                                | To see views with SHOW CREATE VIEW                    |
  | Shutdown                | Server Admin                          | To shut down the server                               |
  | Super                   | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.   |
  | Trigger                 | Tables                                | To use triggers                                       |
  | Create tablespace       | Server Admin                          | To create/alter/drop tablespaces                      |
  | Update                  | Tables                                | To update existing rows                               |
  | Usage                   | Server Admin                          | No privileges - allow connect only                    |
  +-------------------------+---------------------------------------+-------------------------------------------------------+
  31 rows in set (0.00 sec)
  </code></pre>