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:
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
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:

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 The Reverse Engineer function _is_ able to fetch schemas, however.