How to Install phpMyAdmin 3.x.x on Windows XP Pro

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 47 languages.

1. Once you download the zip file, extract it into C:\Inetpub\wwwroot.
2. Here is the official phpMyAdmin istallation documentation for version 3.2.4: C:\Inetpub\wwwroot\phpMyAdmin-3.2.4-english\Documentation.html. Basically you will need to create a config.inc.php in the base directory, C:\Inetpub\wwwroot\phpMyAdmin-3.2.4-english. Here is what my config.inc.php looked like:
   1. <?php
      /*
      *
      * All directives are explained in Documentation.html and on phpMyAdmin
      * wiki <http://wiki.phpmyadmin.net>.
      *
      */

      $i=0;
      $i++;
      $cfg['Servers'][$i]['user'] = 'root';
      $cfg['Servers'][$i]['password'] = ''; // If you added a root password when you installed and configured MySQL
      $cfg['Servers'][$i]['auth_type'] = 'config';
      $cfg['Servers'][$i]['host'] = 'localhost';
      $cfg['Servers'][$i]['connect_type'] = 'tcp';
      $cfg['Servers'][$i]['compress'] = false;
      $cfg['Servers'][$i]['extension'] = 'mysql';
      $cfg['Servers'][$i]['AllowNoPassword'] = true;
      $cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
      $cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
      $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
      $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';
      $cfg['UploadDir'] = '';
      $cfg['SaveDir'] = '';
      ?>
      

3. To run it, in your browser, type http://localhost/phpMyAdmin-3.x.x-english/index.php (the file name may be different depending on the version of phpMyAdmin you downloaded)
4. You can add it to your favorites to be able to access it quickly

Previous | Next | Top