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
