Bug #67038 MySQL WorkBench Never Locates Server Section in Configuration
Submitted: 1 Oct 2012 17:17 Modified: 10 Jan 2013 2:00
Reporter: Ron Adams Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.43 CE OS:Windows (Server: 2008 R2 SP1, Workstation: Windows 7 Enterprise SP1)
Assigned to: CPU Architecture:Any
Tags: my.ini

[1 Oct 2012 17:17] Ron Adams
Description:
When attempting to administrate a server instance from a remote MySQL Workbench through SSH, the version of the server, the location of the configuration file (once modified from the ENV variable path to the absolute path), and other assets are read and modified correctly.

However, I am unable to view or modify the options file. The error complains it cannot find the section [mysqld], even though this section exists in my.ini. If I choose to modify a parameter, it correctly backs up the existing my.ini and creates a new my.ini with only the change I have made and the section header (and no other parameters, including defaults). I have tried several options, including redacting everything but this section, but nothing seems to work. Can someone take a look at this?

N.B.: This installation was executed automatically via the Microsoft Web Platform Installer for Joomla. While I see no remarkable inconsistencies from a standard MySQL for Windows installation, I have not had the time to replicate this in a more "vanilla" environment.

How to repeat:
1. Configure a MySQL 5.1 instance via Microsoft Web Platform Installer for Joomla.

2. Configure SSH services and successfully connect to the instance remotely.

3. Observe that though other assets are detected, the server will not successfully read the [mysqld] section of my.ini.

Suggested fix:
I cannot determine why it may be unable to read this section. I am ruling out permissions problems as it can successfully move the file, unless it somehow can modify but not read, which would be very odd. It is worth noting that the user I am connecting with is a standard local user and a member of the Administrators group (with rights to log on locally and via RDP).
[1 Jan 2013 23:59] MySQL Verification Team
Please try version 5.2.45. Thanks.
[10 Jan 2013 2:00] Ron Adams
The new version resolved the issue. Thank you.