Answer a question

Using PhpMyAdmin with PHP and MySQL stack in Ubuntu I encounter the problem:

1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist

TO solve this I added:

$ Cfg [‘Servers’] [$ i] [‘table_uiprefs’] = ‘pma_table_uiprefs';

Changed to:

$ cfg [‘Servers’] [$ i] [‘pma__table_uiprefs’] = ‘pma__table_uiprefs';

in config.inc.php file after that I've got the problem like:

Error in Processing Request

Error code: 200

Error text: OK

How can I solve this?

Answers

looks like your config has been modified put this in /var/www/phpmyadmin/config.inc.php and also change password below if you set something else blank

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

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

/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][1]['user'] = 'root'; //edit this line
$cfg['Servers'][1]['password'] = 'XXXX'; // your password

and comment this line for now

//$ cfg [‘Servers’] [$ i] [‘pma__table_uiprefs’] = ‘pma__table_uiprefs';