| Author |
Re: Client does not support authentication protocol requested by server; consider upg
|
|
| Nic Begusarai 2004-12-18, 12:49 pm |
|
"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
>
>
>
>
>
>
>
| |
| randy998 2005-01-14, 11:52 pm |
| 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 | |
| Threepwood 2005-01-30, 10:38 am |
| thanks man :) u helped my a lot. i've had this problem too.
but now it works.
thank you again | |
| randy998 2005-01-30, 3:14 pm |
| 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 version like mysqld told me to.
Thanks, Matt | |
| lordpeart 2005-03-03, 1:25 pm |
| I was about to rip out my hair and cry. Thanks for the advice. All working now!!!!!(at last) | |
| areamike 2005-03-07, 9:56 pm |
| 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 me 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
) |
|
|
|