Nao conecta mysql KINGHOST

Configuração PHP / Ambiente / Performance
#1

Quando vou connectar no db mysql na kinghost apresenta ao erro:

Connection Error

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

Como resolvo isto, vi que alguns membros hospedam na kinghost e tem sucesso.

#2

Veja se isto te ajuda: http://www.netmake.com.br/forum/index.php?topic=4766.0

Abraços,

#3

nao é no kinghost o problema é no php na forma que ele autentica faça o seguinte
Acesse o banco por atraves de um front e execute esse comando

SET SESSION old_passwords=FALSE;

SET PASSWORD = PASSWORD( ' repeti a senha gravada anteriormente ' );