How to connect Mariadb Database remotely via DBeaver - jigneshpshah/greycube_helpmanual GitHub Wiki

  1. Refer the below manual to change the my.cnf file available at location

/etc/mysql

Configure mariadb port to connect remotely

OR

follow below steps to open the port for listening

make the below change below from:

bind-address = 127.0.0.1

To

bind-address = 0.0.0.0

After making the change above, save the file and run the commands below to restart the server.

sudo systemctl restart mysql.service sudo systemctl restart mariadb.service To verify that the change happens, run the commands below

netstat -tulnp | grep 3306

and you should find the result that looks like the one below

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3213/mysqld

Now the server is setup to listen to all IP addresses but individual IP needs to be explicitly configure to connect to a database.

  1. Mariadb Connection General Settings

Remember to put localhost in server host field

DBeaver Mariadb Connection General Settings

  1. DBeaver Network Settings

DBeaver SSH Tunnel Connection Details