At first I thought it was related to the specific version of MySQL. Manuel Bleichenbacher I've upgraded the MySQL server that has been causing problems and now the problem is gone.Īfter the installation I've investigated what could have caused the problem. (The node is expanded, but the database node and it's three subnodes just display "fetching.") Expand the the node for the second database in the Object Browser ("Overview" view shows "0 items" for tables, views and routines.) Open a connection from the "Home" screen In the MySQL forum I've seen that other users encountered the same problem. With that instance, MySQL Workbench doesn't show this problem. I can connect to another MySQL instance on a different server. The problem seems to appear only in combination with certain MySQL servers. If I select the second database (iaeth) in the "Overview" view and then expand the database node in the object browser, it works. The object browsers shows the "Tables", "Views" and "Routines" nodes for the first database (cms), but only "fetching." when the second database (iaeth) and its subnodes. Instead it says "0 items" for tables, views and routines. But for none of the databases the "Overview" shows any tables(even though there are many in the two databases).
The server contains two databases: cms and iaeth (in addtion to information_schema and mysql), cms and iaeth are shown when I connect as root. the available tables, views and routines.
Both the object browser view and the overview view are unable or partially unable to fetch the schema information, i.e. After connecting to a database, the SQL editor opens and displays the object browser view and several tabs, one called "Overview".