Knowledge Base

Error on phpMyAdmin main page in Plesk: phpMyAdmin configuration storage is not completely configured

The following message appears on phpMyAdmin home page in Plesk:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

When the suggested link is opened, the following appears:

General relation features: Enabled
 $cfg['Servers'][$i]['favorite'] ... not OK [ Documentation ]
 Persistent favorite tables: Disabled

phpMyAdmin configuration storage misconfiguration.

Click on a section to expand

Login to the server via SSH.
According to the error favorite table has not OK status. Find this table from the error in configuration file:
# grep favorite /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite’] = ”;
Set pma_<table_name> value for above output in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php file
using text editor:
# grep favorite /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite‘] = ‘pma_favorite‘;
Clear browser cache and login to phpMyAdmin again.

Click on a section to expand

Login to the server via SSH.
According to the error favorite table has not OK status. Find this table from the error in configuration file:
# grep favorite /usr/local/psa/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite’] = ”;
Set pma_<table_name> value for above output in /usr/local/psa/phpMyAdmin/libraries/config.default.php file
using text editor:
# grep favorite /usr/local/psa/phpMyAdmin/libraries/config.default.php | grep -v “*”
$cfg[‘Servers’][$i][‘favorite‘] = ‘pma_favorite‘;
Clear browser cache and login to phpMyAdmin again.