Step 1: Install MySQL environment
Go to following link:
Download MSI package, and install MySQL Server by following default steps.
After MySQL Installation, SharePoint 2016, Central administration and all sites collection, stop working.
Investigating error in ULS logs show following error:
Application error when access /default.aspx, Error=The connection string name is missing for the MySqlSiteMapProvider
at MySql.Web.SiteMap.MySqlSiteMapProvider.Initialize(String name, NameValueCollection config)
at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
Central administration, has web site in IIS. Suppose your central administration pot is 39805, then your web site will be located at following location.
You have to add the following code to the web.config file :
<remove name=”MySqlSiteMapProvider” />
Similarly, for all web applications, in SharePoint, see the port of web application. For each web application, see the virtual directory as below.
Where XXX, is the port of web application of SharePoint environment.
After these web.config changes, Central administration and all site collection, starts working properly.
For details about POC , see the attached PDF. Step by Step Guide of BI Case Study of MYSQL via Visual Studio Code