• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Problem with admin password

A

andreasbalzer

Guest
Hi,
I tried to change the admin password in plesk. My attempt to do that produced the following error:
ERROR: PleskMainDBException
Create ShortcutCreate Shortcut
Up LevelUp Level
MySQL query failed: Table 'mysql.servers' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:218
db_query(string 'flush privileges')
1: /usr/local/psa/admin/plib/cmd_server.php3:93
ch_admin_pass(string '************', string '************')
2: /usr/local/psa/admin/htdocs/server/ch_pass.php3:43


When I try to open plesk now I get
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

0: /usr/local/psa/admin/plib/common_func.php3:158
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: /usr/local/psa/admin/auto_prepend/auth.php3:87


The command cat /etc/psa/.psa.shadow shows the old one. My questions: a) Can I go back to the old password? b) Can I go with the new password? c) What is easier to do at the moment?

Please help me, this is urgent. :-/

Thanks.
 
for solution the error: Table 'mysql.servers' doesn't exist in Plesk 10

the solution is:


[root@server ~]# mysql_fix_privilege_tables --user=admin --password=<admin passord> --verbose

This script updates all the mysql privilege tables to be usable by
the current version of MySQL

i testing is all ok!
 
Back
Top