connection problem

[sneha24]

i have installed a database in my local pc
and an identical database in another pc (say b) in phpmyadmin
how do i coonect to tat pc(b)
i used the following to connect from my local pc
$con1 = mysql_connect('domain_name', 'username', 'passwrd');
if (!$con1)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("database_name_", $con1);
but its displaying the following error
Could not connect: Can't connect to MySQL server on 'www.ristaa.com' (10060)
wat to do?

[decowski]

Make sure skip-networking is commented out in my.cnf and you have set bind-address=xxx.xxx.xxx.xxx to your server's IP address.

Also make sure that firewall is not blocking the connection.

[sneha24]

m using web developer suite in win xp
where will i find this file
my.cnf?

[sneha24]

anyone plz help
i need it urgently

[decowski]

On the database server. If it's Linux then it will be in /etc/mysql/my.cnf or similar, depending on distro.

[tariq1654]

Try this:
mysql_connect('localhost', 'name', 'password') or die(mysql_error());
mysql_select_db('db_name');

[sneha24]

On the database server. If it's Linux then it will be in /etc/mysql/my.cnf or similar, depending on distro.

i have already mentioned that m using windows xp
and web developer suite
well i found these files
my-huge.cnf
my-middle.cnf
my-large.cnf
my-small.cnf
my-innodb-heavy-4G.cng
now wat to do?

[sneha24]

Try this:
mysql_connect('localhost', 'name', 'password') or die(mysql_error());
mysql_select_db('db_name');

its still not working

[sneha24]

Make sure skip-networking is commented out in my.cnf and you have set bind-address=xxx.xxx.xxx.xxx to your server's IP address.

Also make sure that firewall is not blocking the connection.

i found the file and did as instructed
but in vain

[decowski]

i found the file and did as instructed
but in vain

Did you change it on the machine that is running the database you're trying to connect to? Did you then restart the MySQL server?

[sneha24]

Did you change it on the machine that is running the database you're trying to connect to? Did you then restart the MySQL server?

yes i did
but the same error is encountered
Can't connect to MySQL server on '67.227.152.196' (10060)

[Raju Gautam]

Also you should have a database username which is permitted to connect to any host or at least to your IP address/host from where you are trying to host.

[sneha24]

Also you should have a database username which is permitted to connect to any host or at least to your IP address/host from where you are trying to host.

how do i grant this permission?

[Raju Gautam]

The easy way is putting '%' (Any Host) in the Host while creating the database user from phpmyadmin.

See following link for more details for command line statements.
http://dev.mysql.com/doc/refman/5.1/...ing-users.html
http://dev.mysql.com/doc/refman/5.1/en/grant.html