win2008 r2 server php+mysql+sqlserver2008 operating environment configuration (from installation optimization security etc.)

win2008 r2 installation

//www.ofstack.com/article/38048.htm

The installation of iis

//www.ofstack.com/article/86390.htm

Notes for installation of php:

Download the non-safe thread version
nts
php 5.2.17 //www.ofstack.com/softs/268745.html
Other versions to http: / / museum php. net php5 / inside a lot of the old version of the classic.
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;
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

Notes for installation of mysql:
For the installation of mysql, you can download x 64-bit, version 5.6. The unzipped version is very easy to install
mysqld -install
Unzip the downloaded mysql to the specified directory (e.g. d:\mysql)
Installation services
Type on the command line
d:\mysql\bin\mysqld -install
net start mysql
Unloading service
Type on the command line
net stop mysql
d:\mysql\bin\mysqld -remove

Security issues: mysql runs with normal permissions. Make all of mysql's installation directories mysql normal user read-write. Set mysql run permissions in the service

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

zip extract 32-bit
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.31-win32.zip

zip extract 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 # downloads

Installation attention:
mysql 5.6 and above cannot be installed on the win2003 system, but only on 2008 r2 and above. In fact, the unzipped version of the installation is also relatively simple to use.
Unzip the downloaded mysql to the specified directory (e.g. d:\mysql)
Installation services
Type on the command line
d:\mysql\bin\mysqld -install
net start mysql
Unloading service
Type on the command line
net stop mysql
d:\mysql\bin\mysqld -remove

mysql configuration optimization can refer to this article 5.6: / / www ofstack. com article / 84357. htm
mysql5. 6 installed version: / / www ofstack. com article / 86365. htm

Notes for installation method of sqlserver 2008:
For iis, check asp.net,.net extensibility

//www.ofstack.com/article/86395.htm

wincache installation configuration method
//www.ofstack.com/article/86197.htm
Win2008 R2 64Bit IIS environment method for installing memcache and memcached servers
//www.ofstack.com/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 & # 63; id = 7435 Chinese version
https: / / www. microsoft. com/en - us/download/confirmation aspx & # 63; id=43129 (patch)

//www.ofstack.com/article/43627.htm

iis 7.5 feign death

//www.ofstack.com/article/73546.htm

10 w iis7. 5 optimization

//www.ofstack.com/article/36073.htm

The difference between the application pool integration pattern and the classic pattern
//www.ofstack.com/article/31010.htm

win2008 server security reinforcement
Install safety dog for setting (it seems to be easy to have problems after deleting)

//www.ofstack.com/article/69567.htm
//www.ofstack.com/article/69576.htm

Security Settings

Win2008 R2 WEB server security setup guide to modify port 3389 and update the patch
//www.ofstack.com/article/86396.htm
Group policy and user Settings for win2008 R2 WEB server security Settings guide
//www.ofstack.com/article/86400.htm
Win2008 R2 WEB server security Settings guide to folder permissions setting tips
//www.ofstack.com/article/86402.htm
Win2008 R2 WEB server security Settings guide to disable unnecessary services and close ports
//www.ofstack.com/article/86408.htm

Windows Server 2008 R2 prevents certain Settings from being accessed by IP via the IP security policy
//www.ofstack.com/article/86271.htm

Disable script execution
//www.ofstack.com/article/86201.htm

win2008 R2 has an ODBC connector installation error installing MySQL
//www.ofstack.com/article/86626.htm

Configure the win2008 firewall to allow the Ping setup method
//www.ofstack.com/article/23569.htm
//www.ofstack.com/article/86527.htm

Using the McAfee policy, an intruder cannot create user + cannot delete user + cannot change password Settings

//www.ofstack.com/hack/39697.html

McAfee(McCafe) antivirus rule setting method
//www.ofstack.com/softjc/468585.html

McAfee 8.7i detailed tutorial -- including installation, setup, and rule writing (refer to the original McAfee85i tutorial)
//www.ofstack.com/softjc/468585.html

This site this site took a few days to put together, can be called win2008 server configuration manual.