Apache VCL logo Apache Software Foundation logo

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.
  1. Download phpMyAdmin

    a. Check the version of PHP installed on the web server (you may need to perform step 1a of VCL 2.3.2 Web Code Installation to install httpd and php first):

        php -v
    • Use phpMyAdmin 2.x if the version of PHP is < 5.2:
      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.3.11 (cli) (built: May  8 2012 15:53:27)

    b. Download the appropriate version of phpMyAdmin from:

        http://www.phpmyadmin.net/home_page/downloads.php for 3.x series
        http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/ for 2.x series

  2. Extract the phpMyAdmin package:

    tar xf phpMyAdmin-
  3. Move the phpMyAdmin directory to the web server directory:

    mv phpMyAdmin- /var/www/html/phpmyadmin
  4. Follow the installation instructions in: /var/www/html/phpmyadmin/Documentation.txt

    The instructions must be followed in order to secure phpMyAdmin

    If you receive 403-Forbidden errors after installing phpMyAdmin, the problem is likely caused by SELinux. Run the following command to correct the problem:

    chcon -R -t httpd_sys_content_t /var/www/html/phpmyadmin

  5. Configure the phpMyAdmin-VCL Table relationships:

    After following the documentation on creating the phpMyAdmin Linked-tables infrastructure, you can set up the VCL table relationships. The phpmyadmin.sql file is provided in the mysql directory in the Apache VCL source code. It 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.

    Import the SQL file into the phpmyadmin database:

    mysql phpmyadmin < apache-VCL-2.3.2/mysql/phpmyadmin.sql