MySQL Forums
Forum List  »  MySQL Workbench

Workbench 8.0 - default database won't show up if no SHOW DATABASES privilege
Posted by: Gary Gao
Date: June 24, 2019 10:10AM

My organization does not grant SHOW DATABASES privilege to any user. So I put the database name I need to access into the "Default Schema" box in new connection configuration, and hoping the schema will show up in the schema browser pane.

But when connected to the server, I got a error like:

12:01:33 Get schemata Error Code: 1227 Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

and the "Schemas" pane was completely blank.

And the most important, when I tried to export data, there just no schema there for me to select. This makes the workbench USELESS for me.

Tried to use many other tools like dbForge Studio and Toad Edge and they all list the default schema under the connection. Why cannot the workbench do this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Workbench 8.0 - default database won't show up if no SHOW DATABASES privilege
729
June 24, 2019 10:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.