connecting external mysql database with php

Question

Is that possible to connect mysql database between servers. I mean, lets say i have 2 accounts on 2 different hosting service, one of them has database, and i want to connect it from other one with php.

When i try it, i get "Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query..."

my database is located on godaddy and i set it external access enabled.

Edit: I see it is possible but my host only allows connection via software;

"To use Direct Database Access to connect remotely to your shared hosting database, you need to download software that lets you connect to the database and manage it."

Should "work" but aside from some possible intermittent connection issues like you seem to describe, you should typically expect a significant loss of performance when accessing a remote server on the internet. — mjv
– mjv, Commented Nov 9, 2009 at 1:41

Bartek · Accepted Answer · 2009-11-09 01:33:00Z

2

It's very possible.

Make sure the host that has your database allows for external connections and allows that username/password combination to access the database (Usually something set via mySQL's GRANT option)

answered Nov 9, 2009 at 1:33

Bartek

15.7k2 gold badges61 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

connecting external mysql database with php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related