Configure the latest PHP and MYSQL Server Full version _ MySQL

Through one hour of research and setup. the latest PHP5.0 + MYSQL5.0 + WIN2003. I personally think it is necessary to write a tutorial. because many aspects are different from old versions. to be honest, I also read many official documents to solve many strange problems. MYSQL5.0FORWINDOWSPHP5.0FORWINDOWSPHPMYADMINWINDOWSSE through one hour of research and setup. the latest PHP 5.0 + MYSQL 5.0 + WIN2003.
I personally think it is necessary to write a tutorial because many aspects are different from those of the old version.
To be honest, I also read many official documents to solve many strange problems.
　　
MYSQL 5.0 FOR WINDOWS
PHP 5.0 FOR WINDOWS
PHPMYADMIN
Windows server 2003
　　
First install MYSQL. I thought the installation interface of the new version should be fancy.
But I still only see the old Earth dolphins. apart from the installation time being longer than 4.0. of course, because 5.0 is much larger than 4.0.
　　
We recommend that you install it on an independent NTFS partition. for example, you can only store the software on the F disk of my server.
Path: F: \ MYSQL
Then enter F: \ MYSQL \ BIN \ double-click winmysqladmin.exe
The first running will prompt you to enter the superuser and password. then enter the root password.
Note: If it is an external server, set it to super complex. for example, Wjwsfjn29szjwh ~ Mysql
My name is Wei Shufen. I am 29 years old and unmarried.
　　
Here, MYSQL installation is complete. if you do not understand it, please refer to the articles of deep space students.
　　
In the following example, PHP 5.0 is installed without installation. the decompression file is recommended in the path F: \ PHP.
The key steps should be taken here.
First, copy the PHP. ini-dist in the Php directory to C: \ Windows \ and change the file name to Php. ini.
　　
Copy f: \ PHP \ Php. ini-dist C: \ Windows
Ren Php. ini-dist Php. ini
　　
If WINDOWS 2000 is: C: \ WINNT, if it is WIN9X/2003, it is: C: \ Windows
Copy all the files in the DLLS directory under the PHP directory to the SYSTEM32 directory.
　　
Copy f: \ PHP \ dlls \ *. * C: \ Windows \ System32
If WINDOWS 2000 is: C: \ WINNT \ System32, if WIN9X/2003 is: C: \ Windows \ System32
Continue. copy the php4ts. dll file in the PHP directory to the System32 directory.
　　
Copy f: \ PHP \ php4ts. dll C: \ Windows \ System32
The copy operation is complete here. modify the C: \ Windows \ Php. ini file below.
　　
Note: version 5.0 and version 4.0 are not exactly the same. Note the following.
　　
Search for the extension_dir string. modify it to the extensions path in your PHP directory.
　　
; Directory in which the loadable extensions (modules) reside.
Extension_dir = F: \ PHP \ extensions
　　
What is different from PHP 4.0 is that you need to modify the following content in the Php. ini file:
Search for the cgi. force_redirect string. the default value is 1. change it to 0. and cancel the previous; number.
　　
That is:
　　
; Cgi. force_redirect is necessary to provide security running PHP as a CGI under
; Most web servers. Left undefined, PHP turns this on by default. You can
; Turn it off here AT YOUR OWN RISK
; ** You CAN safely turn this off for IIS, in fact, you MUST .**
Cgi. force_redirect = 0
　　
Remember the above modification. otherwise, PHP 5.0 cannot run. the following prompt will be displayed.
　　
Security Alert! The php cgi cannot be accessed directly.
　　
Official technical materials:
　　
! NOTE! : Since 4.1.2, the php. ini setting cgi. force_redirect defaults to '1' when tively prevents the cgi from working within IIS. You need to set
Up at least a minimal php. ini file with the following directive:
　　
Cgi. force_redirect = 0
　　
If it doesn't work immidiately, make sure you have the php. ini file in
Right place (% SYSTEMROOT % \ php. ini ).
　　
Next, modify the settings of MYSQL 5.0 in the Php. ini file.
　　
Find the content in the [MySQL] field. modify as follows.
　　
Mysql. default_port = 3306
// Here is the MYSQL port.
　　
Mysql. default_host = localhost
// Here is the local host.
　　
Mysql. default_user = root
// Here is the user
　　
Mysql. default_password = Wjwsfjn29szjwh ~ Mysql
// Here is the password
　　
After modification, you can associate Php with MYSQL.
Finally, start PHP to support the MYSQL module.
　　
Search for the extension = php_mysql.dll string. delete the previous string; No.
　　
Extension = php_mysql.dll
　　
Please note. if you do not start PHP to support the MYSQL module, PHPMYADMIN will not work properly. the following prompt will be displayed:
　　
Cannot load MySQL extension, please check PHP Configuration
Unable to Mount MySQL extension. Please check the PHP configuration.
　　
Official technical materials:
　　
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension ".
This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically.
Its name is probably mysql. so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
　　
There should be no major problems here. if you have a basic configuration, you can fully understand it.
I also encountered many problems during actual configuration. Finally, I patiently found the official documents and solved them.