problem after update to 12.x

[Havrosd]

hello,
I have a problem after the update can not log into Plesk.
After entering https://domain:8443 pops up this error
Zend_Db_Adapter_Exception- SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (Abstract.php-144)

sorry for my English

 

[IgorG]

Make sure that my.cnf hasn't specified old_password standard. After that run:

/usr/local/psa/bin/admin --show-password

to retrieve new password. Then you need to reset the password with the following command:

/usr/local/psa/bin/init_conf -u -passwd <new_pass> -encrypted-password

 

[Havrosd]

my.cnf
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

/usr/local/psa/bin/admin --show-password
PHP Notice: Undefined index: PARAMETERS; File: /usr/local/psa/admin/plib/CommonPanel/Exception.php, Line: 266

Error occured while sending feedback. HTTP code returned: 502
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

 

[tmavr]

same problem here
any news ?

 

[procmb]

Same problem with old_passwords = 1 in my.cnf, I deletet this line and restarted the server.

# /usr/local/psa/bin/admin --show-password
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

# /usr/local/psa/bin/init_conf -u -passwd xxyyzz -encrypted-password
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Can I ever use Plesk on this server? I even can't use mysql as root.

 

[IgorG]

Check this article - http://www.serveridol.com/2014/06/2...-authentication-method-unknown-to-the-client/

 

[tmavr]

see http://kb.parallels.com/112492

and something like
comment old_passwords=1
restart mysql
add/modify user
uncomment old_passwords=1
restart mysql

that worked for us