What is introduced here is a practical Raiders for the installation and debugging of this Site Forum PHPWIND BOARD V1.0.0. The configuration of the PHP MYSQL environment is applicable to any equivalent environmental requirements. You can also use this PHP MySQL environment to install other PHP Forum phpwind has free download in the official forum
http://www.phpwind.net/
Configuring php4.x mysql4.x in the Windows 2000 Environment IIS5.0 Environment Not necessarily clearing some friends who have just contacted this unclear to write a installation method to leave the experience to the next needs and first contact PHP and SQL Newcomer only
Let IIS5.0 support PHP - => PHP4.x installation
The first step is to unpack the PHP-4.3.6-win32.zip compression package, you can put it below D: / PHP, of course, can also be placed in the C drive partition.
Step 2, copy the php.ini-dist file below D: / PHP to the C: / Winnt directory, and rename it into php.ini. You don't need to modify any parameters, you can run, of course you can modify certain parameters according to different situations. (First, we need to inform PHP where to find its extended function module file.
Change the C: /Winnt/php.ini file below. You need to pay attention to:
Find an Extension_Dir string. Modify the path to Extensions in your php directory.
Directory In Which The Loadable Extensions (Modules) Reside.
EXTENSION_DIR = "D: / PHP"
This example can be set to "extension_dir = d: / php" as set to the PHP file. )
Step 3, copy D: /PHP/PHP4TS.DLL to the C: / WinNT / System32 directory.
Step 4, Control Silver - "Management Tool -" Internet Service Manager - "Find" Default Web Site "
Step 5, Take the "ISAPI Filter" tab on the Default Web Site Properties window, click the "Add" button, enter "PHP" in the Filter Name of the "Filter Properties" window of the "Filter Properties" window. " Browse "D: /PHP/SAPI/php4isapi.dll" in the Executable File, determined.
In the sixth step, press the "Main Directory" tab on the Default Web Site Properties window, click the "Configure" button. Tap the "Add" button in the pop-up "Application Configuration" window, add / edit Enter "D: / Phhp/SAPI/php4isapi.dll" in the "D: /PHP /PI/php4isapi.dll" in the "D: /PHPI/php4isapi.dll" in the "D:" text box (attention must have that Point) and check "Check if the file exists" item. OK.
Step 7, go to the start ----- Run - Menu window, enter the "Net Stop iisadmin" command, and click OK to terminate the IIS service. The system will ask if you want to stop the relevant services, answered.
Step 8, enter the "NET START W3SVC" command to determine the IIS service.
In the sameby, check the main directory execution permit as pure script, see "Isapi Filter", PHP turns into green upward arrows, prove PHP has been loaded. Your server has supported PHP.
In the ninth step, Today, the Mysql installation is actually the simplest is this compressed file package mysql-4.0.18-win.zip, and then run the installer to press OK to be installed to the C drive Some troublesome settings. Follow the mysql folder under the C drive, run bin / winmysqladmin.exe launch MySQL for the first time, the interface name and password that need to enter the account and password will be filled with your joy and determine it. It is the installation of MySQL installation. Chapter 10, the installation of the Forum: Key to and the Mysql database connection is lost, so pay attention to Mysql's super administrator password is empty account name to root is not to fill the first time I set my own account and password. Otherwise, the Connection Fail Forum cannot be installed. This step forum has been installed, and you will see how you manage it later.
Step 11, configure the mysql database: Some default values for data must be modified, such as passwords.
(1) Connect MySQL:
Format: mysql -h host address -u username -P user password
1, Example 1: Connect to MySQL on the unit.
First open the DOS window, then enter the directory c: / mysql / bin, then type the command mysql -uroot -p, then press you after entering you, if you just install MySQL, Super User root is no password, so directly The car can enter mysql, MySQL prompts are: mysql>
2, Example 2: Connect to MySQL on the remote host. Suppose the IP of the remote host is: 110.110.110.110, the username is root, the password is ABCD123. Type the following command:
mysql -h110.110.110.110 -uroot -Pabcd123
(Note: u and root do not have to bind the body, others are the same)
3, exit mysql command: exit (Enter)
(2) Modify password:
Format: mysqladmin -u username -P old password Password new password
1, Example 1: Add a password to the root AB12. First enter the directory C: / MySQL / BIN under DOS, then type the following command
MySQLADMIN -UROOT -PASSWORD AB12
Note: Because the root does not have a password, the -p old password can be omitted.
2, Example 2: Change the root password to DJG345.
mysqladmin -uroot -Pab12 Password DJG345
(3) Increase new users: (Note: Different from the above, because it is the command in the mysql environment, then take a semicolon as the end of the command)
Format: Grant SELECT ON Database. * To Username @ Login Host Identified by "Password"
Example 1. Add a user TEST1 password to ABC, allowing him to log in on any host and have the permissions of all databases, insert, modify, delete. First, use the root user into MySQL, then type the following command:
Grant SELECT, INSERT, UPDATE, DELETE ON *. * to Test1 @ "%" Identified by "ABC";
However, the user of Example 1 is very dangerous. You want someone to know the password of Test1, then he can log in to your MySQL database on any computer on the Internet and to your data for what you want, solution. See Example 2.
Example 2, add a user TEST2 password to ABC, let him log in in localhost, and can query, insert, modify, and delete the database MYDB (localhost refers to the host host, the host where the mysql database is located) In this way, users can use the password that knows Test2, he cannot access the database directly on the Internet, and can only access the web page on the MySQL host. Grant SELECT, INSERT, UPDATE, DELETE ON MYDB. * to Test2 @ localhost iDentified by "abc";
If you don't want Test2 with a password, you can make a command to remove the password.
Grant SELECT, INSERT, UPDATE, DELETE ON MYDB. * To Test2 @ localhost iDentified by ""
(4) Display command
1. Display the database list:
Show databases;
Two databases are just started: mysql and test. The mysql library is very important that there is a MySQL system information, we change your password and add users, actually use this library to operate.
2, display the data table in the library:
Use mysql; // Open the library, I will not be unfamiliar with FoxBase.
Show table;
3, display the structure of the data sheet:
DESCRIBE table;
4, build the library:
CREATE DATABASE library name;
5, build the table:
USE library name;
CREATE TABLE Name (Field Settings List);
6, delete libraries and deleted forms:
DROP DATABASE library name;
DROP TABLE table name;
7. Record the table in the table:
DELETE FROM table name;
8, the record in the display:
SELECT * FROM table name;
