How to query info from distant database, PHP/MySQL

Question

I have to code an application on my server that triggers emails based on info that come from a database hosted on another server and I don't know how to query that information. I'm using PHP/MySQL. I can't established a connection to this database like I do normally (when database is host on the same server that the application file), right?

Thanks in advance,

Adam Pointer · Accepted Answer · 2012-01-21 17:42:13Z

5

Wrong, there is no difference whether code and database are on the same or different servers. As long as the remote db server is configured to allow conections from foreign hosts that is... But that's a hosting issue not a programming one.

edited Jan 21, 2012 at 17:42

answered Jan 21, 2012 at 16:52

Adam Pointer

1,4928 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Leo Stein Over a year ago

You're right, I just add my host in the Remote Database Access Hosts and voilà!

fet · Accepted Answer · 2012-01-21 16:58:32Z

3

I'm not really sure why you wouldn't be able to. I've hosted databases on servers other than my hosting server before.

Try this

$my_db = mysql_connect('yourdb.com:3307', 'myuser', 'mypassword');
    if (!$my_db) die('This might be a problem: ' . mysql_error());

answered Jan 21, 2012 at 16:58

fet

6245 silver badges12 bronze badges

Comments

mustafa · Accepted Answer · 2012-01-21 16:55:03Z

1

If mysql is on another machine , from mysql, you have to give permission for outsider.

answered Jan 21, 2012 at 16:55

mustafa

7453 gold badges9 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to query info from distant database, PHP/MySQL

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related