[RESOLVED] Accessing a database on another server

[AsmIscool]

Its an SQL problem but I am writing in PHP so my apologies to Admin and feel free to move this if you think it would be better located.

I have some working code to access the database on the same server but if I try to change it to the database on a separate server it will not work. Surely this can be done or am I wasting my time and remaining hair?

Many thanks for your help.

[SambaNeko]

Others can correct me if I'm wrong, but I believe remote access is disabled by default for MySQL (are we even talking about MySQL?). If you have permission, you can enable it and grant access to remote IPs. Here's a step by step walkthrough of the process.

[techgnome]

Depends... you should just be able to change the server name, make sure the login info is correct and that's that.... BUT it depends on a number of things.

Perhapse you can start by telling us what the problem is - are you getting an error message or something? If so what is it EXACTLY? Also what kind of database are you currently connecting to, what kind of database are you trying to connect to? And what does your code look like?

-tg

[AsmIscool]

Sorry guys. I really should have said MySQL shouldn't I. However I am working with a programmer in a very different time zone so I could get you more information. Just not right now but I think SambaNeko has just given us the information we needed. Thanks mate and I think this one is resolved. Credits given.