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
mhoggatt1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.