Re: Client does not support authentication protocol...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Zoltán Németh wrote:
2007. 05. 28, hétfő keltezéssel 23.52-kor Tom ezt írta:
Hi, as always, I'm trying to connect to a MySQL database in the following way:

mysql_connect('host','user','password');

In my local PC this Works perfectly, but in the server I receipt the following error:

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

Which can the cause of this error be?
Am I able to make something to solve it or does a problem belong exclusively to the administrator of the server?

I've met this problem when I upgraded mysql-server from mysql 4.0 to
mysql 4.1
it was because mysql 4.1 and newer versions use a different password
encryption method. I think it can be solved by upgrading mysql-client
too. or you can issue the following mysql command on the server:

SET PASSWORD FOR user@localhost = OLD_PASSWORD('something');

Which is also listed on the same page on the mysql site :P

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux