Installing phpMyAdmin

9/26/07- Christopher upgraded from phpMyAdmin 2.10.3 to 2.11.1 because 2.10.3 had messages in php.err like:
Function mysql_list_tables() is deprecated in
 /export/home/www/php/mysql/left.php on line 299


% cd /home/www/php

% mv mysql mysql.bak

Download phpMyAdmin from http://www.phpmyadmin.net

cd /export/home/tools/downloads
wget http://superb-west.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.2.0-all-languages.tar.gz

& unpack into /home/www/php/phpMyAdmin-3.3.8.1-all-languages:

cd ~www/php
gtar -zxf /export/home/tools/downloads/phpMyAdmin-3.3.8.1-all-languages.tar.gz
ln -s phpMyAdmin-3.3.8.1-all-languages mysql

Copy ~www/php/util/gsrc_user_check.php into the phyMyAdmin directory.
If you are upgrading, then copy from the previous phpMyAdmin directory. The file is reproduced below:

    <?php
    //
    // Verify that the current user is logged into the GSRC website, and has
    // required permissions to access phpMyAdmin.
    //
    // $Id$
    //

    require_once('include/group.inc.php');
    require_once('include/mail.inc.php');
    require_once('include/sql.inc.php');
    require_once('include/user.inc.php');
    require_once("${_SERVER['SERVER_NAME']}/layout/html.inc.php");
    require_once('include/access.inc.php');
    require_once('include/util.inc.php');
    require_once('include/auth.inc.php');
    require_once("${_SERVER['SERVER_NAME']}/config.php");

    /* Verify the user and check access */
    user_verify();

    if (!user_ok("webmaster", "admin")) {
        html_refuse($_SERVER['REQUEST_URI']);
        exit();
    }
    ?>

Edit libraries/common.inc.php. At the top, add

// This seems like a good place to do GSRC valid-user check, since it's
// included by just about every script.
require_once './gsrc_user_check.php';

Copy config.sample.inc.php to config.inc.php. Edit config.inc.php:

Change
$cfg['Servers'][$i]['auth_type'] = 'cookie';
to these two lines:
$cfg['Servers'][$i]['auth_type'] = 'config';
include '/home/apache/conf.php';
Comment out this line (since it's in /home/apache/conf.php)
$cfg['Servers'][$i]['host'] = 'localhost';

Once, when upgrading we had edit /home/apache/conf.php, change each instance of

   $cfgServers[1]

   $cfg['Servers'][1]

(You will need to change its permissions to edit /home/apache/conf.php. When done be sure to change the permissions of /home/apache/conf.phpback to 400, owned by apache.)

Just go ahead and check that /home/apache/conf.php has the above change.

We used to check phpMyAdmin into th tree, but we don't do it any longer.

Version Mismatch

If, when you view the page, you get a message about how the version of the mysql server and the mysql client are different, then try tossing the cookies on your browser. What is happening is that the version is cached in a cookie.

"No tables found in database."

If you get a message "No tables found in database.", then the problem is likely that either there is a file in the mysql directory (/home/www/mysql) or that register_globals is set to Off.
See RE: No tables found in database and phpMyAdmin 2.1.0/2.1.0.1 No Database Selected

The proper solution is to make sure that all the files in /home/www/mysql are owned by mysql and in the mysql group.

Setting register_globals to On should not be done. Leave it as Off.