Symptoms
When opening phpMyAdmin via Plesk, the following error appears:
PLESK_INFO: #1045 – Access denied for user ‘pma_xxxxxxx’@’localhost’ (using password: YES)
PLESK_INFO: Cannot connect: invalid settings.
Connection for controluser as defined in your configuration failed.
PLESK_INFO: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to ‘Operations’ tab of any database to set it up there.
PLESK_INFO: #1142 – SELECT command denied to user ‘plesktest’@’localhost’ for table ‘pma_recent'<b/p>
or phpMyAdmin login screen is opened without errors, but with empty credential fields. No auto-login is performed.
Cause
Product issue:
-
#PPPM-11253 “Users can no longer lose access to phpMyAdmin via Plesk after updating to Plesk Obsidian or after Plesk Obsidian updates.”
Fixed in:- Plesk Obsidian 15 September 2020 (Linux)
Resolution
Workaround
If update is not possible for some reason you may try the following
workaround
Apply one of the following workarounds:
-
Clear cookies in your web-browser.
OR
-
Remove phpMyAdmin session files:
-
Connect to the Plesk server via SSH.
-
Clean the phpMyAdmin session directory:
# rm -rf /usr/local/psa/var/phpMyAdmin/session/*
-
If the phpMyAdmin session directory has been customized, run the command below to find the actual directory:
# egrep “‘SessionSavePath'” /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php
Â
-
-
If neither of the workarounds above help, reinstall phpMyAdmin (users’ data will not be affected):
-
Remove the phpMyAdmin package:
-
on CentOS/RHEL-based distributions
# rpm -e –nodeps psa-phpmyadmin
-
on Debian/Ubuntu-based distributions
# dpkg -r –force-depends “psa-phpmyadmin”
-
-
Run the Plesk Installer update command to install phpMyAdmin:
# plesk installer update –repatch
-
If the issue persists, run Plesk repair utility as follows:
# plesk repair installation