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
  • Avatar
    Francisco Garcia

    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