MySQL Bugs: #62252: MySQL Workbench on Windows modifies wrong config file

Bug #62252	MySQL Workbench on Windows modifies wrong config file
Submitted:	24 Aug 2011 15:40	Modified:	21 Nov 2011 18:22
Reporter:	Sean Rafferty	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.34 CE R7780	OS:	Windows (7)
Assigned to:		CPU Architecture:	Any
Tags:	Administration, server logs, workbench

Description:
I was trying to configure the Workbench to display server log files.  In the MySQL Workbench Admin section, if you change settings for the Options File, the changes are made to my.cnf instead of my.ini.  I am certainly not an expert, but I was under the impression that my.ini was used for Windows, and my.cnf was used for Unix based systems.

Once I edited my.ini manually and restarted the server, Workbench now displays the log file.

Not sure if it matters, but I am using XAMPP.

How to repeat:
Open MySQL Workbench
Go to Server Administration
On the left panel choose Options File
Under Activate Logging, enable general_log
Under Advanced Log Options, enable general_log_file and set a file path.
Under Advanced Log Options, enable log-output and set it to TABLE.
Click Apply in the lower right corner.

Note that my.cnf was updated instead of my.ini.

Thank you for the bug report. In Configuration - Option File what is the path showed?. Thanks.

Configuration File path is set to c:\xampp\mysql\bin\my.cnf.  I did not see this path down there where I entered the bug.  

However, when I edit this path to my.ini, close Workbench, reopen Workbench, the path changes back to my.cnf.

If the server installation was done as Windows service please provide the output of:

sc qc service_name

command above change 'service_name' for the actual one. Thanks.

SERVICE_NAME: mysql
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xa
mpp\mysql\bin\my.ini mysql
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : mysql
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

Hello,

We're going to work on this bug in order to fix it, in the meantime you can change the option file path in your administration instance, not on the actual page (workbench)

Fixed as of 5.2.36:

+        The <literal>Configuration File</literal> path within the
+        <guimenu>Server Administration</guimenu> panel is now read-only,
+        when before it would temporarily set the path. This path should
+        be set via the profile setting instead.