Re: Client does not support authentication protocol requested by server; consider upg

"Nic Begusarai" <bihbeg@hub2.nic.in> wrote in message news:...
>
> I just install MySql and trying to connect on localhost using PHP
>
> Error: Client does not support authentication protocol requested by
server;
> consider upgrading MySQL client
> how to correct this problem
>
> rana
>
>
>
>
>
>
>

This will fix it.  you need to run this at the mysql command prompt because 
of the different password authentications


SET PASSWORD FOR 'zoooz'@'some_host' = OLD_PASSWORD('mypass');

zoooz is the username
some_host is the host
mypass is the password you want


this will fix it

thanks man :) u helped my a lot. i've had this problem too.
but now it works.

thank you again

quote:
Originally posted by Threepwood 
thanks man :) u helped my a lot. i've had this problem too.
but now it works.

thank you again 
 


Glad I could help :-)

quote:
Originally posted by randy998 
This will fix it. 
 
Brilliant!.. Saved me a ton of time. I was about to upgrade to a newer PHP v
ersion like mysqld told me to.

Thanks, Matt

I was about to rip out my hair and cry. Thanks for the advice. All working n
ow!!!!!(at last)

quote:
Originally posted by randy998 
This will fix it.  you need to run this at the mysql command prompt because 
of the different password authentications


SET PASSWORD FOR 'zoooz'@'some_host' = OLD_PASSWORD('mypass');

zoooz is the username
some_host is the host
mypass is the password you want


this will fix it 
 

This is the same advice I have gotten all day...problem is no one can tell m
e how to get into the mysql command prompt in Redhat Linux 9.

HELP??

Thanks it solved my problem too!



(
quote:
Originally posted by randy998 
This will fix it.  you need to run this at the mysql command prompt because 
of the different password authentications


SET PASSWORD FOR 'zoooz'@'some_host' = OLD_PASSWORD('mypass');

zoooz is the username
some_host is the host
mypass is the password you want


this will fix it 
 )