phpMyAdmin配置存储问题

Question

I'm well aware that this is a commonly asked question, and I've gone through countless posts here, and elsewhere, but I can't seem to get this to work.

I am seeing this error:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.

This is my configuration file:

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
$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';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';

There is a user called PMA with no password and full permissions.

I have a database called phpmyadmin, and it was populated with the tables generated in the examples/create_tables.sql script. I cannot browse to these tables and see the contents, however because SELECT command denied to user ''@'localhost' for table 'pma__table_uiprefs' (I am logged into the root user).

The query phpMyAdmin tries to run when I try to access any of the configuration tables is:

SELECT  `prefs` 
FROM  `phpmyadmin`.`pma__table_uiprefs` 
WHERE  `username` =  'root'
AND  `db_name` =  'phpmyadmin'
AND  `table_name` =  'pma__bookmark'

I have cleared by browsers cache, restarted apache, done all of the little tricks I've seen elsewhere but all that's doing is making me frustrated.

Answer 1

Out of frustration, I removed LAMP & phpmyadmin and reinstalled them. After the setup I was greeted without the error message. Don't know why this was happening but reinstalling it fixed it.