MySQL Bugs: #88934: Community Installer doesn't install correct Microsoft DLLs

Bug #88934	Community Installer doesn't install correct Microsoft DLLs
Submitted:	15 Dec 2017 4:02	Modified:	28 Dec 2017 4:55
Reporter:	Anthony E. Scandora, Jr.	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.7.20.0	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
mysql-installer-community-5.7.20.0.msi on fresh install of Windows 10.0.16299 (Fall Creators Update 1709) Pro 64-bit with updated OneDrive client, Office Professional Plus 2016, all current Windows Updates, no other installed software.

1) Serious: Install MySQL Server 64-bit fails. Check Requirements downloads and installs VC++ 2013 (x64). Installation of MySQL Server 64-bit fails, with Show Details complaining that it does not have Visual Studio 2013 Redistributable. What it actually wants is Visual C++ (not Visual Studio) 2013 Redistributable (x86). Check Requirements installs VC++ 2013 x64, but it does not install x86, which MySQL Server 64-bit cannot be installed without.

2) Not as serious because it only affects the Excel connector: Install Excel connector fails. Check Requirements says it's doing Microsoft Visual Studio 2010 Tools for Office Runtime but it's never satisfied. Hit Back, Next, Execute, and it will not be satisfied again. Repeat forever.

3) Not at all serious: Check Requirements needs some of the same Microsoft DLLs for multiple MySQL components. For each MySQL component, it re- downloads and re-installs DLLs that it previously downloaded and installed.

How to repeat:
Unless you install Visual C++ 2013 Redistributable (x86) manually, Check Requirements will not install it, and Back, Next, Execute will be satisfied. MySQL Server will never install.

Unless you manually install Visual Studio 2010 Tools for Office Runtime, Check Requirements will not be satisfied, and Back, Next, Execute can repeat forever.

Suggested fix:
Serious: Fix Check Requirements to download and install the Microsoft DLLs that MySQL actually uses.

Minor inconvenience: For Microsoft DLLs that are used by multiple MySQL components, do not re-download and re-install them.

Hello Anthony,

Thank you for the bug report.
This is most likely duplicate of Bug #87962, please see Bug #87962

Thanks,
Chiranjeevi.

Bug #87962 only addresses VC++ 2013 (x86). It does not address VS 2010 Tools for Office Runtime, vstor_redist.exe, at  https://www.microsoft.com/en-us/download/details.aspx?id=54251, which is needed by MySQL for Excel 1.3.7.

I'm stumped. Without pre-installing that VC++ Redistributable, Installer failed to install MySQL Server, and Show Details had an error message. Wrong, but a good enough clue that I could find what it really wanted and then install MySQL Server.

On the other hand, Installer for MySQL for Excel 1.3.7 downloads and installs Visual Studio 2010 Tools for Office Runtime (x64). Requirement always says said Visual Studio 2010 Tools for Office Runtime is not installed, and Status blank. You can hit Back, Next, Execute again and it will re-install that DLL again but still not be satisfied. Hit Next and Installer will not even try MySQL for Excel, which leaves no Show Details offering any clue about what it wants.

I found https://www.microsoft.com/en-us/download/details.aspx?id=54251, which downloads vstor_redist.exe. I manually installed it and got another Visual Studio 2010 Tools for Office Runtime (x64).

What does it really want and where can I find it?