PHP + MySQL operations in win2000

The following article describes how to install PHP + MySQL in win2000. If you are a beginner in MySQL application, the following articles are of great significance to you. The following is a detailed description of the article.

Install PHP + MySQL in win2000

(Author: mikespook | Release Date: | views: 1063)

Keywords: win2000, php, MySQL, Installation

Preface:

This article is only intended to provide guidance to many cainiao like me. If you are a master or not interested in it. We recommend that you do not waste time here.

Take a look at the preparations before installation. First, you should have a computer with WIN2000 installed and IIS5 installed ). Next, you need to download the following software:

1. MySQL for Win: http://www.MySQL.com/Downloads/MySQL-3.23/MySQL-3.23.51-win.zip

2. PHP for Win: http://www.php.net/do_download.php? Download_file1_php-4.2.2-installer.exe

First, let's take a look at the installation of MySQL.

Decompress mysql-3.23.51-win.zip and run setup. Select the installation path. For example, I have installed d: \ MySQL. Then select the installation method. If you do not know what to install, select compact. Next, the installation and Installation Process of PHP + MySQL in win2000 is about 2 or 3.

After MySQL is installed, the configuration is as follows. Create a text file my. cnf in the root directory of the C drive. The content is as follows:

[MySQL]

Basedir = d:/MySQL/

Basedir is the path to install MySQL.

Then go to the d: \ MySQL \ bin directory under the command line and run the following command:

 
 

  
  
d:\MySQL\bin>MySQLd-nt --install   
  
  
d:\MySQL\bin>net start MySQL  
 
 

In this way, MySQL will be installed as a system service. If you want to stop MySQL services, you can use the net stop MySQL command. To delete MySQL from the system service, run the MySQLd-nt -- remove command.

Now, MySQL is running. You can use mysql.exe in the d: \ MySQL \ bindirectory to access the database to see the effect.

After installing MySQL, you can install PHP below. Run php-4.2.1-installer.exe and select "Advanced" when selecting the installation method ". Then select an installation path. Here I still install drive d: \ php \. Next, the system will first prompt you whether to create a backup file. When you want to delete the backup file, PHP can help you restore the original settings of the system. Here we choose Yes.

If you continue running, you will be prompted to create a temporary folder path for uploading files. Then the folder that prompts you to save the session data. Then configure the SMTP server and email. This setting will be used when you use the mail function of PHP in the future. Next again, prompting you about the details of the Error Report. It doesn't matter if you are playing by yourself. Select the first one. Detailed reports help you understand errors and make it easier to learn. Next, select the http server you are using based on your sub-configuration. If I am IIS5, select Microsoft IIS4 or higher.

Then there is the extension file name processed by PHP. If there are no special requirements, it will be enough by default. Now, you can click next to install PHP. Find the php. ini file in your windows directory after installation. My name is c: \ winnt \ php. ini. The annotations in this file are very detailed and there are many options to adjust. We only need to modify the following options.

 
 

  
  
extension_dir = d:\php\   
  
  
MySQL.default_port = 3306   
  
  
MySQL.default_host = localhost   
  
  
MySQL.default_user = root  
 
 

Restart IIS5 and create a file, such as information. php, In the IIS5 root directory. The content is as follows:

 
 

  
  
phpinfo();   
  
  
?> 
 
 

Then enter http: // 127.0.0.1/information. php In the browser to check it out? Haha detailed information about the server is displayed, more content than ASP probe. Now you can use PHP + MySQL on your server.

Maybe something is wrong because I am a cainiao. Some details may not be taken into consideration. If you know, you may wish to give me some advice. Thank you !!