Connecting to remote server (MySQL)

[Moh]

Well I am currently trying to connect to our forums MySQL from our main site.

I have allowed our server ID for the main site to access the MySQL.
When I replace "localhost" with the server ip of the forum, it dosn't connect.

Do I have to use another IP than the server IP? or do I have to add a port?

Cheers.

[Agnostic Bear]

Well I am currently trying to connect to our forums MySQL from our main site.

I have allowed our server ID for the main site to access the MySQL.
When I replace "localhost" with the server ip of the forum, it dosn't connect.

Do I have to use another IP than the server IP? or do I have to add a port?

Cheers.

Are you sure remote mysql is enabled? also remote mysql is not really a good idea because of high ping.

[Trinity]

Try this - http://www.webmasterworld.com/forum10/6141.htm
(third post from the bottom)

[Moh]

Are you sure remote mysql is enabled? also remote mysql is not really a good idea because of high ping.
The only way we can update infomation without having to create a new database.

It would help if the sites where hosted by the same host, but sadly, thats not the case :(

[iUnknown]

If they're on the same host then you can use localhost .. and if remotely connecting isn't working then I suggest you put the forum and site on the same host.

[Moh]

Im just going to add the file on the forum server until the forums on the same server as site :P

[iUnknown]

Im just going to add the file on the forum server until the forums on the same server as site :P

Haha yeah, easier solution.

[Dentafrice]

Use Navicat for MySQL and go into cPanel and set the access host to your IP

http://www.tehupload.com/images/app-90146246375292273.png

[Trigs]

Try adding :3306 to the end of the url (mySQL's port)

Example:
255.255.255.255:3306