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. Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/ 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? Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-629780 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. Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-629817 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. Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-629836 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? Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-629920 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? Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-629976 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()? Link to comment https://forums.phpfreaks.com/topic/121956-newbie-needs-help/#findComment-630486 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.