N
N
NewSantaClaus2021-11-05 11:22:03
linux
NewSantaClaus, 2021-11-05 11:22:03

Why can't I connect to remote Mysql via DBeaver?

I'm trying to connect to a remote database

Attempts to connect via SSH via the console are successful
Connecting sudo mysql -u login -p
Authorization is set to login and password mode, not socket

I can't connect via DBearer. Mistake

Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.


netstat -tlpnissues
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN


Login, password, ip, database name, everything is correct
Please help me decide

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sanes, 2021-11-05
@NewSantaClaus

Remote access is disabled by default.

A
Alexander Karabanov, 2021-11-05
@karabanov

Use an SSH tunnel. Look in the connection settings in DBeaver, there is such an option.
No need to shine port 3306 into the world - it will end badly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question