firecat318 Posted April 29, 2008 Share Posted April 29, 2008 Here is my connection.php file... <?php $con = mysql_connect("p50mysql151.secureserver.net", "te****", "*********"); $db = mysql_select_db("texting"); ?> But when I attempt to connect, I get this message. Can't connect to MySQL server on 'localhost' (10061) Why is the script trying to connect to localhost? It should be connecting to p50mysql151.secureserver.net, which is what I got from my host. Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/ Share on other sites More sharing options...
PFMaBiSmAd Posted April 29, 2008 Share Posted April 29, 2008 There is an sql.safe_mode setting that will cause the symptom you describe, but this is rarely set. It is more likely that the whole error message is referring to a different statement in your code. Please post the whole error message. Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529715 Share on other sites More sharing options...
firecat318 Posted April 29, 2008 Author Share Posted April 29, 2008 That is the whole error message. BTW, i'm running 5.0 Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529793 Share on other sites More sharing options...
dezkit Posted April 29, 2008 Share Posted April 29, 2008 change <b>p50mysql151.secureserver.net</b> to <b>localhost</b> Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529806 Share on other sites More sharing options...
PFMaBiSmAd Posted April 29, 2008 Share Posted April 29, 2008 The posted code does not contain any usage of the mysql_error() function so it is not the code that caused and output the posted error. Either your connection.php file is not being used or there is some other code attempting to connect to the database server or as I wrote, sql.safe_mode might be on. Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529811 Share on other sites More sharing options...
firecat318 Posted April 29, 2008 Author Share Posted April 29, 2008 Now I added some or die statements, and I get this when I load the page Client does not support authentication protocol requested by server; consider upgrading MySQL client Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529827 Share on other sites More sharing options...
PFMaBiSmAd Posted April 29, 2008 Share Posted April 29, 2008 Searching for that error, yields this - http://dev.mysql.com/doc/refman/5.0/en/old-client.html The client is php's mysql client library. The version of it that your version of php is using it not new enough for the version of mysql. The link I posted gives some things to do to work around the problem. Quote Link to comment https://forums.phpfreaks.com/topic/103423-why-is-it-using-localhost/#findComment-529843 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.