MySQL Bugs: #70918: 5.6 installs in incorrect directoy

Bug #70918	5.6 installs in incorrect directoy
Submitted:	15 Nov 2013 7:24	Modified:	28 Nov 2013 19:31
Reporter:	David Johnston	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.6	OS:	Windows (7)
Assigned to:		CPU Architecture:	Any

Description:
Installing 5.6 on a 64-bit Windows 7 machine.

It always installs in Program (86)\Canon\Easy-Webprint EX directory. Even after I uninstalled that particular device.

Nothing in the registry or anywhere else that I can find will make it install in Program Files\MySQL\ Windows Server 5.6 as it should.

And for some crazy reason, in the clever installation package there is no way of telling it where it shoudl install.

This is hugely time-wasting, and is stopping me moving to any sort of paid version of MySQL, as it cannot be trusted to install in th directory it should.

How to repeat:
Install Canon Printer then install mysql-installer-community-5.6.14.0.msi. or 4.6.13.0, or any of these clever ones, really.

Suggested fix:
Allow the user to say where the Server will install.

see http://bugs.mysql.com/bug.php?id=68227 also

I thought I reported the same a few months ago but the report is gone (made private?)!

If you ever had a 32 bit of same major version (such as 5.6) installed once all consequtive 5.6 installs will go to \program files (x86). The installer (what is a .NET program) will find a registry key from the old 32 bit install. 

In my - now gone - report the registry key is named and deleting it resolves the issue. There was one more workaround, but I don't remember now.

I went through the registry deleting every mention of the Easy-webprint and it still insisted on installing there, so it must hold that information somewhere else.

I remember it was Miguel from Oracle/MySQL support who replied to the bug report of mine, I now cannot find.

I wonder if it is this key?

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MySQL AB\MySQL Server 5.6]

On my Win7/64 bit system (where it is now installed to the correct folder) it reads:

"Location"="C:\\Program Files\\MySQL\\MySQL Server 5.6\\"
"Version"="5.6.14"
"DataLocation"="C:\\ProgramData\\MySQL\\MySQL Server 5.6\\"

Does it read
"Location"="C:\\Program Files (x86)\\MySQL\\MySQL Server 5.6\\"
...
on your system?

If you dare you could try to edit the "Location" (advise: first export the key!). Or wait for MySQL supporters to reply (but due to the weekend it may take a while, I guess)

wouch!

Here is my report.  I reported with 5.5 (but still using the "Windows Installer"):
http://bugs.mysql.com/bug.php?id=69917

And it ws Shane and not Miguel who replied to my report BTW.
(don't know to who of them I should apologize!)

.. and also quite strange that it on your system installs to "..\Canon\Easy-Webprint EX" folder. It has absolutely nothing to do there!

But I think that if you only did once yourself (by mistake) it will continue to do so.

Anyway .. you should have the key [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MySQL AB\MySQL Server 5.6] and you could check what "location" is set to.

I'm not sure what that key you mention was set at, but it definitely wasn't the Easy-Webprint. Yet that is constantly where MySQL installs. And since the installer has never allowed me to set the installation directory, I can only assume that it is using the same 'key' as the installation of the Canon Easy-webprint. Enough other people seem to have ended up in the same spot for it to be more than coincidence.

It is basically a faulty .msi that is the problem.

The key I mentioned was 
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MySQL AB\MySQL Server 5.6]
It has a "Location" sub-key/string value

(and I agree that the "MySQL Installer" is crap!)

Okay, Peter, pretty sure it was okay when I last tried an install. But I'll try it again - once I've caught up on a whole day wasted on this idiocy!

Thanks

Thank you for the report.

This is duplicate of bug #68227

Also having a Canon printer, I get MySQL Server 5.6 on XP/32-bit installed into C:\Programme\Canon\Easy-WebPrint EX

The reason is a registry setting which should not be there:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ directly (and NOT in a subkey, as it should be) contains the entries InstallLocation, UninstallString and a few more that relate to the Canon software.

Just delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\InstallLocation and MySQL Server installs into the "correct" location.