Web Hosting Talk







View Full Version : MySQL


AL-Benjamin
12-12-2001, 02:43 PM
Hi,
I resell using CP/ WHM and have had a thought...

I have a databse running on the server using mysql. i could do with accessing that information from a program i have running on a nt box.

Basically can you access a mysql database running on another server? (perhaps calling an IP or url instead of localhost?)

-thanks all.

Varun Shoor
12-12-2001, 03:29 PM
Yes you can, make sure the user trying to access from a different IP other than localhost has permissions to do so (read up on "grant" command in mySQL manual)

kunal
12-12-2001, 03:37 PM
your host would have to grant permissions for the remote ip address to connect to mysql.. email the host asking them if they will allow it..