Description:
Workbench crashed spontaneously without warning, after restarting its no longer possible to do start any of the instances in the server administration section.
An error message turn up when I double click or in any other way try to start any of the instances.
Error Starting Workbench Administrator
QueryError: Error executing ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘plugins’ at line 1′
show plugins.
SQL Error: 1064
Remote management turned of, everything in the settings looks fine, connecting through HeidiSQL works perfectly.
This is the error message in "system info" section.
##############################################
ctrl_be: Query Error Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'plugins' at line 1'
show plugins.
SQL Error: 1064
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 125, in do_open_administrator
adminTab = AdministratorTab(server_instance)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 65, in __init__
self.ctrl_be.init()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 363, in init
self.connect_sql()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 588, in connect_sql
result = self.exec_query("show plugins")
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 653, in exec_query
raise e
QueryError: Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'plugins' at line 1'
show plugins.
SQL Error: 1064
##############################################
This is the actual system info.
MySQL Workbench CE for Windows version 5.2.35
Configuration Directory: C:\Users\<removed>\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 3.3.0
OS: Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 64-bit
CPU: 2x Intel(R) Core(TM)2 Duo CPU P8800 @ 2.66GHz, 4.0 GiB RAM
Active video adapter: NVIDIA GeForce GTX 260M
Installed video RAM: 1024 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.6089
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: Svenska (Sverige)
##############################################
How to repeat:
Invoke a spontaneous crash without error message (!?!?) Restart MySQL Workbench