- Plesk 12.5 for Linux
Error establishing a database connection is shown when try to open database-based website.
Database user is missing in mysql.user table.
Check if user exists in mysql daily dumps in
var/lib/psa/dumpsfolder. Restore dump if necessary.
If user does not exist, try to re-create this user using
plesk repair mysqlutility.
plesk repair mysqldoes not work, create user manually using the following query:
GRANT ALL PRIVILEGES ON <db_name>.* TO <db_user>@"%" IDENTIFIED BY '<db_password>' WITH GRANT OPTION;
<db_name>, <db_user>, <db_password>can be found in website database configuration file.