The phpMyAdmin configuration storage is not completely configured

[novaposthub]

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why
Or alternately go to ‘Operations’ tab of any database to set it up there.

Any support please ?

[sahsanu]

Show the output of these commands:

mysql -uroot -e 'use phpmyadmin; show tables;'
sed -E "s/(.*controlpass.*= ')(.*)(';)/\1[## removed ##]\3/" /etc/phpmyadmin/conf.d/01-localhost.php

[novaposthub]

@sahsanu

alhost.php

+------------------------+
| Tables_in_phpmyadmin   |
+------------------------+
| pma__bookmark          |
| pma__central_columns   |
| pma__column_info       |
| pma__designer_coords   |
| pma__designer_settings |
| pma__export_templates  |
| pma__favorite          |
| pma__history           |
| pma__navigationhiding  |
| pma__pdf_pages         |
| pma__recent            |
| pma__relation          |
| pma__savedsearches     |
| pma__table_coords      |
| pma__table_info        |
| pma__table_uiprefs     |
| pma__tracking          |
| pma__userconfig        |
| pma__usergroups        |
| pma__users             |
+------------------------+

[sahsanu]

I don’t see an obvious problem.

Could you please explain again what is the problem? An screenshot of the error you see?

[novaposthub]

Aan when you click on Find out why. this is the screenshot

Is there any issue or i can ignore it? Im new to HestiaCp

[novaposthub]

[sahsanu]

That’s not normal, I’ve never seen that error.

Well, I see your phpmyadmin version and seems you installed it manually, using the Ubuntu packages, is that correct?

Show the output of these commands:

dpkg -l | grep phpmyadmin
cat /etc/phpmyadmin/config.inc.php

[novaposthub]

[sahsanu]

You should not install phpmyadmin that way and the config file is not the right one. Now, could you explain what you did?

Anyway, you can try to fix the mess executing this script as root:

/usr/local/hestia/install/upgrade/manual/migrate_phpmyadmin.sh

[novaposthub]

@sahsanu

/usr/local/hestia/install/upgrade/manual/migrate_phpmyadmin.sh

You are a GEM sir ! Im grateful sir… It works

[novaposthub]

Please what is the best practices…because i installed the HestiaCp with the OS during setup of my vps and i remember i run some codes.

[sahsanu]

Best practices are simple, install a minimal debian/ubuntu image and follow the instructions to install Hestia… and don’t install manually packages used by Hestia (fail2ban, exim, dovecot mariadb, nginx, apache2, php, etc.).

[novaposthub]

Thanks @sahsanu .I’m very grateful for your time and assistance.