Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have the privileges set for my databases. I have tried to connect to the MySQL server (version 4.1.7) using PHP version 4.3.9. My OS is Windows XP.
I have received this message -
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client


I understand that this is because PHP 4.3.9 doesn't support the new 41 char password encryption and I need to run the mysql_fix_privilege_table. Is the script below correct for the Windows platform ?

mysql> --force mysql < mysql_fix_privilege_tables.sql

Is there any other advice you can give me that pertains to this error ?
Thanks
0
mhoggatt1
Asked:
mhoggatt1
  • 3
  • 2
1 Solution
 
UmeshMySQL Principle Technical Support EngineerCommented:
Hi,

Take a look at this if this can help you..

http://dev.mysql.com/doc/mysql/en/Old_client.html
0
 
mhoggatt1Author Commented:
Yes it worked. I was able to change the 41char password format in the 'user' table to the older style 16char format which allowed me to connect to the MySQL server with a PHP script (MySQL version 4.1.7 & PHP version 4.3.9). I have been working on this prolem for 2 weeks.
Here is the instruction that did the job -


ysql> SET PASSWORD FOR 'my_user_name'@'localhost' = OLD_PASSWORD('my_old_password');
Thanks again !
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
:-)

Anytime!
0
 
mhoggatt1Author Commented:
Hi Umesh,
   Thanks for your help. I'm having trouble closing my open questions. I see where I can split points, but how do I credit the entire points at one time ?
Thanks.
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Hi,


[Taken from EE]

You can use the Split Points option, just above the comment box (if the Q is worth 40 or more points), or you can simply hit the Accept button on the expert's comment that helped most. We would like you to add to the question, though, that while it did not solve your problem, you are awarding points anyway. That way, if someone finds the Q in a future search, they understand that it might not solve the problem. If you want to award fewer points, make a request here in CS. Give the link to the question, and exact number of points and the expert(s) to whom you want to award, and we can handle it for you.

Please hit the Help button at the top of the EE page, and hit "Closing Questions" to learn more.

I'm going to accept my answer here to close this question, but be sure that we can still continue communication here.



Hope this helps!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now