glodrop

I don't host my pages and database together on the same server as the domain name is a sub-domain of the free host; I can't just change nameservers. I am running out of space on server C and server C doesn't allow upgrades. It would also be useful to have a few sites on different servers accessing the same databaseWould it be possible to have a port eg. 22 or 2222 with the ip - to read as ip:22 in the php script and then once connected to server A it would then be forwarded to port 3306 still giving the necessary login and password.Perhaps server C is only denying external socket connection for port 3306, perhaps not for all the ports????How could I set this up to work on server A?Perhaps I could ask the host of server A to assign my database to a different port. Though if server C is not denying external socket connection for all ports - which would be the best port to use?

Hi,My host on server A suggested me testing it via telnet. Is the reason why I just get a load of ascii characters - because its not meant to be used that way. ? It seems that I am connecting. Is that what I am supposed to get on telnet?Server C is a free host, server A isn't, so I can't get anything from server C, I've tried communicating with them before on this. I have tried accessing the dbase uploaded to other remote(free) hosts though they had a firewall themselves, I couldn't connect to the database there either. Which is why I thought i'd go over to paid hosting and have IPs whitelisted.Is there anyway round accessing it through an external socket, and instead access solely with the IP?I would therefore put $db_host = 'IP for server A' without the port in the config file.or any other ideas????Yordan - what is different about the way your servers are set up as opposed to the ones I'm using?It is correct to write the port with the ip as ip:port in place of 'localhost' ?? in the php script.

Hi,Firstly I tried testing access on from my pc through telnet to the remote server A and I just get '4.1.22-standard' and 25 asciicharacters and a flashing cursor.My host has just installed ssh for me on the cpanel so i'll try and test it through that. I'm new to telnet and ssh.The script you gave a link for. I will try and test the server with that as well - though my goal is to not just to execute queries.The database is a directory of websites on server A. On server C is the php script which will access that database. Instead of inputting 'localhost' in the config file I would add the ip of server C. Though when I have done that I have not had much luck - I just get the message - Can't connect to MySQL server on 'IP for server A' (4) in /home/a9463775/public_html/directory/index.php on line 72I wrote $db_host = 'IP for server A:3306' in the config file.My host of the remote server A assures me that it should work, it is remotely accessible, they have whitelisted the IP and port 3306 is open.The php script on server C is meant to update the database with new data as well as perform search queries on existing data in the database on server A. It is like any other directory php script with it normally accessing the database on 'localhost'Any other ideas on this?

I wondered if anyone here can help.I have a database on a remote server (A). I want to access it through a php script on a different server C.I have allowed access on (A) in Cpanel - mysql dbases - Remote Access by putting the IP address of server CThe host of server (A) has also whitelisted the IP of server C.Though I am having trouble connecting from server C which is with a different webhost.any ideas how to get round this?I have though of SSH forwarding, but I think this can only be used to connect a client - e.g. my pc to the remote server A. I do not have shell access on server CI have thought of accessing through SSH on an additional server B - but I can't get my head round any of it or see how the final php settings are going to end up.