Fetch Data From Database Hosted on Other Server

Hi All,
My website is hosted on us based server and I want to develop an application which can fetch data from mysql db of another website, which is hosted on other server. How can I do this.

 

if you dont have access to the database. you cant.

 

I'm not sure I understand what you are trying to do. Do you have access to those databases ? If you do

enable your MySQL server for remote access

grant all privileges on *.* to USERBLOGIN@000.000.000.000 identified by "USERBPASSWORD";

Code (markup):

*.* (Means all databases)
User B login must be replaced by your login on server B
Replace 000.000... by the IP
and UserBpassword by your password on server B

 

thanks you all for the help...!!!

 

Just be cautious opening up your server to remote SQL/MySQL connections it can open up a whole host of security concerns.

 

You can also just do a mysql dump then copy the file over and import it. It is more secure than opening up your database.