The phpMyAdmin configuration store is not fully configured and some advanced features have been disabled. Find out the reason. Or go to the Operations tab of any database to configure storage in it

Community Support
1

Hello everyone, re-read [this](https://forum.hestiacp.com/t/can-not-fix-phpmyadmin-warning-the-phpmyadmin-configuration-storage-is-not-completely-configured-some-extended- features-have-been-deactivated/6677) this, but I didn’t understand how to fix it

"The phpMyAdmin configuration store is not fully configured and some advanced features have been disabled. Find out the reason.
Or go to the Operations tab of any database to configure storage in it.""
You do not have the necessary rights to create a database named "phpmyadmin". You can go to the Operations tab of any database to configure the phpMyAdmin configuration store.

# phpMyAdmin configuration storage [![Documentation](https://hestia.angellive.ru/phpmyadmin/themes/dot.gif "Documentation")](https://hestia.angellive.ru/phpmyadmin/doc/html/setup.html#phpmyadmin-configuration-storage)

Configuration pmadb… **Not done** [![Documentation](https://hestia.angellive.ru/phpmyadmin/themes/dot.gif "Documentation")](https://hestia.angellive.ru/phpmyadmin/doc/html/setup.html#phpmyadmin-configuration-storage)

Basic communications capabilities Not available

![](https://hestia.angellive.ru/phpmyadmin/themes/dot.gif) [Create ](https://hestia.angellive.ru/phpmyadmin/index.php?route=/check-relations) a database named 'phpmyadmin' and configure it to store the phpMyAdmin configuration.

Installed Hestia 1.8.12 from scratch, nothing has changed, does anyone have experience on how to increase rights, or is there a need to do this at all?
config

<?php
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'password';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['hide_db'] = 'information_schema';

Снимок экрана_20250115_000452
Снимок экрана_20250115_0004521443×689 98.4 KB

2

What error have you encountered? Do we still need to enable advanced features? Are common features insufficient to support your operation?

3

Mmm, I want to understand how to fix what is indicated, for example 1.9 Hestia does not have this. Either the phpadmin user rights are different, or something is wrong in the config.

4

Currently, version 1.9 has not been released. Before the official release, relevant errors will be fixed (if any). If you post information here, it means that you will not fix this error. (If you have the ability, you will definitely publish tutorials on how to fix it.) We recommend that you use version 1.82, which is stable and relatively stable to use!

If you are using version 1.82. Please provide a detailed description of the situation in which you encountered the error.
Convenient to answer your questions.

5

Yes, I described everything above, both the version and the logs, I did not find a solution on the Internet, perhaps someone on the forum knows how to solve this problem, with the rights to automatically create a phpadmin table.

6

The issue you are encountering is that the configuration storage of PHPMyAdmin is not fully set up, resulting in some advanced features being disabled. This is usually because PHPMyAdmin requires a dedicated database to store its configuration and some auxiliary data, which has not yet been created or configured.

Solution steps

  1. Create the ‘php myadmin’ database:
    -You need a MySQL user with sufficient permissions to create the database.
    -Log in to the MySQL command line or use the “SQL” tab in PHPMyAdmin to execute the following SQL commands:
CREATE DATABASE phpmyadmin;
      • Configure PHPMyAdmin to use this database * *:
        -Ensure that the correct database name, control user, and password are set in the configuration file of PHPMyAdmin (usually config. inc. php).
        -Based on the configuration fragment you provided` Pmadb ‘has been set to’ php myadmin ‘, you need to ensure that’ control user ‘and’ control pass’ have access to this database.

  2. Create necessary tables:
    -PHPMyAdmin provides an SQL script for creating necessary tables in its configuration database.
    -You can import this SQL script in the ‘Import’ tab of PHPMyAdmin. Usually, this script is located in the installation directory of PHPMyAdmin, with the file name ‘creat_tables. sql’.

  3. Granting permissions:
    -Ensure that ‘Controluser’ has full access to the ‘PHPMYAdmin’ database. You can use the following SQL commands:

GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

-Please replace ‘pma’ and ‘password’ with the actual username and password you set in ‘config. inc. php’.

  1. Reload PHPMyAdmin:
    -After completing the above steps, reload the PHPMyAdmin page and check if the configuration storage has been set up correctly.
1 Like