1. Software preparation: The following are the latest official versions as of 2005-4-20
PHP (5.1.2): 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
assumes that C: is the system disk of the operating system you are currently using. If your current operating system is not installed in C:, please modify it yourself.
2. Install PHP:
(1) After downloading, get php-5.1.2-Win32.zip and unzip it to C:php (this path can be arbitrary, but if you use this path below, please modify it accordingly);
(2) Then Copy C:phplibmysql.dll and C:Inetpubphpextphp_mysql.dll to C:Windowssystem32;
(3) Copy C:PHPphp.ini-dist to C: Windows (C:WINNT under Windows 2000) and rename it to php.ini, then open it with Notepad and use the search function of Notepad to search:
extension_dir = "C:PHPext"
Point its path to the extensions directory in your PHP directory, for example: extension_dir = "C:Inetpubphpext";
Search; Windows Extensions and only open the required modules to save memory (remove the; before each module) number):
extension=php_gd2.dll
The GD library supports it. If this module is not turned on, Discuz! Forum picture watermark cannot be used.
extension=php_mbstring.dll
To support phpMyAdmin, turn on mbstring.
extension=php_mysql.dll
Needless to say, it supports MySQL.
(4) Configure IIS to support PHP.
First, you must make sure that IIS is correctly installed in the system. If it is not installed, you need to install IIS first.
When integrating PHP with IIS, it supports CGI and ISAPI modes. It is recommended to use ISAPI mode. Here we only introduce the ISAPI mode installation method: ISAPI mode installation steps:
Select "Internet Service Manager" in "Administrative Tools" in "Control Panel", open IIS and stop the service, then on the left "You need a Web that supports PHP" Right-click on the site and select "Properties", find and click the "Add" button in the "ISAPI Filter" tab of the "Web Site Properties" window that opens, and select "Filter Name" in the pop-up "Filter Properties" window. "Enter: PHP in the column, and then point the executable file to the path where php5isapi.dll is located, such as: C:PHPphp5isapi.dll.
Open the "Home Directory" tab of the "Web Site Properties" window, find and click "Configure" button, find and click the "Add" button in the pop-up "Application Configuration" window, add an extension mapping in the pop-up window with the extension .php, click "Browse" to point the executable file to php5isapi. dll, such as: C:PHPphp5isapi.dll, and then confirm it all the way.
Then open the "Document" tab of the "Web Site Properties" window, find and click the "Add" button to start the document to the default Web site. Add the index.php entry to the list. You can raise index.php to the highest priority so that the index.php document is automatically found and opened first when accessing the site.
Make sure that the Application Settings and Execution Permissions of the Web directory are selected. Pure script, then close the Internet Information Services Manager and execute the following command in the command prompt:
net stop w3svc
net stop iisadmin
net start w3svc
and then set ISAPI extension permission in "WEB Service Extension" on the left side of "Internet Service Manager", Active Server Pages permission
to open the browser, enter: http://localhost/ , after seeing the success page, in the IIS root Create a new phpinfo.php in the directory with the following content:
<?php
phpinfo();
?>
Open the browser and enter: http://localhost/phpinfo.php . All information about PHP supported by the current server will be displayed. You can see that the Server API mode is: ISAPI.
3. Install MySQL:
Download Windows Essentials (x86) and double-click to install it. Here I installed it to C:MySQL. During the installation process, you will be prompted whether you want to configure it immediately. Select No to complete the installation. After the installation is completed, enter: C:MySQLbinmysqld-nt -install in the "Run" of the "Start" menu. After the operation is successful, enter: net mysql start. The MySQL service will be started; if you still want to compare To configure MySQL in detail, please enter the C:MySQLbin directory, run MySQLInstanceConfig.exe, and follow the prompts.
If you downloaded Windows (x86), unzip it and double-click to execute Setup.exe. The steps are the same as above.
If you downloaded Without installer (unzip in C:), decompress it directly to C:MySQL, enter: C:MySQLbinmysqld-nt.exe in "Run" of the "Start" menu, and the operation is successful. Then enter: net mysql start to start the MySQL service.
Set a password for MYSQL to ensure security:
There is a configuration wizard MySQL Server Instance Config Wizar in the general menu. After running, follow the steps below to configure and set the ROOT password.
It is recommended that the ROOT password be more complex to ensure server security!
You can also use the command configuration in the MySQL Command Line Client:
First, open the DOS window, then enter the directory mysqlbin, and then type the command mysql -uroot -p. After pressing Enter, you will be prompted to enter your password. If MYSQL has just been installed, the super user root does not have a password, so you can enter directly by pressing Enter. MYSQL is logged in. The MYSQL prompt 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, and then type the following command
mysqladmin -uroot -password xqin.com
Note: Because root does not have a password at the beginning, the -p old password item can be omitted.
Then execute:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('xqin.com');
The command here is because the password hashing algorithm used in the verification protocol of MySQL 4.1 and later versions is incompatible with the old client. When logging in with the correct password in PHPMYADMIN, it will also prompt:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
So it is to prepare for the correct use of PHPMYADMIN later,
so that the ROOT password is set to xqin.com
4. Install Zend Optimizer:
After downloading, you will get ZendOptimizer-2.6.2-Windows-i386.exe, just double-click to install it. The installation process requires you When selecting Web Server, select IIS, and then you are prompted whether to Restart Web Server. Select Yes, and you are prompted whether to back up php.ini before completing the installation. Click OK to complete the installation.
5. Install phpMyAdmin:
Download phpMyAdmin-2.8.0.2.zip, unzip it to the site root directory, find ./libraties/config.default.php and copy it to the phpMyAdmin root directory and name it config.inc.php. Make the following modifications:
Search $cfg[ 'PmaAbsoluteUri'], set the URL of your phpmyadmin, such as: $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; Note that this assumes that phpmyadmin searches for $cfg['blowfish_secret in the root directory of the default site '], after setting the root password, you also need to fill it in here. For example, the ROOT password xqin.com is set to $cfg['blowfish_secret'] = 'xqin.com';
Search $cfg['DefaultLang'] and set it to zh-gb2312;
Search $cfg['DefaultCharset'] and set it to gb2312;
Search $cfg['Servers'][$i]['auth_type'], the default is config, which is unsafe and not recommended. It is recommended to use cookies and set it to $cfg['Servers'][$i][ 'auth_type'] = 'cookie';
Note that if it is set to config, please set the username and password below! For example:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user-----MySQL connection user
$cfg['Servers'][$i]['password'] = 'xqin.com';
My configuration file is for reference only!
http://xqin.com/iis/config.inc.txt
Open the browser and enter: http://localhost/phpMyAdmin/ . If IIS and MySQL are both started, enter the user ROOT password xqin.com to browse the database content.
Please slowly familiarize yourself with the specific functions of phpMyAdmin and will not go into details here.
At this point all installation is completed.