How to allow mariadb remote connect hestiacp

[Adhenra]

I want to connect a database. from another server

how I can setup properly?

[Raphael]

Just add a firewall rule allowing port 3306 from your other server, I suggest to limit it for his ip address and do not allow the connection from anywhere. Also validate the bind-address setting, see posts below.

[Adhenra]

this way

/sbin/iptables -A INPUT -i eth0 -s 145.239.00.00 -p tcp --destination-port 3306 -j ACCEPT

Or From HestiaCP

[Raphael]

From hestia cp, checkout the firewall rules part.

[Adhenra]

@Raphael

3306

[pandoratoolbox]

I have this same problem. I installed Wordpress via Hestiacp and want to access my database remotely to display my blog posts within my custom app. I tried the solutions suggested here - opening ports both via Hestiacp and command line but still keep getting connection refused when using HeidiSQL or DBeaver to connect remotely. Do I need to do any more configuration to get this to work?

[Raphael]

The question is if mariadb/mysql server answers requests from any ip, checkout this - I suggest the “manual steps”: How to enable Remote access to your MariaDB/MySQL database

[pandoratoolbox]

Thanks for the suggestion. I’ve checked the link and followed the instructions but there is no ‘bind-address’ in the configuration file mentioned. When I add this line, it still shows as listening on 127.0.0.1 from netstat (tried restarting mariadb and rebooting). Do you know how to solve this?

[eris]

bind-adress=0.0.0.0

[pandoratoolbox]

That’s what I added, it didn’t work

[pandoratoolbox]

Ok I’m using Ubuntu 16.04, I found a solution: I needed to change the bind-address in
/etc/mysql/mariadb.conf.d/50-server.cnf