MySQL Bugs: #62408: Error when opening a database server instance for Admin

Bug #62408	Error when opening a database server instance for Admin
Submitted:	11 Sep 2011 20:52	Modified:	7 Oct 2011 7:16
Reporter:	John Vanderburg	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.35-pre22	OS:	Windows (Win7x64 Prof Build 7601)
Assigned to:		CPU Architecture:	Any

Description:
When opening a server instance for Admin I receive the following error:

QueryError: Error executing 'You have an error in your SQL syntax; check the manual...  for the right syntax to use near 'plugins' at line 1'
show plugins.
SQL Error: 1064

The MySQL server I'm trying to connect to is 5.0.75

How to repeat:
Start the Workbench
Try to open a server instance for admin.

It works when I connect to a server running MySQL 5.5.15.

In that case it may not be a bug if you are no longer supporting version 5.0; however, I'll leave this open for an 'official' comment on 5.0 support since it did work in the last version of Workbench.

Thank you for the bug report. Could you please provide the my.ini file for the 5.0 server?. Thanks.

Since I have the exact same problem maybe my config file might help as well. My MySQL version is 5.0.51

[client]
port                    = 3306
socket                  = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket                  = /var/run/mysqld/mysqld.sock
nice                    = 0

[mysqld]
user                    = mysql
pid-file                = /var/run/mysqld/mysqld.pid
socket                  = /var/run/mysqld/mysqld.sock
port                    = 3306
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
language                = /usr/share/mysql/english
skip-external-locking
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
max_connections         = 50
table_cache             = 2048
open_files_limit        = 3072
tmp_table_size          = 512M
max_heap_table_size     = 512M
query_cache_limit       = 2M
query_cache_size        = 32M
log_slow_queries        = /var/log/mysql/mysql-slow.log
long_query_time         = 2
log-queries-not-using-indexes
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]

[isamchk]
key_buffer              = 16M

This is a duplicate of Bug #62549. See temporary workaround/solution there.