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.
