Articles in this section

See more

Opening phpMyAdmin from Plesk fails: Cannot connect: invalid settings

Avatar
Taras Ermoshin
Updated
Follow
Plesk Onyx for Linux kb: technical ABT: Group A

Applicable to:

  • Plesk Onyx for Linux

Symptoms

Accessing phpMyAdmin for a database from Plesk in Domains > example.com > Databases fails:

CONFIG_TEXT: Cannot connect: invalid settings

Cause

Mismatch of the database user's password saved in Plesk and in MySQL server.

Resolution

  1. Log into Plesk.

  2. Go to Domains > example.com > Databases.

  3. Under a database name, click on the name of a database user:

  4. Specify a new password in fields Password and Confirm password.

  5. Click OK or Apply to save the changes.

Comments

2 comments

Sort by Date Votes
  • Avatar
    Fouad Ahmed Fouad

    I have a similar issue but for many databases migrated accounts from Cpanel, can you help me with a CLI fix so I don't have to fix manually for more than 200 databases users have?

    Some times I have this error and some times I have another promtp to enter password manually for database at phpmyadmin, I reinstalled phpmyadmin and used plesk repair db and all without success, please help?

    0
    Comment actions Permalink
  • Avatar
    Mikhail Shport

    Hello Fouad Ahmed Fouad,

    It is possible to change the password by using the next command:

    # plesk bin database --update-dbuser jdoe -passwd pa$$w0rd

    Additional information can be found here:

    https://docs.plesk.com/en-US/obsidian/cli-linux/using-command-line-utilities/database-databases.75671/

    Also, it can be checked via the help option:

    # plesk bin database --help

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles