trouble706 Posted August 30, 2008 Share Posted August 30, 2008 I am new with PHP and MySql. I have a Script on a site that I designed for a Church. On my server, it works perfectly...(See http://www.premierewebdesign.net/Dan/NEW2/Events/index.php) However, when I try to load the page on the Church's site, I get this message....Client does not support authentication protocol requested by server; consider upgrading MySQL client.... (See http://www.reservationprocessing.net/lfbc/Events/index.php)..Both are using MySql 4. I don't have any idea what this message means.. ??? ??? ???..Any help will be appreciated. Quote Link to comment Share on other sites More sharing options...
trouble706 Posted August 30, 2008 Author Share Posted August 30, 2008 I now know what the problem is but I do not know what to do about it.....This site is on a Windows server. I have been told that I will have to use ASP to connect to the database. Maybe with a script similar to this DRIVER={MySQL ODBC 3.51 Driver}; SERVER=p41mysql31.secureserver.net; PORT=3306; DATABASE=lfbc1; USER=lfbc1; PASSWORD='your password here'; OPTION=0; I am lost. I know nothing about ASP. I can only assume that I will need to create an ASP config file. But will the ASP then interact with my PHP script to read the database? Or is this whole project going to have to be rewritten in ASP? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 30, 2008 Share Posted August 30, 2008 This has nothing to do with ASP vs. PHP... you simply have old client libraries for mysql... see this link. Quote Link to comment Share on other sites More sharing options...
trouble706 Posted August 30, 2008 Author Share Posted August 30, 2008 I am not sure that I follow you about having old libraries. I did follow the link you provided. However, I do not know what link I need to follow there to get the information that you are referring to. If there is any more direction as to what link that you can give me, it will be appreciated. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 30, 2008 Share Posted August 30, 2008 Well, the best option would be to get the new client libraries... can you do that? Quote Link to comment Share on other sites More sharing options...
trouble706 Posted August 30, 2008 Author Share Posted August 30, 2008 Not if I understand the Libraries....Maybe I don't.. But this site is hosted by GoDaddy. So, wouldn't the libraries be on their end? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 31, 2008 Share Posted August 31, 2008 Yes, it would be... I'm actually surprised they still use the old libraries. Can you simply update the password with OLD_PASSWORD()? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.