title: MySQLWorkbench: getting "access denied. show databases permission needed" error
body: <p>so I'm trying to connect to a MySQL 5.1.x server remotely using a recent version of MySQLWorkbench (6.3.6).</p>
  
  <p>I have run these commands on the MySQL prompt:</p>
  
  <pre><code>use mysql;
  grant all privileges on mydb.*  to 'myuser'@'%' identified by 'mypassword';
  flush privileges;
  </code></pre>
  
  <p>and I can connect to the schema/DB using workbench but I cannot get a listing of the tables/other schema objects.</p>
  
  <p>This is the exact response I'm getting:</p>
  
  <pre><code>Error Code: 1227 Access denied; you need the SHOW DATABASES privilege for this operation
  </code></pre>
  
  <p>This is the response I'm getting from show grants. I ran this as root user on the localhost. I've obfuscated any info that might identify my DB.</p>
  
  <pre><code>mysql&gt; show grants for 'mydb'@'%';
  +-----------------------------------------------------------------------------------------------------+
  | Grants for mydb@%                                                                                   |
  +-----------------------------------------------------------------------------------------------------+
  | GRANT USAGE ON *.* TO 'mydb'@'%' IDENTIFIED BY PASSWORD 'mypassword' |
  | GRANT ALL PRIVILEGES ON `mydb`.* TO 'mydb'@'%'                                                      |
  +-----------------------------------------------------------------------------------------------------+
  2 rows in set (0.00 sec)
  </code></pre>
  
  <p>Any ideas on how to fix it? Thank you.</p>