Re: Client does not support authentication protocol...
| From: | Chris | Date: | Wed, 30 May 2007 00:04:04 +0000 |
| Subject: | Re: Client does not support authentication protocol... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255773@lists.php.net to get a copy of this message | ||
Zoltán Németh wrote:
2007. 05. 28, hétfő keltezéssel 23.52-kor Tom ezt írta:Which is also listed on the same page on the mysql site :P -- Postgresql & php tutorials http://www.designmagick.com/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');