Bug #68482 Windows shortcut references "my-defaults.ini" incorrectly in XP
Submitted: 25 Feb 2013 6:58 Modified: 25 Feb 2013 11:56
Reporter: Raymond Law Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:5.6.10.1 OS:Windows (XP)
Assigned to: Reggie Burnett CPU Architecture:Any
Tags: shortcut

[25 Feb 2013 6:58] Raymond Law
Description:
The XP Default Shortcut points to an incorrect ini file.

How to repeat:
Fresh Install MySQL Server only on Windows XP

Via the GUI,  Start Menu > MySQL > MySQL Server 5.6 > Command Line Client

After installing went to click the Command Line Client, only to have it auto close.

Tried again, this time right clicking and checking the shortcuts Target

which gave

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.6\my.ini" "-uroot" "-p"

Ran this from command prompt

>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql
.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.6\my.ini" "-uroot"
"-p"
Could not open required defaults file: C:\Program Files\MySQL\MySQL Server 5.6\m
y.ini
Fatal error in defaults handling. Program aborted

Trouble shooting I went to look for this file my.ini,
but instead I found my-default.ini instead.
After renaming it to my.ini Everything works

Suggested fix:
Fix the shortcut name?

Again I'm not even 100% this is a bug or that i didn't goof the install.

I think I had the same problems with the Developer Installation too, so it might be a bigger issue than just that.
[25 Feb 2013 7:39] Peter Laursen
I noticed that recent versions of the ('integrated') .msi installer places my.ini at C:\ProgramData\MySQL\MySQL Server 5.6\my.ini (on Vista and above - on XP it is something like \Application Data\All Users\MySQL\MySQL Server 5.6 .. I believe) and not in installation folder (thanks for that BTW!).

The command in 'properties' of the Start Menu entry on my Win7 system reads

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" "--defaults-file=C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" "-uroot" "-p"

.. and it works fine.
[25 Feb 2013 7:45] Peter Laursen
I think the command on XP should be something like (as far as I remember)

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" "--defaults-file=C:\Application Data\All Users\MySQL\MySQL Server 5.6\my.ini" "-uroot" "-p"

I also think I read that XP and 2003 is not officially supported with MySQL 5.6 (what I do not understand). But still I think it is possible to use a placeholder that will resolve to "Application Data\All Users" on XP/2003 and "ProgramData" on Vista+ Windows.
[25 Feb 2013 11:56] MySQL Verification Team
Thank you for the bug report. XP isn't more supported for this MySQL version.

http://www.mysql.com/support/supportedplatforms/database.html