Symptoms
-
On a Plesk Obsidian for Linux server, the following error is shown in the menu Tools & Settings > Assistance and Troubleshooting > MySQL Process list (Beta):
Request failed with status code 500
Cause
Issue is caused by bug with ID PPPM-11086, which is planned to be fixed in product future updates.
Resolution
Apply the following workaround if the server was affected by this bug:
Workaround
-
Connect to the server via SSH
-
Back up the Plesk database:
# plesk db dump psa > psa.backup.sql
-
Configure the value of the
admin_passwordfor the local MySQL server with 8 asterisks:# plesk db "update DatabaseServers set admin_password='********' where id = 1"