Hi, as always, I'm trying to connect to a MySQL database in the following
way:

mysql_connect('host','user','p***word');

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?

Thank you very much,

Tom.

Tom wrote:
> Hi, as always, I'm trying to connect to a MySQL database in the following
> way:
>
> mysql_connect('host','user','p***word');
>
> 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

Did you search google and look at the mysql website to see what the
problem is?

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

Firstly always CC the mailing list - others can learn from the info as well.

Ing. Tomás Liendo wrote:
> Yes, but the solutions that figure in the Web are only applicable if one
> has access like administrator to the server.
> I can't make things like upgrade versions or configure MySQL or PHP.
> What I want to know is if I can make something as programmer or I need
> to contact the administrator of the server.

Basically you have a mismatch between the client library and the server
version.

eg you have something like:

mysql5-client
mysql4-server

which isn't going to work.


Nothing you can do as a programmer but point the server-admin to the
mysql site and say "please fix".

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

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','p***word');
>
> 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 p***word
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 P***WORD FOR user@localhost = OLD_P***WORD('something');

which will solve it for that user without any upgrading

greets
Zoltán Németh

>
> Thank you very much,
>
> Tom.
>

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','p***word');
>>
>> 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 p***word
> 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 P***WORD FOR user@localhost = OLD_P***WORD('something');

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

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

2007. 05. 30, szerda keltezéssel 10.04-kor Chris ezt ÃÂ*rta:
> 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','p***word');
> >>
> >> 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 p***word
> > 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 P***WORD FOR user@localhost = OLD_P***WORD('something');
>
> Which is also listed on the same page on the mysql site :P

I guess originally I found this info there
but now I just pasted it here from my "knotes"

greets
Zoltán Németh

>

On Mon, May 28, 2007 9:52 pm, Tom wrote:
> Hi, as always, I'm trying to connect to a MySQL database in the
> following
> way:
>
> mysql_connect('host','user','p***word');
>
> 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?

Server admin.

Your PHP is trying to use MySQL version X, and the server is running
MySQL version Y, and they are not gonna match up until the host syncs
their PHP/MySQL install.

At least, that's how I understand it...

--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?