Plesk login page displays error: “DB query failed: Unknown error”
ERROR: PleskMainDBException
DB query failed: Unknown error
0: common_func.php3:171
db_query(string 'set names utf8')
1: common_func.php3:626
reconnect()
2: common_func.php3:591
db_connect()
3: auth.php3:90
Cause
The Parallels Plesk Panel administrator’s password and Plesk SQL Server administrator password are corrupted.
Resolution
The passwords for the Parallels Plesk Panel administrator and the Plesk SQL Server administrator must be reset:
- Find the username of the Plesk SQL Server administrator in the
PLESK_DATABASE_LOGIN
value in the registry keyHKLM\SOFTWARE\Plesk\PSA Config\Config
. - Open the file
%plesk_dir%\mysql\data\my.ini
and addskip-grant-tables
to the[PleskSQLServer]
section. Save the file and restart Plesk SQL Server service. - Log in to SQL:
"%plesk_dir%\mysql\bin\mysql" -P8306 -Dmysql
- Update the password of the Plesk SQL administrator (replace NEW_PASSWORD and admin with proper values):
UPDATE user SET Password = password('NEW_PASSWORD') WHERE User = 'admin';
- Remove
skip-grant-tables
from%plesk_dir%\mysql\data\my.ini
. Save the file and restart Plesk SQL Server service. - Set a new password for the Parallels Plesk Panel administrator:
"%plesk_bin%\plesksrvclient" -set NEW_PASSWORD
Kaynak : http://kb.parallels.com/en/115602