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

kb: technical

Applicable to:

The following message appears on phpMyAdmin home page in Plesk:

CONFIG_TEXT: 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:

CONFIG_TEXT: 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

For Plesk Onyx and Plesk Obsidian below 18.0.30:

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

For Plesk Obsidian 18.0.30 and above:

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.