Bug #86800 Mysql installer fails to detect Visual Studio
Submitted: 22 Jun 2017 18:52 Modified: 12 Feb 2018 18:21
Reporter: Ruth Berge Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S2 (Serious)
Version:5.7.18.1 OS:Windows (Windows 7 Professional 32 bit)
Assigned to: CPU Architecture:Any
Tags: mysql installer, Visual Studio

[22 Jun 2017 18:52] Ruth Berge
Description:
During the MySQL Install process, a window appears with warnings.  In that window it shows 
MySQL for Excel 1.3.6  ...Visual Studio Tools for Office 2010 is not installed...Status is empty
MySQL for Visual Studio 1.2.7...Visual Studio version 20212,2013 or 2017 must be installed...Status is "Manual"
Connector/Python (3.4) 2.1.6...Python 3.4 is not installed...Status is "Manual"

This is AFTER I deinstalled then reinstalled Visual Studio, making sure to select a 2017 version. I also installed and confirmed that I see (in my control panel programs) Python 3.4.

Note the link for Visual Studio Tools for Office 2010 https://www.microsoft.com/en-us/download/details.aspx?id=48217 doesn't say it supports Visual Studio 2017.  I decided to ignore this because the messages are are not helpful and I don't have an immediate need for this.
I have installed Microsoft Visual Studio Community 2017 Version 15.2.  
Some posts have mentioned a property file on older versions but all i have is an MSI file.  

Note I picked Serious.  Since I am new to this it seems like a severe loss of service.

How to repeat:
I simply run the MSI installer and it comes up with this error.  I have run it several times, after checking installs, deinstalling, reinstalling, etc.
[27 Jun 2017 8:16] Chiranjeevi Battula
Hello Ruth Berge,

Thank you for the bug report.
I could not repeat the issue at our end using with Windows Installer with 5.7.18.1 version.
It must be installed Visual Studio version 2012,2013 or 2017.
Pre requirements user manual:
https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html

Thanks,
Chiranjeevi.
[24 Aug 2017 7:27] Darragh Woods
Having exactly the same issue. Also running same OS. Have installed Python using the link provided in the MySQL installer, also installed visual studio 2017 even though I already had 2015 and the installer says that should have been sufficient. Tried re-booting after installing these and running the MYSQL installer again but issue is still occurring. Did anyone manage to resolve this?
[24 Aug 2017 10:14] Cam M
I have experienced this on my Windows 10 laptop. The installer cannot detect that I have Visual Studio 2017 installed. It worked with no problems on my PC so I tried manually installing the exact same VS components, but this made no difference. I can continue with the MySQL installation but I'm warned that some components will be left out because of the missing requirements. So I continue anyway to see what happens, but when adding connections in VS there is no MySQL server option.

Cam.
[28 Aug 2017 16:40] Ruth Berge
Hello and an update:
Chiranjeevi Battula replied that they could not repeat the issue and told me that I must have Visual Studio 2012,2013 or 2017.
I DID have Visual Studio 2017. I reported this in my original post. 

I have not tried this again but note that two other people have reported the same issue.

I hope that you take action to correct the problem.

Thanks.
[6 Sep 2017 2:04] Matthew Mills
I had the same problem. MySQL installer did not detect that I had installed Visual Studio. So I downloaded and installed the patch at this link https://dev.mysql.com/downloads/windows/visualstudio/ and then the MySQL installer was able to detect Visual Studio.
[7 Sep 2017 18:15] Warren Hunter
This is also an issue for me.  Same exact setup.  I have 2015 installed, but the MySql installer won't recognize it.
[20 Sep 2017 3:24] Kai Adams
Chiranjeevi Battula I have this issue as well.  Many people are still having this issue so perhaps you should consider acknowledging that it's a bug OR tell us how to fix it.
[28 Sep 2017 10:53] Ivaylo Manolov
Windows 10 Education. Same problem.
[7 Oct 2017 22:24] Jay Jaeger
Me to.  Windows 10 X64, Visual Studio 2017 Community 15.3.5.  What is status "Not a Bug"??
[15 Oct 2017 9:23] Jithin Eapen
Thanks Mathew Mills for the solution...The individual setup of Mysql for visual studio works..Hope the main MySql installer will be fixed soon.
[14 Nov 2017 19:06] Mike Urbasic
Still an issue for me.  I don't have \ don't need the full Visual Studio.

Have also tried to let installer fix the problem and I can see the install after clicking through to accept the visual studio 2010 terms.  I also attempted a manual installation of the 2010 tools.

Win7x64

The google tells me this has been an issue off and on for years.
[8 Feb 2018 18:32] Matthew Whitney
Problem has still not been resolved. Having the exact same problem.
[12 Feb 2018 18:21] Javier TreviƱo
This was already fixed on bug 88034 on MySQL Installer Version 1.4.21.
Please upgrade to the latest MySQL Installer version.
I changed the category of the bug to the right product.
[26 Apr 2020 20:54] Maitland young
MYSQL fails to recognise Visual Studio 2019, I have run both installers several times, uninstalled both programs, reinstalled, in different order.
I have searched on the net for solutions, so far nothing has worked.
I see that this is a long standing bug, please give me the fix.
Operating system Windows 10, MySQL 8.0.19.0