[SOLVED] How to connect to a remote database?

[johansalllarsson]

Hi,
Im trying to connect to a database on a server but i end up getting these errors:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'mydb.somehosting.com' (10060) in C:\xampp\htdocs\www\db_test.php on line 12
Could not connect: Can't connect to MySQL server on 'mydb.somehosting.com' (10060)

The script is valid and works (just not when i run the script from localhost), and here it is:
$link = mysql_connect("mydb.somehosting.com", "user", "mypassword") or die("Could not connect: " . mysql_error());
mysql_selectdb("db",$link) or die ("Can\'t use db: " . mysql_error());

Btw i disabled my firewall, my antivirus, still no good.
How can i resove this issue?

[Wiedmann]

$link = mysql_connect("mydb.somehosting.com", "user", "mypassword") or die("Could not connect: " . mysql_error());

You are not using the MySQL server from XAMPP? Because this one is on "localhost".

And if you want use another DB server... Maybe this one don't allow external connections.

[johansalllarsson]

Yea, i figured it might be something like that.

However i have another db server i need to connect to (not the xampp one). Since I can connect to this server via MS Excel and download whatever this must indicate that it allows external connections, but i get the same response: cant connect etc...

Any ideas?

[Nobbie]

>Since I can connect to this server via MS Excel

I didn't know that MS Excel can connect natively to a MySQL Database Server?

Are you sure, you are running a MySQL Server remote?

[johansalllarsson]

Well i can connect via Office database connections .odc.

Im adding my ip to my hostingserver to see if i can connect to that again. This way ill allow external connections from my ip. So if this fails something must be wrong with the settings in xampp i guess. Takes an hour so its just to wait....

>Are you sure, you are running a MySQL Server remote?

Im sure i have a Mysql server on the hostingserver, on the other server ive just been told we have it so i cant say for sure.

[johansalllarsson]

It works now... I allowed external connections to the server.