Bug #53286 wrong server status and confusing error message
Submitted: 29 Apr 2010 11:45 Modified: 30 Apr 2010 7:40
Reporter: Susanne Ebrecht Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.20 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[29 Apr 2010 11:45] Susanne Ebrecht
1. Make sure that the server is not running
2. Start Workbench
3. Administrator -> double click the server instance

You will get the following error message:

Cannot Connect to MySQL
Lost connection to MySQL server at 
'reading initial communication packet',
system error: 111
Connection parameters might be incorrect or the
server might be down.
Some functionality will not be available.

4. Click OK
5. look into Administrator:

2010-04-29 13:42:56 - Checked server status: Server is running.
2010-04-29 13:42:57 - Server is running

Take shell and look if server is running:

$ ps ax | grep mysql
10204 pts/0    S      0:00 /bin/bash ./bin/mysql-workbench
10208 pts/0    S      0:00 /bin/sh /usr/bin/catchsegv ./bin/mysql-workbench-bin
10210 pts/0    SLl    0:09 ./bin/mysql-workbench-bin
11093 pts/0    S      0:00 /bin/bash ./bin/mysql-workbench
11097 pts/0    S      0:00 /bin/sh /usr/bin/catchsegv ./bin/mysql-workbench-bin
11099 pts/0    SLl    0:06 ./bin/mysql-workbench-bin
12002 pts/0    S+     0:00 grep mysql

No server is running.

How to repeat:
See above
[29 Apr 2010 16:05] Alfredo Kojima

Please provide the entry for the instance you tested from ~/.mysql/workbench/server_instances.xml
[30 Apr 2010 7:40] Susanne Ebrecht
Sorry Alfredo. Seems I forgot to close this.

It was a configuration mistake I made.