Installing PHPMyAdmin on Windows XP Pro 1

 

 

 

What do we have in this session 1?

  1. Pre requirements

  2. Configuring IIS 6.0 Web Server

-----------------------------------------------

  1. Creating the PHPMyAdmin Config File

  2. phpmyadmin Configuration Storage (MySQL)

  3. Creating a Controluser

  4. More Controluser Permission Assignments

  5. Establishing the Database Connection

  6. Testing Logging to PHPMyAdmin

  7. Configuration for PHP v5

  8. More Advanced Settings

  9. The Non root Login

 

Pre requirements

 

The requirements to install phpmyadmin on IIS web server and Windows XP Pro for this session are listed in the following table.

 

Web server

IIS already configured successfully on Windows XP Pro and .PHP extension has been mapped.

PHP

PHP already configured successfully.

You need PHP 5.2.0 or newer, with session support and the Standard PHP Library (SPL) extension.

To support uploading of ZIP files, you need the PHP zip extension.

For proper support of multibyte strings (eg. UTF-8, which is currently default), you should install mbstring and ctype extensions.

You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio. When using the "cookie" authentication method, the mcrypt extension is strongly suggested for most users and is required for 64 bit machines. Not using mcrypt will cause phpmyadmin to load pages significantly slower.

To support upload progress bars, please see FAQ 2.9.

MySQL

5.0 or newer and already configured successfully.

Web browser

With cookies enabled.

 

In this tutorial session we'll place the phpmyadmin files in a directory called 'phpmyadmin' under the web root directory of a localhost website. In the real implementation, the localhost should be replaced by the registered domain name. Because phpmyadmin enables you to directly manipulate, and even delete entire databases and users, it is highly recommended that you secure your phpmyadmin installation using SSL. This can be done by purchasing a certificate from a third party vendor with some cost or by creating a self signed certificate for IIS web server (IIS server) yourself at no cost. The following steps try to demonstrate how to configure IIS web server on Windows XP Pro.

 

Firstly, please download phpmyadmin ZIP file from phpmyadmin.net. Create a directory 'phpmyadmin' under the web root directory (C:\Inetpub\wwwroot) with all small letters. Uncompress or put all the phpmyadmin files and folders under 'phpmyadmin' folder just created.

 

The phpmyadmin uncompressed files and folders under the web root folder

 

Configuring IIS 6.0 Web Server

 

In order to configure IIS, do the following steps:

 

a.    Firstly, open IIS Webserver from Start > Run: inetmgr (or Start > All Programs > Administrative Tools > Internet Information Services).

 

Launching the IIS from command line - inetmgr

 

 

b.    In IIS manager expand SERVER_NAME > Web Sites and select Default Web Site.

 

The IIS default web site

 

c.    In the Right pane right click in white space and select New > Virtual Directory (or select the Default Web Site > right click > New > Virtual Directory).

 

Creating new IIS virtual directory and alias name

 

d.    In the Virtual Directory creation Wizard welcome page, click Next.

 

IIS virtual directory creation wizard welcome page

 

e.    Give a directory Alias (name) as phpmyadmin (this is a logical name recognized by IIS and in this case we use similar directory name for physical and logical) and click Next.

 

Creating an IIS alias name

 

f.     Click on Browse button and navigate to "C:\Inetpub\wwwroot\phpmyadmin"

 

 

 

 

 

 

--------------------------------------------------------------------

The IIS physical directory created on the local web server

 

g.    Select "Read", "Run Script (such as ASP)" & "Execute (such as ISAPI applications or CGI)" and click Next.

 

Setting IIS virtual directory access permission

 

The IIS virtual directory creation wizard completion page

 

The IIS virtual directory seen through IIS snap in

 

h.    Now Right click on the phpmyadmin virtual directory, select All Tasks and then Permission Wizard.

 

i.      Give "Read & Execute" permissions to IUSR_xxxxx and inherit the permissions.

 

Setting the IIS virtual directory permission using wizard

 

 

 

 

The IIS permission wizard welcome page

 

The IIS permission wizard setting - inheriting all the parent security settings

 

If you encounter the following message, you may want to fix the parent node first (Default Web Site). Else, just click Yes.

 

The message of explicit Access Permission parent node doesn't have any

 

Setting the IIS directory and file permission using IIS permission wizard

 

The IIS permission wizard summary setting

 

The IIS permission settings were completed successfully

 

j.      Right click on the phpmyadmin virtual directory > Properties > Virtual Directory > Configuration button and map .php extension to PHP executable.

 

 

 

 

 

 

Invoking the IIS virtual directory properties page

 

Invoking the IIS virtual directory configuration page

 

Addinh .PHP extension to the IIS mapping so that IIS can understand PHP files

 

In this case we select All Verbs for the Verbs. You may want to limit to GET, HEAD, POST only. Click OK.

 

The IIS .PHP extension settings

 

The PHP extension was added successfully to IIS server

 

Many people have difficulty understanding the concept of user management with regards to phpmyadmin. When a user logs in to phpmyadmin, that username and password are passed directly to MySQL. phpmyadmin does not do the account management on its own (other than allowing one to manipulate the MySQL user account information); all users must be valid MySQL users.

 

 

 

 

< Java and Opensource Friends | PHPMyAdmin 2 >

 

 

 

 

PHPMyAdmin 1 | PHPMyAdmin 2 | PHPMyAdmin 3 | PHPMyAdmin 4 | PHPMyAdmin 5 | PHPMyAdmin 6 | PHPMyAdmin 7 | Java and Opensource Friends