SELECT command denied to user ‘phpmyadmin’@’localhost’ for table ‘pma_table_uiprefs’

In case you got this error on your phpmyadmin (because you mess up with phpmyadmin before), try to find this line on your “/etc/phpmyadmin/config.inc.php”

$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;

 

find your $dbuser & $dbpass at “/etc/phpmyadmin/config-db.php” :

$dbuser='xuserx';
$dbpass='xx-pass-xx';

and execute on sql command on phpmyadmin page :

GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* TO 'xuserx'@'localhost' IDENTIFIED BY 'xx-pass-xx';