How to link webhosting database to vps database?

[mrlongshen]

Based on the title above ? 

how ?

for example my site is hosting at HOSTING A.

Then I install the control panel at HOSTING A.

But my vps are at other hosting, which is HOSTING B.

How to connect it ? Because usually I install my control panel same on the VPS...

 

[Winterfox]

@@mrlongshen

You just need the address of your database server and it's port.

Just input the database address and your port in the config instead of local host and the default port.

 

[mrlongshen]

@@Winterfox

That means, 
For example I'm using cora CMS, so my config, I need to put the VPS ip ?

For the cora CMS file, I put on the webhosting. Right?

So basically I need the the remote mysql or what ????

I dont understand.. The file will connect to my vps database ? right? 

 

[Winterfox]

@@Winterfox

That means, 

For example I'm using cora CMS, so my config, I need to put the VPS ip ?

For the cora CMS file, I put on the webhosting. Right?

So basically I need the the remote mysql or what ????

I dont understand.. The file will connect to my vps database ? right? 

If you put your remote mysql address and the correct port in your cora config, it should be able to use the remote mysql database of your vps.

 

[jaBote]

BTW remember that MySQL doesn't allow remote connections by default. So, in case you get connection refused errors, remember that you should enable them on the my.cnf file, somewhere under the [mysqld] tag.

 

[Dastgir]

BTW remember that MySQL doesn't allow remote connections by default. So, in case you get connection refused errors, remember that you should enable them on the my.cnf file, somewhere under the [mysqld] tag.

Grant PRIVILEGES using MySQL....