Remote connection to MariaDB

1

How do I connect remotely (for example, using HeidiSQL) to the MariaDB database with db_user_name and password (not root)?
I set
bind-address = *
in /etc/mysql/my. cnf - it doesn’t help. Disabled iptables and fail2ban-also did not help.
What else can I see?

2

Hello Maxim, try this instead:

[mysqld]
...
bind-address = 0.0.0.0

Afterwards you can confirm with

sudo netstat -ntlp | grep -E "(mysql|maria)"
3

[mysqld]
…
bind-address = 0.0.0.0
it doesn’t help

sudo netstat -ntlp | grep -E “(mysql|maria)”
netstat: command not found

4

apt install netstat cowsay && echo “now I have netstat installed” | cowsay

5 
netstat -ntlp | grep -E "(mysql|maria)"
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      96676/mariadbd

But not connecting.

telnet 123.123.123.123 3306 - say “Could not open a connection to this node, on port 3306”

What else to pay attention to?

6

"Could not open a connection to this node, on port 3306” it’s a great tip for your question.

7

how will this help me? what should I do?

8

Did you restarted the mysql service after changing the conf?

9

of course

10

I think the output of the netstat command is showing that mariadb service is listening on localhost only (127.0.0.1).
Have a look at the bold in this StackOverflow answer. Maybe it’s related.

1 Like
11

I realized what the problem was.
I set bind =0.0.0.0 in the Hestia panel itself in the mariadb config settings.
And it was necessary to change this value in the file /etc/mysql/mariadb.conf.d/50-server.cnf.
And now question: why are the mariadb config settings ignored in the hestia panel?

12

In the /etc/mysql/mariadb.conf.d/50-server.cnf file i set
bind-address = 0.0.0.0
And the remote connection to the database works.
But why can’t I connect remotely if I set my IP?
bind-address = 123.123.123.123

13

Because its probaly a different config file. I usualy always suggest to adjust them on shell instead web, it just makes more sense. About the request itself, this has added a while ago to our docs: Database — Hestia Control Panel documentation

1 Like
14

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