Knowledge Base

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

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/mysqldate +%F_%H.%M.sql
Connect to MySQL:

# plesk db
Switch to the MySQL database:

# use mysql;
Remove the phpmyadmin user:

# delete from mysql.user where User='phpmyadmin';
Drop the phpmyadmin database:

# drop database phpmyadmin;
Restart MariaDB:

# systemctl restart mariadb
Uninstall the psa-phpmyadmin package:
- Centos/RHEL:
  
  # rpm -e --nodeps psa-phpmyadmin
- Debian/Ubuntu:
  
  # dpkg -r --force-depends psa-phpmyadmin
Reinstall phpMyAdmin:

# plesk installer update