phpMyAdmin error "Cannot connect: invalid settings"

Refers to:

  • Plesk for Windows
  • Plesk for Linux

Created:

2016-11-16 13:07:16 UTC

Modified:

2016-12-21 19:59:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

phpMyAdmin error "Cannot connect: invalid settings"

Symptoms

When opening database "Web Admin" from Parallels Plesk interface "phpMyAdmin" reports the following error:

Cannot connect: invalid settings

Cause

Missing record in psa.accounts table for database user associated with the database.

Resolution

There are two ways to resolve the problem:

Note: Backup of psa database is required for the following actions. (instructions available in KB article #213904125 )

  1. Create new user for the database and make it default user for the database (" pp11db " for example):

  2. Log into Parallels Plesk database (instructions available in KB article #213928465 ) and find ID of missing database record:

    mysql> select db.name, dbu.login, dbu.account_id, a.* from data_bases db, db_users dbu left join accounts a on a.id = dbu.account_id where dbu.db_id = db.id and db.name = 'pp11db';

    +--------+----------+------------+------+------+----------+
    | name | login | account_id | id | type | password |
    +--------+----------+------------+------+------+----------+
    | pp11db | pp11user | 9 | NULL | NULL | NULL |
    +--------+----------+------------+------+------+----------+
  3. Once account_id is found, create new record in table psa.accounts :

    mysql> insert into accounts (id, type, password) values (9, 'sym', '');
    Query OK, 1 row affected (0.00 sec)`
  4. After that, go to database user's properties in Plesk GUI ( Websites & Domains > Databases ) and assign new password.

Have more questions? Submit a request
Please sign in to leave a comment.