On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at MyPlesk.com/Plesk360/Platform360 please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

MySQL Process List in Plesk does not work: Request failed with status code 500

Follow

Comments

6 comments

  • Avatar
    Fabian Marsiglione

    Hello

    I not understand something here :

    update DatabaseServers set admin_password='********' where id = 1;
    Query OK, 1 row affected (0.10 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    What i must to put in "*****"  (any password i want?)

    Thanks
    Fabian

    1
    Comment actions Permalink
  • Hi Fabian Marsiglione,

    There's no mistake in the command, and the "password" that has to be set is 8 asterisks

    0
    Comment actions Permalink
  • Avatar
    Yevgeny Mozgov 🇬🇷🍌🍄🗳️ (Edited )

    So what is the fix here?

    We have latest version but problems remains

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Yevgeny Mozgov 🇬🇷🍌🍄🗳️

    What's the output on your server of this command?

    plesk db -Ne "select COUNT(admin_password) from DatabaseServers where id = 1 and admin_password = '********' "

    Does the workaround from this article work for you?

    0
    Comment actions Permalink
  • Avatar
    Сергей Засухин

    This error is still relevant in the latest version of plesk when using mariadb 10.3! how to solve?

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    Сергей Засухин Hi! Workaround from article should help:

    1. Back up the Plesk database:

      plesk db dump psa > psa.backup.sql

    2. Configure the value of the  admin_password for the local MySQL server with 8 asterisks:

      plesk db "update DatabaseServers set admin_password='********' where id = 1"

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request