Configuring Php5+mysql+phpmyadmin_win servers in an IIS environment

First, describe the configuration environment:
Operating system: Windows 2003 Standard SP2
PHP Version: 5.2.5
MySQL version: 5
phpmyadmin:2.11.6
First, configure IIS to add a new server extension

Enter the path to the Phpisapi.dll file and set the extension status to allow:

Second, set the site properties, the home directory for the PHP site is the folder


Enter the path to the Phpisapi.dll file, note that some PHP sites need to "confirm the existence of the file" this option to remove the extension write. php:

PHP is now ready to run in IIS. Write a PHP test file 1.php, which reads as follows:
?
Phpinfo ();
?>
Open this page in the browser, as shown in the figure:


Third, the configuration of MySQL, first write a MySQL configuration file, where my profile for My.ini, the document in the comments have been very clear, here will not say more.


Install MySQL service, switch to the Mysql\bin directory, execute the following commands, install and start the MySQL service, note that the My.ini configuration file path to write accurate


Five, Next, configure PHP5 support MySQL, first modify the PHP folder under the Php.ini-dist file, modified to php.ini, with Notepad open, find MySQL options, put the front;

Then copy the Libmysql.dll under the Php_mysql.dll and PHP folders under the Php\ext folder to the C:\Windows\System32 folder:



Then open our test page, this time, should be able to see the following, indicating that the MySQL has been enabled:



Six, the final configuration phpmyadmin, copy phpMyAdmin to the site root directory, modify phpMyAdmin config.inc.php file, note the contents of red notes
$cfg [' Servers '] [$i] [' host '] = ' localhost '; // MySQL server name or IP address
$cfg [' Servers '] [$i] [' port '] = '; MySQL service port, empty here means use default port
$cfg [' Servers '] [$i] [' socket '] = '; Path to the Socket-leave blank for default socket
$cfg [' Servers '] [$i] [' connect_type '] = ' TCP '; How to connect to MySQL server (' TCP ' or ' socket ')
$cfg [' Servers '] [$i] [' extension '] = ' mysql '; //MySQL Extensions
$cfg [' Servers '] [$i] [' compress '] = FALSE; Use compressed protocol for the MySQL connection
$cfg [' Servers '] [$i] [' controluser '] = '; MySQL Control user Settings
(This user must have Read-only
$cfg [' Servers '] [$i] [' controlpass '] = '; Access to the "Mysql/user"
and "mysql/db" tables).
The Controluser is also
Used for all relational
Features (PMADB)
$cfg [' Servers '] [$i] [' auth_type '] = ' config '; // authentication Mode (config, HTTP or cookie based)
$cfg [' Servers '] [$i] [' User ']           = ' root ';     // username, here using root
$cfg [' Servers '] [$i] [' Password ' ]      = ';         // password, first used, also blank, After you change the MySQL root password, and then modify the

Save, if you can open the following page with a browser, you can use phpMyAdmin to manage MySQL.