How To Install IIS 7, PHP5 and MySQL 5.1 on Windows Server 2008 - Part 3

Now that we have installed PHP 5 on IIS 7 successfully, we’re going to install MySQL Server 5.1.

1. First of all, get yourself a copy of the MySQL Server 5.1 ZIP Setup from http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.22-rc-win32.zip/from/pick#mirrors
2. Extract all the files from the archive and launch Setup.exe
3. I’ve chosen to use the Typical Setup but feel free to customize the installation to suit your needs.
4. Once the installation is completed, leave the checkbox Configure the MySQL Server now checked and go through the Detailed Configuration.
5. I’ve selected Server Machine as the server type and Multifunctional Database usage but again set this as you prefer.
6. I’ve also left all the default settings until the Windows Options window where I’ve checked Include BIN directory in Windows Path.
7. Set the root password and you’re done.

Your MySQL Server should now be running. If you want to manage it, you can download and install the MySQL GUI Tools.

Configuring PHP5 to Access MySQL Server

1. Open c:\php\php.ini with your favorite text editor.
2. Uncomment the following lines by removing the semi-colon:extension=php_mysqli.dll
   extension=php_mbstring.dll
   extension=php_mcrypt.dll
3. Restart the IIS service: Start => Programs => Administrative Tools => Services => World Wide Web Publishing Service => Restart

If all went well, you should see the mysqli section on the PHP information page created earlier (http://your-server/phpinfo.php).

Bookmark It