phpMyAdmin on a Linux machine

Padiyath Sreekumaran kumar.padiyath at psi.ch
Tue Jun 5 06:43:35 UTC 2007


Hello,
 Iam sorry if I ask php question here. 
 Iam trying to install phpMyAdmin on a RedHat linux (Version 4). I have
installed  MySQL,PHP,Apache and Firefox.When I start
http://localhost/phpMyAdmin I get an error:

MySQL said:
1272 = Unknown collation: 'utf8_unicode_ci'


My config.inc.php file contains the following.

 cat config.inc.php

<?php

/* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */ //
vim: expandtab sw=4 ts=4 sts=4:

/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use scripts/setup.php
 *
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <http://wiki.cihar.com>.
 */

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */


/*$cfg['blowfish_secret'] = 'password'; /* YOU MUST FILL IN THIS FOR
COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;
/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['host'] = 'localhost'; 
$cfg['Servers'][$i]['connect_type'] = 'tcp'; 
$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'root'; // 
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */

// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; 
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; 
// $cfg['Servers'][$i]['relation'] = 'pma_relation'; 
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; 
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; 
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; 
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; 
// $cfg['Servers'][$i]['history'] = 'pma_history'; 
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server  */
 
$cfg['UploadDir'] = ''; 
$cfg['SaveDir'] = '';

?>

I will appreciate very much your help.

With regards,
Kumar
 ------------------------------------------------------------------
Padiyath Sreekumar       |   Tel: +41.56.310.3643
Paul Scherrer Institut   |   email: kumar.padiyath at psi.ch
AIT                      |   Office: WHGA/U132 
WHGA/U132                |   Fax: +41.56.310.3649
CH-5232 Villigen PSI     | 
Switzerland              |
-----------------------------------------------------------------




More information about the redhat-list mailing list