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 will solve it for that user without any upgrading
greets
Zoltán Németh
>
> Thank you very much,
>
> Tom.
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
