Install phpMyAdmin by CyanBlue
Install phpMyAdmin
by CyanBlue
 

Here are some screenshots of my phpMyAdmin installation process.

 
1. Download the phpMyAdmin program(phpMyAdmin-2.6.0-pl1.zip) from the http://www.phpmyadmin.net/home_page/downloads.php page.
2. Unzip the downloaded file(phpMyAdmin-2.6.0-pl1.zip) into the desired directory.
  Most of the times, we unzip the file into the IIS's main directory, C:\Inetpub\wwwroot, but I have unziped the file into the C:\L\phpMyAdmin directory. So, there is an additional step to go over to get it working properly.
3. IIS Tool
  3.01 Start - Control Panel - Administrative Tools - Internet Information Services
     
  3.02 Right click on the 'Default Web Site' and select New - Virtual Directory
     
  3.03 Virtual Directory Creation Wizard
     
  3.04 Virtual Directory Alias
    Type in the appropriate alias name you are going to call. I just said phpMyAdmin so that I can type http://localhost/phpMyAdmin/
     
  3.05 Web Site Content Directory
    Type in the directory where you have unziped the file. C:\L\phpMyAdmin in this case.
     
  3.06 Access Permissions
    The default value should be fine for phpMyAdmin.
     
  3.07 Wizard completed
     
4. Test.
  4.01 Open up the web browser and type this address.
    http://localhost/phpMyAdmin/
     
5. We are almost there. As you can see from the previous screnshot, there is a set of warning at the botttom of the page. That means that you need to set up some of the variables so that phpMyAdmin can work correctly.
    More information of this set up can be found in the Configuration section of this document.
http://localhost/phpMyAdmin/Documentation.html
    But roughly speaking, this is what I did in the phpMyAdmin page.
MySQL > Privileges > Add a new User
     
    and edited the config.inc.php file in the text editor.
     
  1. $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';
  2.  
  3. $cfg['Servers'][$i]['user'] = 'CyanBlue'; // MySQL user
  4. $cfg['Servers'][$i]['password'] = 'myPassword'; // MySQL password (only needed
 
Hope it was useful to you. :)
 

 

   |      |      |   Last Modified: July 17, 2009 @ 4:25 am