Re: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by:
Eugene Sesonga ()
Date: December 29, 2004 05:48PM
I was having the same problem and when I got to this message, it all worked great! People have to know that this command needs to be issued in the mysql console and not DOS!
Thank you!
Marcin Paluch wrote:
> it's quite easy: you have to use normal root
> account as you/ve registered while installation
> process or, for sure, change password settings for
> root, then:
>
> 1) login as root with correct password to mysql
> console
> 2) enter command
> SET PASSWORD FOR peter@localhost =
> OLD_PASSWORD('something');"
>
> BUT!:
> There is something strange for me: first time I
> entered command, it failed, and after changing
> database (use my_db) and entering it again
> everything was OK. The "mysql_connect(): Client
> does not.." doesn't appear. I don't know why
> because in PHP API mysql_select_db() is made after
> successfull connection...