'MySQL Workbench Schemas Panel not working

I have a trouble with my MySQL workbench 6.0 (i work on Ubuntu) and when I choose a server instance, instead of the "SCHEMAS" panel it shows the message "No object selected". In the "SQL panel" (main panel), the query show databases; works, but I have no list of the databases in the "SCHEMAS" panel.

I have this problem with all my instances and when there is a lot of databases and tables, it's annoying!

Do you have any idea about this problem?
Thanks,

mysqlmysql-workbench


Solution 1:[1]

Have you tried dragging the window boarder just above the "Object Info" button?

enter image description here

Solution 2:[2]

I have the same issue on Mac. I tried to uninstall MySQL, Workbench, but doesn't work.

the solution for me is:

  1. quit workbench

  2. in Terminal:

cd ~/Library/Application\ Support/MySQL/Workbench/

rm wb_state.xml

rm wb_options.xml

which reset workbench setting and configurations

  1. start workbench again. everything back to normal

If you are using Windows or Linux. do the same for the below file path

Windows %AppData%\MySQL\Workbench\
Linux   ~/.mysql/workbench/

Alternatively, If you can see only 2 tabs on the left sidebar namely Object Info and Session at the very top of the sidebar, then you may be able to drag the top of the sidebar to the bottom if you are lucky enough

Solution 3:[3]

I was facing the same issue in MacOS and deleting the caches worked for me. But, the path in MacOS is not the same

Windows %AppData%\MySQL\Workbench\
OS X    ~/Library/Application\ Support/MySQL/Workbench/
Linux   ~/.mysql/workbench/

I deleted the wb_options.xml and wb_state.xml files and restarted Workbench and all was back to normal.

Solution 4:[4]

Had the same issue and deleting the cache files worked for me.

I am on windows but it seems the path for Linux is "~username/.mysql/workbench/"

The windows path is "%AppData%\MySQL\Workbench\"

I deleted the wb_options.xml and wb_state.xml files and restarted Workbench and all was back to normal.

More details on the settings and log files here: https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html

Solution 5:[5]

It may be a small problem about the UI itself. I said maybe because in my case it was just about not having a good UX.

If you can see only 2 tabs on the left sidebar namely Object Info and Session at the very top of the sidebar, then you may be able to drag the top of the sidebar to the bottom. And ta-da! Your Management schemes appears! They were just sleeping there while I was searching on the web.

Solution 6:[6]

Just delete(or move if you want to save them) the config files, on unix it is in ~/.mysql/workbench, don't know where workbench saves it under other platforms.

Solution 7:[7]

Close Workbench. Remove from Windows Task Manager.

In C:\Users[you]\AppData\Roaming\MySQL\Workbench\cache, delete the XXX.columns_widths file where XXX is your connection name.

Open Workbench again, select Schema Priveleges and change window Workbench size and after maximize window.

Solution 8:[8]

OS X ~/Library/Application\ Support/MySQL/Workbench/

I deleted the wb_options.xml and wb_state.xml files and restarted Workbench and all was back to normal.

Solution 9:[9]

enter image description here

just move your cursor in sidebar panel (Management,Instance,Performance) whichever is last shown in the panel, once your cursor is change (available for dragging Panel) drag panel below.

Solution 10:[10]

delete :

  <value type="int" key="DbSqlEditor:SecondarySidebarHidden">0</value>
  <value type="int" key="DbSqlEditor:SecondarySidebarWidth">218</value>

Solution 11:[11]

My issue was a different cause & solution, but it might help someone else, so I'll post it. If you are using Laravel Forge, make sure to edit your database user and give it access to the tables that you need to work with. My database wasn't appearing in my panel because I had created a new database after I had already created a user (all in Laravel Forge) so I had to go back and give the user permission to access the new db.

Related Questions