Articles in this section

See more

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

Avatar
Gabriel Aznarez
Updated
Plesk for Linux kb: technical

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/mysql_$(date +%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

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles