2.2 phpMyAdmin Installation & Configuration

phpMyAdmin is a free and optional tool which allows MySQL to be administered using a web browser. It makes administering the VCL database easier. This tool can be installed on the VCL web server.

Download phpMyAdmin

1. Check the version of PHP installed on the web server: php -v
   Use phpMyAdmin 2.x if the version of PHP is 3.x or 4.x:

   PHP 4.3.2 (cgi), Copyright (c) 1997-2003 The PHP Group

   Use phpMyAdmin 3.x if the version of PHP is 5.x:

   PHP 5.1.6 (cli) (built: Jul 16 2008 19:52:52)

2. Download the appropriate version of phpMyAdmin from: http://www.phpmyadmin.net/home_page/downloads.php
3. Extract the phpMyAdmin package:
   tar -xzf phpMyAdmin-2.11.9.6-all-languages-utf-8-only.tar.gz
4. Move the phpMyAdmin directory to the web server directory:
   

   mv phpMyAdmin-2.11.9.6-all-languages-utf-8-only /var/www/html/phpmyadmin

5. Follow the installation instructions in: /var/www/html/phpmyadmin/Documentation.txt
   IMPORTANT: the instructions must be followed in order to secure phpMyAdmin

Configure VCL Table Relationships

An SQL file is provided which will add entries to the pma_table_info table in the phpmyadmin database. These entries cause corresponding information to be displayed when you hover over a value in the VCL database.http://152.46.17.139/phpmyadmin/tbl_structure.php?db=phpmyadmin&table=pma_table_info&token=400c0bde21942dbd89e5d699621fe692

1. Download the following file:
   *wget http://svn.apache.org/repos/asf/vcl/trunk/mysql/phpmyadmin.sql*
2. Import the SQL file into the phpmyadmin database:
   mysql phpmyadmin < phpmyadmin.sql