Re: Client does not support authentication protocol...

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. >