php mysql connection problem. Beginner

Anon

I am having problems connecting to mysql

When I use my domain name to try to connect

I get this error message:
Warning: MySQL Connection Failed: Host 'constitution.worldwebserver.com' is not allowed to connect to this MySQL server in lib.inc.php on line 257 Error
If I use 'localhost' I get this: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lib.inc.php on line 257 Error
I am using an ISP. If I use telnet I can log in to mysql so I know my username and password are correct.
Any Help would be greatly appreciated. troy hardy

knight

try doing this:

mysql_connect( 'localhost', 'yourusername', 'yourpassword' )
or die ( 'Unable to connect to server.' );

Anon

Thanks for responding

I tried the code you suggested

I Recieved the error message:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
in /home3/thardy/public_html/temp/mymarket/connect.php on line 9
Unable to connect to server.

Anon

tell me wml concept

knight

It sounds like you haven't setup the mysql database to accept a connection from an outside account from the looks of it

jc94062

are you sure its localhost?
I had problems when I moved to a new host because they on a stange server system and I have to currently use an IP for my "localhost" on the connect, phoning/emailing them could be the answer.

also, mysql_pconnect is better, sets a permanent connection to the host, speeds up your pages. (makes the hoster happier as well)

Anon

Thanks for the Help.

I have tried it with an IP adress it still doesnt work. I think that the ISP I am using doesnt have my permission set up correctly.

I emailed them but they are very slow in responding so I guess that I hve to wait and see.
Thanks to everyone who has helped. I will post the answer I get from my ISP.

Redards,
Troy Hardy

Anon

Wow.. this post is really old and I'm not sure if Troy would be able to benefit from it but someone else looking for answers might.. so..I just had the same problem and while searching for answers I came across this post. And well thanks to all, for replying because the answer is almost localhost, but instead you would write the generic ip address. For eg:

$sqlHost="127.0.0.1";
$sqlUser="root";
$sqlPassword="passIfAny";

if(!($linkId=mysql_pconnect($sqlHost,$sqlUser,$sqlPassword))){
die("still could not connect");
}else{
echo("connected.. do what you want!");
}//End if