why is it using localhost?

[firecat318]

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.

[PFMaBiSmAd]

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.

[firecat318]

That is the whole error message.  BTW, i'm running 5.0

[dezkit]

change <b>p50mysql151.secureserver.net</b> to <b>localhost</b>

[PFMaBiSmAd]

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.

[firecat318]

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

[PFMaBiSmAd]

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.