How do I upgrade MySQL on client?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

How do I upgrade MySQL on client?

Post 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.
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post by dibyendrah »

Refer this URL for upgrading the old mysql client :

http://dev.mysql.com/doc/mysql/en/Old_client.html
bwv2
Forum Commoner
Posts: 83
Joined: Fri Jun 10, 2005 11:50 am
Location: AZ

Post 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.
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post by dibyendrah »

Okay. This thread discuss these issues :
viewtopic.php?t=60700
Post Reply