Symptoms
-
The output of
plesk repair installationcommand contains:Dropping phpMyAdmin '' DB and '' DB userWarning: phpMyAdmin was configured without configuration storage in database
-
Running
plesk repair installationends 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
-
Connect to a Plesk server via SSH
-
Backup the phpMyAdmin database:
# plesk db dump phpmyadmin > /root/phpmyadmin.sql
-
Backup the MySQL database:
# plesk db dump mysql > /root/mysql_$(date +%F_%H.%M).sql
-
Connect to MySQL:
# plesk db
-
Switch to the MySQL database:
# use mysql;
-
Remove the phpmyadmin user:
# DROP USER 'phpmyadmin'@'localhost';
-
Drop the phpmyadmin database:
# drop database phpmyadmin;
-
Restart MariaDB:
# systemctl restart mariadb
-
Uninstall the
psa-phpmyadminpackage:-
Centos/RHEL:
# rpm -e --nodeps psa-phpmyadmin
-
Debian/Ubuntu:
# dpkg -r --force-depends psa-phpmyadmin
-
-
Reinstall phpMyAdmin:
# plesk installer update