Connect to another Database on the other host

[cakephp]

I have a program with cake php, in one host and I have another Database on the another host .
At first I want connect to Database on the other host after that insert my information on that Database, I really try alot but I don't success.
Can you help me?

[Red7]

This is one of those questions where if you have to ask, you're going to run into a heap of trouble. I'll do my best to help you but you could quickly find yourself in over your head so tread carefully and never make any of these changes unless you have a backup. Ok? I do not guarantee any security for your website using this method.

In config/database.php find where it asks for

'host' => 'localhost'

Change localhost to the full domain name or external IP of your remote database.

Yo;l need to change the rest of those fields to match the username, database name and password of the remote database. That'll get Cakephp to request a connection to a remote database.

Only, there's 1 catch. You now have to configure your remote database to accept that connection. By default, a MySQL database will only accept connections from the localhost. You can change that, but it depends on 100,000 other factors and variables. This is where I'm worried that you may be in over your head so be careful. 1 mistake here and you could end up giving everyone free access to your entire database.

You'll have to search for how to do this using whatever tools you have at your disposal. PHPMyAdmin or Workbench, SSH, CPanel, etc.. It's a different process for each. Good luck!

[noahwilson]

please share some other information, i am not fully understand you problem. so please tell which code show the problem.
Thanks