Bug #68227 Instaler potentially Installing into strange directory,I please a recommendation
Submitted: 30 Jan 2013 19:40 Modified: 23 Aug 2017 10:36
Reporter: Jan Valský Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.5/5.6 OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: mysql-5.5.29-win32.msi

[30 Jan 2013 19:40] Jan Valský
Description:
If I revoke all Users (Groups) from the strange directory (Canon), Installer pleads those backwards trough Retry otherwise not progresses further. It looks like as something from outside (registry???) is forcing msi to behave in the strange manner.
The Server should be applicable even if using it from the non-convenient strange directory probably, but I appreciate this behavior suspicious and that's why I have set my MySQL training aside for now.

How to repeat:
You see the Description.

With one's own eyes (jpg*):

http://czshare.com/4824914/StrangeInstallationMySQL.jpg

(*) .. till ago 2/20/2013 or contact me

Suggested fix:
Why can't be prevented that behavior essentially on the basis of principle the simplicity is yet right? The things is that, to do MySQL installation conditionless into MySQL directory, or offer an where-to-option to Users in advance.
[31 Jan 2013 11:30] MySQL Verification Team
Thank you for the bug report. Sorry I don't understand what is your issue, please provide the install process you did step by step pointing where it failed. Thanks.
[1 Feb 2013 6:28] MySQL Verification Team
seen a few reports of this problem already;   Why it installs into "Easy-WebPrint EX" directory?

http://forums.mysql.com/read.php?11,511117,511117#msg-511117
[1 Feb 2013 13:20] Jan Valský
Thanks for the answer! I attach explanation below. JV
--
I have started the mysql-5.5.29-win32.msi and I choose "Complete Installation". The window "MySQL Server 5.5 Setup" was taking place frontmost and monitoring progress of the installation. In the Phasis "Status: Copying new files" the Installation process was suspended via alert "Retry/Cancel" window of the same name with message:

"The installer has insufficient privileges to access this directory: C:\Program Files\Canon\Easy-WebPrint EX.
The installation cannot continue. Log on as administrator or contact your system administrator."

O.K. In fact I revoked all acces privileges for the directory "C:\Program Files\Canon\" by intent. Because past coming back to the PC (1.3 GHz) I was finding the MySQL Server installed in "C:\Program Files\Canon\Easy-WebPrint EX\" at the first go. I found himself unable to understand it anyway and I decide to trip such hockey and to observe the stopped goal with one's own eyes past uninstalling at the second go. I was recording the hole situation as "StrangeInstallationMySQL.jpg" thereafter and attaching it in the report via http link. I forget about original intent at first to examine the same Installation process on another PC unfortunately. I was examining this afterwards and I find out the Installation was going O.K. by hunch. But on my PC the Installation is going strange via the above mentioned manner repeatedly and I know not how dispose of this for to get the Server in the proper "C:\Program Files\MySQL\" directory.

So I had classify my issue with other Severity or turn me on the forum and I apologize to you for mistake. However I think the operation system should stop any incorrect step for to ensure independence of installation processes among themselves. Is it a good Idea after all? I please recommend me what to do with this trouble on my disciple PC.
[19 Feb 2013 19:08] Sveta Smirnova
Thank you for the feedback.

Did you have MYSQL installations, earlier installed in Canon directory?

Have you tried to specify custom location for MySQL installation?
[20 Mar 2013 1:00] Bugs System
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".
[17 Apr 2013 16:26] Furat Muhi AL-Din
I have the same problem and I have uninstalled both Mysql and the Canon printer software and reinstalled MySQL. 
 The Windows installer still created a Canon folder and placed the bin folder there. 
The Canon folder is: C:\Program Files\Canon\Easy-WebPrint EX
[29 Apr 2013 12:57] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=68821 duplicate of this one.
[18 Jul 2013 17:08] Sveta Smirnova
Thank you for the feedback.

I can not repeat described behavior on my computer.

Please try with current version 5.5.32 and if problem still exists provide more details about your Windows OS.
[17 Aug 2013 17:05] Jan Valský
2 logfiles with which the behavior is docummented. /Server 5.6 2

Attachment: mysql-installer-community-5.6.10.0.msi (Log).zip (application/octet-stream, text), 70.81 KiB.

[17 Aug 2013 18:03] Jan Valský
Please read the comment

Attachment: StrangeInstallationMySQL.jpg (image/jpeg, text), 146.57 KiB.

[17 Aug 2013 18:08] Jan Valský
Hi,

I have attached zip with installation logfiles in whose the misused Canon-directory can be found. Also I attach the previously mentioned file "StrangeInstallationMySQL.jpg" better via using the Files-tab. Maybe they have something useful.

Jan Valský
[28 Nov 2013 19:31] Sveta Smirnova
Bug #70918 was marked as duplicate of this one.
[9 Mar 2014 2:39] Michael Lane
I have the same problem.  Had an early 5.5.x version working - installed to correct place.  Upgraded to 5.5.32, installed to the Canon directory.  MySQL server stops working.  Trying to run the serer complains that it "Can't open the mysql.plugin table. Please run mysql_upgrade to create it." in the Application Event logs.
Over time I had uninstalled, cleaned the registry of all MySQL entries and reinstalled.  In the reinstalled directed it to install to the correct directory.  Still did not work.  Same event log.
Installed the 5.6.16 version as an upgrade.  This has dropped the .ini files into the Canon folder again.
I find the really odd.  Particularly since the the incorrect folder is within the C:\Program Files(x86) - but I'm installing the 64bit version!
[9 Mar 2014 13:34] Michael Lane
Now I feel foolish.  Fixed the issue.  Deleted all the old incorrectly placed files.  Then ran the 5.6.16 standalone installer - not the web connected one. First action to uninstall all previous instances, then instead of upgrade the option is to install.  Worked a charm.  Interesting to note that when I started workbench, it was looking for the ini file in the silly Canon directory.  Corrected that - and off we go.
[9 Apr 2014 15:17] MySQL Verification Team
Please check the workaround from [9 Mar 13:34] Michael Lane works for you?. Thanks.
[10 May 2014 1:00] Bugs System
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".
[5 Jun 2014 11:28] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=72883 marked as duplicate of this one.
[5 Jul 2014 22:15] david robertson
Getting same issue installs to canon directory
[27 Jul 2014 11:48] Dietmar Berg
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.
[19 Aug 2014 14:51] MySQL Verification Team
Please check comment:

[27 Jul 11:48] Dietmar Berg

Thanks.
[20 Sep 2014 1:00] Bugs System
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".
[15 Dec 2014 1:00] Bugs System
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".
[16 Dec 2014 10:28] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=75228 marked as duplicate of this one.
[17 Dec 2014 23:51] Jim Ferris
I filed bug #75228. In order to get the installation to work correctly, I had to search the registry for Canon/Easy-WebPrint EX and remove the unwanted Canon entries. Then I had to uninstall all of the MySql products, manually delete all of the MySql files and directories that were left after the uninstall (otherwise the re-install would not work for any of the 4 pre-defined configurations) and then install again from the community msi file. It would seem to me that the uninstallers should have deleted any files that could affect the re-install.
[18 Dec 2014 18:43] Sveta Smirnova
Thank you for the feedback.

All reporters, since we don't have Canon/Easy-WebPrint EX and Canon registry entries, could you please backup them to us, so we can update the registry on test machine and finally repeat this bug?
[2 Jan 2015 4:19] Dennis Foreman
I too have had this problem (previously fond with MySQL 5.6.19), but I have since removed all the offending Canon registry entries and when I upgraded to 5.22, it again installed in the Canon/Easy-webprint EX/ folder. I was able to shutdown the server, copy ALL the files from that Canon folder to the MySQL Server 5.6 folder. I was then able to restart the server and the MySQL status command displays the proper version. Painful, but it works.
[2 Jan 2015 19:54] Dennis Foreman
I'm not sure what you mean by this: "All reporters, since we don't have Canon/Easy-WebPrint EX and Canon
registry entries, could you please backup them to us"

I think that, if you create folder "c:\canon\Easy-Webprint EX/" and do an install you will probably see it. If not , then you will probably need to install the Easy-Webprint program. If you need it, I will research to see if you can download it from Canon.

In addition, you might tell us how your installer decides where to install the files (what value does it check and where is that value stored). MOST installers say where they PLAN to install their product and ask for the user to change the path as needed. Yours doesn't do that which exacerbates the problem.
[2 Jan 2015 20:16] Dennis Foreman
That path should have said "C:\Program Files (x86)\Canon\Easy-WebPrint EX\
[24 Feb 2015 0:29] Mary Carroll
Occurs in Windows 7 as well.
[21 Apr 2016 17:30] MySQL Verification Team
we should check if the fix for https://bugs.mysql.com/bug.php?id=74631 will solve this ...
[23 Aug 2017 10:36] Yngve Svendsen
Duplicate of https://bugs.mysql.com/bug.php?id=74631 (fixed)