Plesk repair installation shows warning: phpMyAdmin was configured

[mahesh]

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

• The output of plesk repair installation command contains:

Code Select Expand

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


• Running plesk repair installation ends with:

Code Select Expand

***** 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:

Code Select Expand

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

Code Select Expand

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

Code Select Expand

#plesk db
5.Switch to the MySQL database:

Code Select Expand

#use mysql;
6.Remove the phpmyadmin user:

Code Select Expand

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

Code Select Expand

#drop database phpmyadmin;
8.Restart MariaDB:

Code Select Expand

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

• Centos/RHEL:

Code Select Expand

#rpm -e --nodeps psa-phpmyadmin


• Debian/Ubuntu:

Code Select Expand

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

Code Select Expand

#plesk installer update