Discuz Windows Deployment configuration PHP mysql

discuz! X is a PHP programming language, MySQL as a database, and the use of Apache/iis/nginx (any one can) provide Web services products. To build discuz! X site, the server must have an environment consisting of PHP, MySQL, and Apache/iis/nginx. Where IIS is primarily used for Windows servers, Apache and Nginx are used for Linux servers (i.e. LAMP and LNMP)

The following is an example of deploying IIS, MySQL, and PHP on a Windows server to demonstrate the specific process of setting up an environment.

System Conventions

Environment software storage location after download	X:\Server_Tools
Environment Software Installation Location	X:\Server_Core
PHP Installation Location	X:\Server_Core\PHP
MySQL Installation location	X:\Server_Core\MySQL
Zend Optimizer Mounting position	X:\Server_Core\Zend
IIS Web site site root directory	X:\wwwroot
MySQL Database Location	X:\Database
PHP.ini Storage Location	Y:\Windows\php.ini
My.ini Storage Location	X:\Server_Core\MySQL\my.ini

Note: x and Y are variables in this standard, and x represents only the partition letter that the application actually holds, installs, and y is the partition letter of the system.

=======================================================================================================

Download all the software in the Server_tools folder:

mysql-5.5.19-win32.msi	http:/ /dev.mysql.com/downloads/
php-5.2.17-win32.zip td>	http://php.net/downloads.php
zendoptimizer-3.3.3-windows-i386.exe	http://www.zend.com/en/ Products/guard/zend-optimizer
	http://www.phpmyadmin.net/ home_page/downloads.php

Note: PHP version select 5.2.x, the smaller version number is better, temporarily do not use PHP5.3 version, no special reason, do not use PHP4, PHP officially no longer provide PHP4 support , MySQL version Choose 5.5.x, small version number of the new better, There are no special reasons to use other versions. PHP try to use a non-installed green version, MySQL try to use the installation version.

=======================================================================================================

Installing MySQL1, installing software

Enter the X:\Server_Tools directory, double-click Mysql-5.5.19-win32.msi;

Select Custom Installation

Click "Change" to make changes to the MySQL installation directory

After the file copy is installed, proceed to the MySQL Setup screen and click Finish.

Select detailed configuration for detailed configurations

Select MySQL Run mode: Server machine

Select the default storage mode for MySQL database: Non-trans only (MYISAM)

Set MySQL Maximum connection number: An integer that is generally set to 128-512.

Set MySQL network parameters, note: Do not tick enable Strict mode! The Addfirewall option is only checked when it needs to be connected to MySQL, that is, a strategy for adding a station to the firewall.

Set MySQL default Character set: The user site language, the default we fill GBK.

Windows Environment settings

To change the root password, please set it more complicated.

Note: Do not start the remote connection mode if it is not necessary! Complete the MySQL installation and start the MySQL service.

2, test MySQL work is normal

Open cmd Command Prompt window, enter command: Mysql–u root–p

When you enter the password you just installed, if you can enter the MySQL console correctly, the MySQL installation is normal.

3. Change the MySQL database storage directory

Open the cmd Command Prompt window and enter the command: net stop MySQL to stop the MySQL service running;

== "X:\Database" copies the X:\Server_Core\MySQL\data folder to X:\ and renames the X:\Database; open the cmd Command Prompt window and enter the command: NET start MySQL starts the MySQL service. Re-test if MySQL is working properly. 

4, mobile libmysql dynamic link library to the system directory

Copy the X:\Server_Core\MySQL\bin\libmySQL.dll file to the Y:\Windows\System32 directory. (X64 operating system Syswow64 also put one)

=======================================================================

Install PHP1 , unzip and unzip the downloaded PHP-5.2.8-win32.zip file and copy it to: X:\Server_Core\PHP;2 , modify php.ini into X:\Server_Core\PHP folder, will php.ini-Dist renamed to PHP.ini; open php.ini file, found: Extension_dir="./"change it to:extension_dir = "X:\Server_Core\PHP\ext" found:Windows Extensions in the dynamic module configuration under Windows Extensions, you need to open the following module support: (Remove the semicolon in front of each line of the module configuration) php_gd2.dllphp_ Mbstring.dllphp_mcrypt.dllphp_mhash.dllphp_ming.dllphp_mysql.dll
php_mysqli.dllphp_openssl.dllphp_sockets.dllphp_xmlrpc.dllphp_zip.dll found:disable_functions =instead: Disable_functions=Passthru,exec,system,chroot,scandir,chgrp,chown,shell_exec,proc_open,proc_get_status,ini_alter,ini_alter, Ini_restore,dl,pfsockopen,openlog,syslog,readlink,symlink,popepassthru,stream_socket_server Save php.ini file, and copy it to Y:\Windows 

Discuz Windows Deployment configuration PHP mysql