Connecting database

[zestpanlo92]

Hi everyone. anyone there can help me? i cant connect my database in x10hosting.com.
pls help me. the error message is "Lost connection to MySQL server at 'reading initial communication packet', system error: 111"

[MaestroFX1]

Could you please post your domain name ?

[zestpanlo92]

my domain is www.greenscarf.co.cc
and i was connecting my database to my blog

---------- Post added at 09:29 AM ---------- Previous post was at 09:27 AM ----------

Could you please post your domain name ?

my domain is www.greenscarf.co.cc
and i want to connect my database to my blog

[MaestroFX1]

It is working for me!

[zestpanlo92]

It is working for me!

yes.. my domain is working... but if you click the TAB named BLOGS you will see the error

[MaestroFX1]

What did you use "mysql server name" as ?
It should be localhost.

[zestpanlo92]

What did you use "mysql server name" as ?
It should be localhost.

heres my code:

<?php
// Your host, 99% of the time it's localhost.
$db_host = 'localhost';
// Your username for MySQL.
$db_user = 'aianzki_aianzki';
// Your password for MySQL.
$db_pass = 'mypassword';
// And your given name for the database.
$db_name = 'aianzki_greenscarf';

// The database connection.
$con = mysql_connect($db_host, $db_user, $db_pass);
if(!$con) {
die("Cannot connect. " . mysql_error());
}
// The database name selection.
$dbselect = mysql_select_db($db_name);
if(!$dbselect) {
die("Cannot select database " . mysql_error());
}
?>

[MaestroFX1]

Have you granted all the required privileges to the mysql user?

[zestpanlo92]

Have you granted all the required privileges to the mysql user?

yes i granted all there permission.. in MySql Database and also to the MySql Database Wizard

---------- Post added at 09:58 AM ---------- Previous post was at 09:52 AM ----------

Have you granted all the required privileges to the mysql user?

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/aianzki/public_html/connect.php on line 12
Cannot connect. Lost connection to MySQL server at 'reading initial communication packet', system error: 111

[MaestroFX1]

What sort of data are you trying to fetch ?
Is it of type blob? How many tables are there ?