Page 1 of 1

How do I upgrade MySQL on client?

Posted: Fri Dec 15, 2006 9:22 am
by bwv2
This may sound like a stupid question (and it may be). I am getting the following error:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\vhosts\website.com\httpdocs\sheets\getin.php on line 4
I am using the following call to get this error:

Code: Select all

mysql_connect("localhost","username","password") or die(could not connect);
I was told that I could fix this problem by upgrading mySQL on the client side. This is where my confusion starts. My connection call resides on my server in a php file. Therefore, doesn't it call on the mySQL version installed on the server? I guess I'm confused on the difference between the client and server in this case. If I upgrade mySQL on the server, will this fix the problem, or is it just a matter of changing something in a config file to make the "client" upgraded?

FYI: I tried putting old_passwords in the my.ini file, and it didn't help. I also tried changing my password to be longer, but it didn't work either. Also, I'm using mySQL 4.1 on the server.

Posted: Fri Dec 15, 2006 11:30 am
by dibyendrah
Refer this URL for upgrading the old mysql client :

http://dev.mysql.com/doc/mysql/en/Old_client.html

Posted: Fri Dec 15, 2006 11:37 am
by bwv2
The article you pointed to does not say how to upgrade the client. All it says about it is:
To solve this problem, you should use one of the following approaches:

Upgrade all client programs to use a 4.1.1 or newer client library.
...
And this doesn't really help me in understanding what I had mentioned before:
My connection call resides on my server in a php file. Therefore, doesn't it call on the mySQL version installed on the server? I guess I'm confused on the difference between the client and server in this case. If I upgrade mySQL on the server, will this fix the problem, or is it just a matter of changing something in a config file to make the "client" upgraded?
Even if I knew how to upgrade the "client" version, I would like to know what "client" actually means in this case as well. I'm trying to teach myself as I go, so understanding all of this is important to my ability to figure things out in the future. Thanks.

Posted: Fri Dec 15, 2006 11:52 am
by dibyendrah
Okay. This thread discuss these issues :
viewtopic.php?t=60700