MySQL connection question ...

[Andy]

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

[- Jesus Christ -]

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.

[Andy]

Originally posted by - Jesus Christ -
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

[Andy]

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

[rickholio]

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.