How to link webhosting database to vps database?

[mrlongshen 22]

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...

[Dastgir 1246]

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....

[Winterfox 83]

@@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 22]

@@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 83]

@@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 438]

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.