Bug #81915 MySQL Workbench MySQL 5.7 Options File in wrong place
Submitted: 18 Jun 2016 9:41 Modified: 24 Jun 2016 15:48
Reporter: Stephen Palmstrom Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:6.3 OS:Windows
Assigned to: CPU Architecture:Any
Tags: options file, workbench

[18 Jun 2016 9:41] Stephen Palmstrom
Description:
After installing MySQL 5.7 under Windows, the Options File presented by MySQL Workbench has the following path, which, unless you create it manually, does not exist:

C:\Program Files\MySQL\MySQL Server 5.0\my.ini

Notice, it is 5.0, not 5.7!  I have been unable to discover where this value is stored to correct it.  It also that the 5.7 instance seems confused about where to get its files.

How to repeat:
Install MySQL 5.7 with the MySQL installer on a Windows system.

Suggested fix:
Correct the path to C:\Program Files\MySQL\MySQL Server 5.7\my.ini or even make it possible to change that path.
[18 Jun 2016 22:08] MySQL Verification Team
my.ini place

Attachment: my_ini_file.png (image/png, text), 1008.84 KiB.

[18 Jun 2016 22:10] MySQL Verification Team
Installed fresh server 5.7.13 and workbench 6.3.7 and the option file is placed in correct place (see attached screenshot).
[20 Jun 2016 17:50] Stephen Palmstrom
I was doing a clean install of 5.6 and 5.7.  I've just run MySQL Installer catalogue which shows that there are no upgrades from 5.7.12 and Workbench 6.3.6, so where do we get updates beyond that?
[20 Jun 2016 18:00] Stephen Palmstrom
Screenshot of MySQL Workbench running MySQL 5.7.12

Attachment: WorkBench.PNG (image/png, text), 7.29 KiB.

[24 Jun 2016 15:48] Stephen Palmstrom
I am now running the latest versions.  I removed and reinstalled MySQL 5.7, and options file is now C:\ProgramData\MySQL\MySQL Server 5.7\my.ini.

However...

I also have an instance of MySQL 5.6.  This has stopped working, and its options file has become C:\ProgramData\MySQL\MySQL Server 5.0\my.ini

Please check what happens if you have two versions of MySQL coexisting.