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.
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.
Looks like your controluser (pma) does not have necessary privileges. See http://docs.phpmyadmin.net/en/QA_4_0/setup.html#using-authentication-modes
I recently ran into the same issue and I didn't have to reinstall LAMP, purging and reinstalling phpmyadmin only was sufficient for me.
I had the same issue today (April 9, 2014)after an upgrade to 4.1.12deb2 The actual issue causing multiple error-messages was the definition in the php-code of phpmyadmin in /usr/share/phpmyadmin/libraries/config/setup.forms.php
The table names are defined there with a prefix consisting of two underscores (pma__), but the actual tables have just the prefix of: pma_ (one underscore).
So renaming all the tables solved the matter. In overview of database phpmyadmin, click 'check all' and then |with selected| 'replace table prefix'. And then entering pma_ (1 underscore) and pma__ (2 underscores). Works like a charm.