MySQL connection question ...
 

I have just one little question .. I use MySQL on my site and I want to use the same database on other site that is on different server .. is it possible to make connection to that database from my second site ?
thanks

yes... the MySQL networking has to be enabled (I think it is by defult) and you have t oset up the permissions correctly.


GOOGLE GOD DAMNIT!!!! WHy do poeple ask shit like this here.

sorry mate .. I wanted to post some useful thread here .. got overloaded with bang ones and stuff :thumbsup

oki .. found
in case someone want to know

The mysql_connect function lets you specify any server you want. Just
insert the name of the host your MySQL Database is on, e.g
$conn=mysql_connect("www.yourhost.com","user","pas swd");

easy shit .. I though it could be like this

Make sure you add permissions in the user or hosts tables of the 'mysql' database to allow the other server in, then do a

mysqladmin reload

to put the changes into effect.