cant connect to database mysql useing php

[TvDomain]

i can use administrator mysql to connect to mysql server , it works fine, i use other sofware to connect and edit the database in mysql server , it works fine
BUT whene i use my script to connect to database it dont want to work , it giveme error
Could not connect to the database

---------------------------------------
$link = mysql_connect('localhost', 'root', 'password');
if (! $link)
die('Unable to connect to the databasename database');
mysql_select_db('databasename') or die('Could not open databasename database');

-------------------------------------------------------
mysql=4.1
php=4
i am close to lose it and format this thing
any one help me out here ? befor i crash it please ?

[dotcomgiant]

Try the following :

$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}

[TvDomain]

Can't create TCP/IP socket (5)

that is what it give

Can't create TCP/IP socket (5)

that is what it give

any one can help ?

[cyphix]

Ask your host why u are getting that error.

[TvDomain]

it is done guys , i fixed it , and it was mysql server problem with autentification , thank anyway