MySQL Bugs: #79899: Under Instance > Options File > bad option causes corruption of my.cnf

Bug #79899	Under Instance > Options File > bad option causes corruption of my.cnf
Submitted:	8 Jan 2016 21:18	Modified:	9 Feb 2016 0:02
Reporter:	Adam Plocher	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.6	OS:	Windows (Microsoft Windows 10 Pro Insider Preview)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
MySQL Workbench sets a setting in my.cnf called "general-log" when you try to enable general logging.

The problem is, it's not general-log, it's general_log (underscore, not dash).  MySQLD will no longer restart if you check that checkbox.

How to repeat:
When connected to an instance in MySQL Workbench, in left sidebar:

Navigate to Instance > Options File

Go to the Logging Tab

Check "general-log"

Apply

Restart mysqld (or attempt to)

Suggested fix:
Change dash to underscore.  QA.

Thank you for the bug report. Against which server version are you running WorkBench?

C:\>type "c:\ProgramData\MySQL\MySQL Server 5.6\my.ini" | findstr general
general-log
general_log_file="URALBR.log"

C:\>net stop mysql56
The MySQL56 service is stopping..
The MySQL56 service was stopped successfully.

C:\>net start mysql56
The MySQL56 service is starting.
The MySQL56 service was started successfully.

C:\>type "c:\ProgramData\MySQL\MySQL Server 5.6\my.ini" | findstr general
general-log
general_log_file="URALBR.log"

C:\>dbs\5.6\bin\mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.27-log MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like "%dir%";
+-----------------------------------------+---------------------------------------------------------+
| Variable_name                           | Value                                                   |
+-----------------------------------------+---------------------------------------------------------+
| basedir                                 | C:\Program Files\MySQL\MySQL Server 5.6\                |
| binlog_direct_non_transactional_updates | OFF                                                     |
| character_sets_dir                      | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ |
| datadir                                 | C:\ProgramData\MySQL\MySQL Server 5.6\Data\             |
| ignore_db_dirs                          |                                                         |
| innodb_data_home_dir                    |                                                         |
| innodb_log_group_home_dir               | .\                                                      |
| innodb_max_dirty_pages_pct              | 75                                                      |
| innodb_max_dirty_pages_pct_lwm          | 0                                                       |
| innodb_undo_directory                   | .                                                       |
| lc_messages_dir                         | C:\Program Files\MySQL\MySQL Server 5.6\share\          |
| plugin_dir                              | C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\     |
| slave_load_tmpdir                       | C:\WINDOWS\SERVIC~2\NETWOR~1\AppData\Local\Temp         |
| tmpdir                                  | C:\WINDOWS\SERVIC~2\NETWOR~1\AppData\Local\Temp         |
+-----------------------------------------+---------------------------------------------------------+
14 rows in set (0.00 sec) 

C:\>sc qc MySQL56
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: MySQL56
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 3   DEMAND_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL56
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".