How do I upgrade MySQL on client?
Posted: Fri Dec 15, 2006 9:22 am
This may sound like a stupid question (and it may be). I am getting the following error:
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.
I am using the following call to get this 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
Code: Select all
mysql_connect("localhost","username","password") or die(could not connect);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.