Help! MySql and GoDaddy!

[FathomJH]

<?php
DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'sitename');

//make the connection
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySql: ' . mysql_error() );

//select the database
@mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );

?>

i use this to make a connection and when i go to test to see if it works, i get this message:

Could not connect to MySql: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Any ideas why? Thank you for any help :D!

 

[Noobie]

Are you sure its localhost?

 

[FathomJH]

hmm, good point, ill give it a try the other way :D

 

[chicker]

Just a word of warning godaddy and phpmyadmin = annoyance I have had to move so many clients from them as the features they have limited with their phpmyadmin is amazing you can hardly do anything with it

I am sure godaddy is on local host you probably have the user/password wrong

 

[sukantab]

In godaddy it will surely be not globalhost. Go to your control panel and see the name of the database host.

 

[Kate]

Either you are not using the correct host name or they are having an issue with the mysql server.

 

[FathomJH]

W00t W00t. Got it to work, lousy godaddy :bah: . I ended up mixing up the code. Got it to work

used this instead

mysql_connect("HOSTNAME", "DATABASE", "PASSWORD") OR die( mysql_error() );
mysql_select_db("DATABASE") OR die( mysql_error() );

 

[nasaboy007]

another thing that irks me about godaddy is that they use a proxy.

try to use the paypal IPN script and it wont work. i had to recode a cURL version of it just so i can get it to work.


and also, the mysql db hostname is 99% not localhost, mine was like mysql21.624 or something (all fake stuff, but that was the general pattern, obv NOT localhost)