By 14 Ottobre 2010 0 Comments

Client does not support authentication protocol

Quando il sistema PHPmyAdmin rende questo errore :
“Client does not support authentication protocol requested
by server; consider upgrading MySQL client”

bisogna intervenire su Mysql tramite la consolle (Dos) per assegnare questo dettaglio al Db :

SET PASSWORD FOR utente= OLD_PASSWORD(‘password’);

in alternativa si può fare un Update e un Flush

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD(‘newpwd’)
-> WHERE Host = ‘some_host’ AND User = ‘some_user’;
mysql> FLUSH PRIVILEGES;

Posted in: Php, Web Server

About the Author:

shared on wplocker.com