Windows 2000/XP/2003 IIS+PHP+MySQL+Zend Optimize Installation Instructions

1. Software Preparation: The following are the latest official versions of PHP (5.1.2) as of 2005-4-20: http://Www.php.net

MySQL(5.0.19): http://www.mysql.com

Zend Optimizer (2.6.2): ​​http://www.zend.com

phpMyAdmin(2.8.0.2):http://www.phpmyadmin.net

Assuming C:\\ is the system disk of the operating system you are using now, if your current operating system is not installed At C:\\, please modify it yourself.

Second, install PHP:

(1) After downloading, get php-5.1.2-Win32.zip and extract it to C:\\php (this path can be free, but if you use it below) This path, please modify accordingly);

(2) Copy C:\\php\\libmysql.dll and C:\\Inetpub\\php\\ext\\php_mysql.dll to C:\\Windows\\system32;

(3) Copy C:\\PHP\\php.ini-dist to C:\\Windows (C:\\WINNT under Windows 2000) and rename it to php.ini, then open it with Notepad. Use Notepad's Find feature to search:

extension_dir = "C:\\PHP\\ext"point its path to the extensions directory in your PHP directory, for example: extension_dir = "C:\\Inetpub\\ Php\\ext" ;

Search; Windows Extensions only open the required modules to save memory (before removing each module; number can be):

extension=php_gd2.dllGD library support If you do not open the module, the Discuz! Forum image watermark cannot be used.

extension=php_mbstring.dll To support phpMyAdmin, open mbstring.

extension=php_mysql.dll Needless to say, support MySQL.

(4) Configure IIS to support PHP

You must first make sure that IIS is properly installed on your system. If it is not installed, you need to install IIS first.

PHP and IIS support both CGI and ISAPI modes. It is recommended to use ISAPI mode. Here is only the ISAPI mode installation method: ISAPI mode installation steps:

Select "Internet Service Manager" in the "Control Panel" in the "Control Panel", and then stop the service after opening IIS. Then, on the left side, you need to right-click on the PHP-supported Web site and select "Properties". In the "<;Web Site Properties" window that opens, click on the "ISAPI Filter" tab and click & click ; Add the & rdquo; button, in the pop-up "Filter Properties" window in the "Filter Name" column, enter: PHP, and then point the executable file to the path of php5isapi.dll, such as: C:\\PHP \\php5isapi.dll.

Open the “Web Site Properties” window“home directory” tab, find and click the “Configure” button, find and click &ldear in the pop-up "Application Configuration" window Add the ” button, add an extension mapping in the pop-up window, the extension is .php, click & browse; browse ” point the executable to the path of php5isapi.dll, such as: C:\\PHP\\php5isapi .dll, then all the way to determine.

Open the "Web Site Properties" window"documents" tab, find and click the "Add" button to add the index.php item to the default Web site startup document list. You can raise index.php to the highest priority so that when you visit a site, you first automatically find and open the index.php document.

Determine the application settings and execution permissions for the Web directory as pure scripts, then close the Internet Information Services Manager and execute the following command at a command prompt:

net stop w3svcnet stop iisadminnet Start w3svc

Then set the ISAPI extension in the "Internet Service Manager" on the left side of the "WEB Service Extension", Active Server Pages allows

to open the browser, type: http ://localhost/, after seeing the success page, create a new phpinfo.php in the IIS root directory with the following contents:

<?phpphpinfo();?>Open the browser and type: http: //localhost/phpinfo.php will display all the information about the PHP supported by the current server. You can see that the mode of the Server API is: ISAPI.

Three, install MySQL:

Download Windows Essentials (x86), double-click to install. Here I installed to C:\\MySQL, during the installation process will prompt you to configure immediately, select No to complete the installation. After the installation is complete, enter: C:\\MySQL\\bin\\mysqld-nt -install in the "Start" menu"Run" menu, enter the following command: net mysql start, the MySQL service will be started; If you want to configure MySQL in more detail, please go to the C:\\MySQL\\bin directory, run MySQLInstanceConfig.exe, and follow the prompts.

If you downloaded Windows (x86), double-click and execute Setup.exe after decompressing. The steps are the same as above.

If you downloaded the With installer (unzip in C:\\) and extracted it directly to C:\\MySQL, in the "Start” menu"Run” enter: C:\\MySQL\\ Bin\\mysqld-nt.exe, after running successfully, enter: net mysql start to start the MySQL service.

Set the password for MYSQL, ensure security: the general menu has the configuration wizard MySQL Server Instance Config Wizar, after running, follow the steps below to configure the ROOT password.

ROOT password, suggestion that the setting is complicated Point to make sure the server is safe!

You can also use the command configuration in the MySQL Command Line Client: first open the DOS window, then enter the directory mysqlbin, then type the command mysql -uroot -p, prompt you to lose the password after the carriage return, if you just installed MYSQL, super user root has no password, so you can enter MYSQL directly by pressing Enter. The prompt of MYSQL is: mysql>

Change password. Format: mysqladmin -u username -p old password password new password example: add a password to root xqin.com first enter the directory mysqlbin under DOS, then type the following command mysqladmin -uroot -password xqin.com Note: because root at the beginning There is no password, so the -p old password can be omitted.

Then execute: SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('xqin.com'); The command here is due to the password hash algorithm used by MySQL 4.1 and later versions of the authentication protocol. The client is not compatible. Login with the correct password in PHPMYADMIN will also prompt: Client does not support authentication protocol requestedby server; consider upgrading MySQL client is to prepare for the correct use of PHPMYADMIN later

This ROOT password is set For xqin.com

Fourth, install Zend Optimizer:

After downloading, get ZendOptimizer-2.6.2-Windows-i386.exe, double-click to install, you need to select the Web during the installation process. Server, select IIS, and then prompt you whether to restart Web Server, select Yes, prompt to back up php.ini before completing the installation, click OK and the installation is complete.

5. Install phpMyAdmin: Download phpMyAdmin-2.8.0.2.zip, extract it to the root directory of the site, find ./libraties/config.default.php and copy it to the phpMyAdmin root directory named config.inc .php , make the following changes:

Search for $cfg['PmaAbsoluteUri'], set your phpmyadmin URL, eg: $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; Note that phpmyadmin is required to search for $cfg['blowfish_secret'] in the root directory of the default site. After setting the root password, you should also fill in the ROOT password xqin.com and set it to $cfg['blowfish_secret'] = 'xqin. Com'; search for $cfg['DefaultLang'] and set it to zh-gb2312; search for $cfg['DefaultCharset'] and set it to gb2312; search for $cfg['Servers'][$i]['auth_type '], the default is config, is not safe, not recommended, it is recommended to use cookies, set it to $cfg['Servers'][$i]['auth_type'] = 'cookie'; Note here if set to config Please set your username and password below! For example: $cfg['Servers'][$i]['user'] = 'root'; //MySQL user-----MySQL connection user $cfg['Servers'][$i]['password' ] = 'xqin.com'; My profile is for reference only! Http://xqin.com/iis/config.inc.txtOpen the browser and type: http://localhost/phpMyAdmin/. If both IIS and MySQL are started, enter the user ROOT password xqin.com to browse the database contents. . The specific functions of phpMyAdmin, please familiarize yourself, no longer repeat them here. All the installations have been completed.