Bug #73255 unable to access a single database if user without SHOW DATABASES privilege
Submitted: 10 Jul 2014 9:18 Modified: 21 Aug 2014 19:18
Reporter: Pierluca Tonetto Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.1.7 OS:Windows (7)
Assigned to: CPU Architecture:Any
Tags: privilege, show databases

[10 Jul 2014 9:18] Pierluca Tonetto
Description:
Even specifying the name of the default schema to use within a connection, Workbench issues the "SHOW DATABASES" command resulting in an 1227 error and unabling access to the database.

Actual options:
DbSqlEditor:LastDefaultSchema=530484mobilex
lastConnected=1404983298
serverVersion=5.0.95-log

How to repeat:
This issue accurs anytime an user tries to access a remote database for which he/she hasn't the SHOW DATABASES privilege

Suggested fix:
Let users define a SINGLE database to access not sending the SHOW DATABASE command
[3 Mar 2015 17:15] Markus Heinrichs
Issue persists in MySQL workbench 6.2.4.12437. The Reverse Engineer function _is_ able to fetch schemas, however.