- Plesk Onyx for Linux
- Plesk Obsidian for Linux
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.
#PPPM-11253 "Users can no longer lose access to phpMyAdmin via Plesk after updating to Plesk Obsidian or after Plesk Obsidian updates."
- Plesk Obsidian 15 September 2020 (Linux)
If update is not possible for some reason you may try the following
Apply one of the following workarounds:
Clear cookies in your web-browser.
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