How to connect to db remotely?

Community Support Database
1

Hi all. I need to connect to my db remotely to upload some data.
But the only host i have is local host

How can i Create host for DB to be able to connect remotely?

2

Please use the search function: Search results for 'mysql remote' - Hestia Control Panel - Discourse

Also we do have an entry in our docs for it.

1 Like
3

Hello,

I assume you want to add a supported database server such as Mysql. In such a case, kindly use v-add-database-host.

Moreover, if you want to see your remote database server in phpMyAdmin, I suggest this workaround. Feel free to improve it !

1 Like
4

Hello.
No. I do not need phpMyAdmin
I need to have opportunity to be able to connect to my DB remotely.
When I tried to do v-add-database-host it fails with error that it is not able to connect.

5

you need to adjust your mysql config to allow binding to your public IP.
also you need to add a firewall rule for the database port to be allowed to be accessed from external IP. ideally you want to allow it only for a specific external IP to limit access on that level already and avoid inviting brute force attacks

2 Likes
6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.