cant connect to database mysql useing php - DNForum - Domain Sales, Domain Forum, Domain Appraisals, Domain Registrars

**TvDomain** · 07-19-2005, 12:24 PM

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 · 07-19-2005, 12:30 PM

Try the following :

Code:

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

**TvDomain** · 07-19-2005, 12:53 PM

Can't create TCP/IP socket (5)

that is what it give

Quote:

Originally Posted by TvDomain

Can't create TCP/IP socket (5)

that is what it give

any one can help ?

**cyphix** · 07-19-2005, 04:27 PM

Ask your host why u are getting that error.

**TvDomain** · 07-19-2005, 04:35 PM

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