Cobra Forum

Question:
Plesk repair installation shows warning: phpMyAdmin was configured without configuration storage in database
Symptoms

• The output of plesk repair installation command contains:

Dropping phpMyAdmin '' DB and '' DB userWarning: phpMyAdmin was configured without configuration storage in database


• Running plesk repair installation ends with:

***** problem report *****Warning: phpMyAdmin was configured without configuration storage in database
Cause
plesk repair installation command resets the phpMyAdmin to a blank state from template due to product issue PPPM-13902, which was fixed in Plesk Obsidian 18.0.51.

Resolution
Update Plesk to the latest version.

If update is not possible, use the following workaround:

Reinstall phpMyAdmin
1.Connect to a Plesk server via SSH

2.Backup the phpMyAdmin database:

#plesk db dump phpmyadmin > /root/phpmyadmin.sql
3.Backup the MySQL database:

#plesk db dump mysql > /root/mysqldate +%F_%H.%M.sql
4.Connect to MySQL:

#plesk db
5.Switch to the MySQL database:

#use mysql;
6.Remove the phpmyadmin user:

#DROP USER 'phpmyadmin'@'localhost';
7.Drop the phpmyadmin database:

#drop database phpmyadmin;
8.Restart MariaDB:

#systemctl restart mariadb
9.Uninstall the psa-phpmyadmin package:

• Centos/RHEL:

#rpm -e --nodeps psa-phpmyadmin


• Debian/Ubuntu:

#dpkg -r --force-depends psa-phpmyadmin
10.Reinstall phpMyAdmin:

#plesk installer update