About hosting Control Panel

[Natsu Dragneel]

Hello can you help me with my problem? I am hosting my server and my website on a different host. And I can't link my control panel to the database on my server's VPS. Any solution to this?

[changedname]

Just to be clear, it seems that the rAthena and Database servers are on one host and the Website server is on another host.

When attempting to connect the website Control Panel to the Database server, are you given any error messages?

Potential issues include:
 - Host 1 and/or Host 2 firewalls are blocking access to the Database port.
 - The website Control Panel was configured with the incorrect database access credentials.
 - The Database User was not granted privileges that allow access from the Webserver IP address.
 - The Database service is not running.

[Rynbef]

@Natsu Dragneelsearch for ur mysql config file (my.cnf).

On Linux:

/etc/mysql/my.cnf

 

Change:

bind-address = 127.0.0.1

To:

#bind-address = 127.0.0.1

 

This will allow remote access to the database. But be careful! Use a iptable or UFW to allow only packets/connections from ur server ip.

U need to change that the database user is accessible from other server.

 

Of course restart ur server.

 

Rynbef~