win2008 R2 Server php+mysql+sqlserver2008 Run environment configuration (from installation, optimization, security, etc.) _win server

win2008 R2 Installation

Http://www.jb51.net/article/38048.htm

Installation of IIS

Http://www.jb51.net/article/86390.htm

Installation Considerations for PHP:

Download non-thread version
Nts
PHP 5.2.17 http://www.jb51.net/softs/268745.html
Other versions can go to http://museum.php.net/php5/with many classic old versions.
PHP 5.5 (5.5.36) VC11 x64 Non Thread Safe
Http://windows.php.net/downloads/releases/php-5.5.36-Win32-VC11-x86.zip

Http://windows.php.net/downloads/releases/php-5.5.36-nts-Win32-VC11-x64.zip

PHP Configuration

Ignore_user_abort = on remove front;
Disable_functions =exec,system,passthru,popen,pclose,shell_exec,proc_open,dl,chmod
Disable_classes =dotnet,

Default_socket_timeout = 60
Error_log = "C:\Windows\Temp\php-5.2.17_errors.log"
Upload_tmp_dir = "C:\Windows\Temp\"
Cgi.force_redirect = 0
Cgi.fix_pathinfo = 1
Fastcgi.impersonate = 1
fastcgi.logging = 0

Extension=php_bz2.dll
Extension=php_curl.dll
; Extension=php_dba.dll
; Extension=php_dbase.dll
; Extension=php_exif.dll
; Extension=php_fdf.dll
Extension=php_gd2.dll
; Extension=php_gettext.dll
; Extension=php_gmp.dll
; Extension=php_ifx.dll
; Extension=php_imap.dll
; Extension=php_interbase.dll
; Extension=php_ldap.dll
Extension=php_mbstring.dll
Extension=php_mcrypt.dll
; Extension=php_mhash.dll
; Extension=php_mime_magic.dll
; Extension=php_ming.dll
Extension=php_msql.dll
Extension=php_mssql.dll
Extension=php_mysql.dll
Extension=php_mysqli.dll
; Extension=php_oci8.dll
; Extension=php_openssl.dll
Extension=php_pdo.dll
; Extension=php_pdo_firebird.dll
Extension=php_pdo_mssql.dll
Extension=php_pdo_mysql.dll
; Extension=php_pdo_oci.dll
; Extension=php_pdo_oci8.dll
Extension=php_pdo_odbc.dll
Extension=php_pdo_pgsql.dll
Extension=php_pdo_sqlite.dll
Extension=php_pgsql.dll
; Extension=php_pspell.dll
; Extension=php_shmop.dll
; Extension=php_snmp.dll
; Extension=php_soap.dll
; Extension=php_sockets.dll
Extension=php_sqlite.dll
; Extension=php_sybase_ct.dll
; Extension=php_tidy.dll
; Extension=php_xmlrpc.dll
; Extension=php_xsl.dll
Extension=php_zip.dll

MySQL Installation considerations:
MySQL installation can download the x64 bit, version 5.6. The decompression version of the installation is very simple
Mysqld-install
Unzip the downloaded MySQL to the specified directory (e.g., d:\mysql)
Installation Services
Entering at the command line
D:\mysql\bin\mysqld-install
net start MySQL
Uninstall Service
Entering at the command line
net stop MySQL
D:\mysql\bin\mysqld-remove

Security issue: MySQL runs with normal privileges. MySQL will be a few of the installation directory into MySQL ordinary users can read and write. Set MySQL running permissions in the service

Official installation version 32/64
Http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-community-5.6.31.0.msi

Zip Decompression version 32 bit
Http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.31-win32.zip

Zip Decompression version 64 bit

Http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.31-winx64.zip

Official website: http://dev.mysql.com/downloads/mysql/5.6.html

Installation Note implementation:
MySQL version 5.6 and above cannot be installed in the WIN2003 system and can only be installed in 2008 R2 and above versions. In fact, the use of decompression version of the installation is relatively simple.
Unzip the downloaded MySQL to the specified directory (e.g., d:\mysql)
Installation Services
Entering at the command line
D:\mysql\bin\mysqld-install
net start MySQL
Uninstall Service
Entering at the command line
net stop MySQL
D:\mysql\bin\mysqld-remove

MySQL 5.6 configuration optimization can refer to this article: http://www.jb51.net/article/84357.htm
mysql5.6 installation Version: http://www.jb51.net/article/86365.htm

SQL Server 2008 Installation method considerations:
IIS needs to check asp.net,. NET extensibility

Http://www.jb51.net/article/86395.htm

Wincache Installation Configuration method
Http://www.jb51.net/article/86197.htm
Win2008 R2 64Bit the way to install Memcache and memcached server in the IIS environment
Http://www.jb51.net/article/86204.htm

Wincache 32/x64 bit download address:

32-bit Wincache http://www.iis.net/downloads/microsoft/wincache-extension.

64-bit Wincache http://dev.freshsite.pl/php-accelerators/wincache.html.

Pseudo static

Http://www.iis.net/learn/extensions/url-rewrite-module/url-rewrite-module-configuration-reference?amp;clcid= 0x409

Http://www.iis.net/download/URLRewrite (English version)
https://www.microsoft.com/zh-CN/download/confirmation.aspx?id=7435 Chinese Version
https://www.microsoft.com/en-us/download/confirmation.aspx?id=43129 (Patch)

Http://www.jb51.net/article/43627.htm

IIS 7.5 suspended.

Http://www.jb51.net/article/73546.htm

iis7.5 optimization 10w

Http://www.jb51.net/article/36073.htm

The difference between the IIS7.5 application pool integration mode and the classic schema
Http://www.jb51.net/article/31010.htm

win2008 Server Security Reinforcement
Install the security dog to set up (it seems to be problematic after deletion)

Http://www.jb51.net/article/69567.htm
Http://www.jb51.net/article/69576.htm

Security settings

Win2008 R2 WEB Server Security Settings Guide modification 3389 ports and update patches
Http://www.jb51.net/article/86396.htm
Group Policy and user settings for the win2008 R2 WEB Server Security Settings Guide
Http://www.jb51.net/article/86400.htm
Win2008 R2 WEB Server Security Settings Guide folder permissions setting tips
Http://www.jb51.net/article/86402.htm
Win2008 R2 WEB Server Security Settings Guide for disabling unnecessary services and closing ports
Http://www.jb51.net/article/86408.htm

Windows Server 2008 R2 How to block an IP access through IP Security policy
Http://www.jb51.net/article/86271.htm

Prohibit script execution
Http://www.jb51.net/article/86201.htm

Install MySQL in win2008 R2 ODBC Connector installation Error
Http://www.jb51.net/article/86626.htm

Configure how the win2008 firewall allows ping to be set
Http://www.jb51.net/article/23569.htm
Http://www.jb51.net/article/86527.htm

Use McAfee policy to allow intruders to create user + cannot delete user + password cannot be changed setting method

Http://www.jb51.net/hack/39697.html

McAfee (mccafés) Antivirus rule setting method
Http://www.jb51.net/softjc/468585.html

McAfee 8.7i Detailed tutorials-including installation, setup, and rule writing (written in reference to the original mcafee85i tutorial)
Http://www.jb51.net/softjc/468585.html

Cloud Habitat Community small make up spend a few days to tidy up, be called win2008 Server configuration Manual.