The IIS server is fully configured to implement asp, cgi, perl and php + mysqlIIS. now we need to make IIS implement the software required for ASP, CGI, PERL and PHP + MYSQL (both for ForWindows): ActivePerl, PHP, MYSQL 1. ASP support: Needless to say, there is no need to do anything, and it supports ASP operation. II. CGI and PERL support: 1. install ActiveP PerlIIS
Full configuration of IIS server for asp, cgi, perl and php + mysql
The IIS server is fully configured. now we need to implement ASP, CGI, PERL and PHP + MYSQL in IIS.
Required software (For Windows ):
ActivePerl, PHP, MYSQL
I. ASP support:
Needless to say, there is no need to do anything, and ASP is supported.
II. CGI and PERL support:
1. install ActivePerl
Run the downloaded ActivePerl and install it step by step (Note: Select/usr/in the root directory (perl by default). This saves a lot of trouble for future debugging programs)
2. configure IIS
Open "Internet information service" (in 'administrative tools') and click the properties of the default site ,:
Select the "main directory" tab and click "configuration (G)...". the dialog box is displayed.
Then "add (D)", for example:
We recommend "c: \ usr \ bin \ perl.exe". remember to add "% s" to the end. Otherwise, you cannot execute cgi. Add the extension. pl in the same way,
After completion
Now your IIS supports cgi and perl!
III. PHP and MYSQL support:
1. install PHP and MYSQL
Run the downloaded PHP and MYSQL to install them one by one (wherever installed). Currently, PHP has been installed and no programs are installed, you only need to extract the downloaded compressed package and put it under c: \ php)
2. PHP support:
2.1 Copy all files in the dlls folder under the php directory to c: \ windows \ system32
2.2 configure IIS: like cgi, Add. php as follows:
After completion, such:
Finally
Here the "execution permission" should be: "script and executable file" and then OK! Now your IIS fully supports PHP + MYSQL!
1. download the MySQL database (ODBC) driver and MySQL database system program
1. MySQL database (ODBC) driver: http://mysql.com/Downloads/MyODBC/myodbc-2.50.36-nt.zip, http://download.sourceforge.net/pub/mirrors/mysql/Downloads/MyODBC/myodbc-2.50.36-nt.zip or http://www.fykx.net/download/php/myodbc-2.50.36-nt.zip (1457KB)
2. the MySQL database system program is: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-win.zip (96 32 kB) or http://www.fykx.net/download/php/mysql-3.23.30-gamma-win.zip
II. program installation
1. install the MySQL database (ODBC) driver (required in Windows)
2. install the MySQL database system program. it is generally installed in the default system location "C: \ MySQL". however, consider whether your server is used as a network database server, if you want to create hundreds of database users on this server, you should install them on hard drive with large space to avoid unnecessary troubles and complicated settings in the future.
3. program startup
Run the "[system installation drive letter]: \ MySQL \ Bin \ winmysqladmin.exe" program to start the MySQL database system and manager. when the system is started for the first time, the "quick settings" window appears, you must create the first database user account, such. Enter the username of the first MySQL database account in User name, and enter the Password of the first MySQL database account in Password. remember the entered value and enter the MySQL database management window, after a while, the program automatically minimizes the window to the system bracket (there is a "traffic light" icon on the right of the taskbar ), the system has started properly (Windows2000 also needs to check whether "MySQL component service" in "component service manager" is started ). At this time, the program also adds a shortcut in the startup group. The next time you start the computer, the MySQL database system will be automatically started.
IV. database creation
When you start the database for the first time, the system automatically creates two databases named MySQL and test. you can use the following method to create a database named another one:
Right-click the System bracket "traffic light" icon >>> Click "Show me" to open the MySQL database management window >>> select the "Databases" tag >>> select database server >>right click click ==>> select "Create database" menu item >>> in the displayed add Database dialog box, type the database name) >>> Click Create the datebase to Create a new database. For example
V. Database User Account Management
The first time you start the database, you have created a database user account. if your server needs to be used by multiple users, you must create multiple database user accounts as follows:
Start "ODBC data Source Manager" ("ODBC data source manager" under WindowsNT system is in "administrative tools", "ODBC data source manager" under Windows98 or Me system is in "control panel) >>> Click "Add" in the first tag "user DSN" ==>> select "MySQL" in the data source driver list> Click "finish" =>> in the "database driver configuration" dialog box "Windows DSN name", enter "dynamic Education Network" (an account opened by dynamic Education Network ), enter the host Name or IP address of the server in MySQL host (name or IP), database Name in MySQL database name, and database account Name in User, enter the Password of the database account in the Password, and set the other to the default value >>> click "OK ". A new database account is created.
6. debug the program (take vBulletin Version 1.1.5 Chinese standard edition after the layout is beautified as an example)
1. modify the Admin/Config. php file as follows:
// Currently, only MySQL is supported
$ Dbservertype = "mysql ";
// Hostname or server ip address
$ Servername = "localhost ";
// Username and password used to log on to the database
$ Dbusername = "xiaozhang ";
$ Dbpassword = "123456 ";
// Database name
$ Dbname = "mysql ";
// Allows you to view/edit the password on the control panel
// 0 = invisible or edited
// 1 = invisible, but editable
// 2 = visible and editable
$ Pwdincp = 2;
?>
