win2016 Configure IIS and mysql5.7 to migrate data tables in two pits

Today, all day, IIS has been installed all day, there is no way to install. net3.5 problem.

Final Solution: Https://help.aliyun.com/knowledge_detail/38203.html?spm=5176.7842557.2.14.3D80U7

1. Open PowerShell with administrator status

2. Enter:

Set-itemproperty-path ' Hklm:\software\policies\microsoft\windows\windowsupdate\au '-Name usewuserver-value 0 Restart-service-name wuauserv install-windowsfeature net-framework-core set-itemproperty-path ' HKLM:\SOFTWARE\ Policies\microsoft\windows\windowsupdate\au '-name usewuserver-value 1 restart-service-name wuauserv

Wait for the installation to finish. IIS can be installed.

The steps to modify the location of the MySQL database physical file are as follows: http://www.pressc.cn/?p=732

1. Before modifying, stop the MySQL service first;
2. Copy the contents of the "Data" directory under "C:\ProgramData\MySQL\MySQL Server 5.7\" to the location where it needs to be stored;
3. Modify "My.ini" to Change "DataDir" to the folder where the database is currently stored, such as "Datadir=d:\mysql\data";
4. Restart the MySQL service.

Fix unable to start issue after modifying DataDir path

If you cannot start the problem after datadir the path in the Windows system, error 1067 errors, you can use the following methods to resolve:

Right-click on the newly created Data folder, select Properties, Security, and add the Network Service to the group and user (G).

　　

win2016 Configure IIS and mysql5.7 to migrate data tables in two pits