Resolved Cannot connect to DB Remotely

[melifetaji]

Server operating system version

debian-11-bullseye-v20231212

Plesk version and microupdate number

Free Trial (probably Latest)

Basically cannot connect to my db from my local computer.

The database is on localhost:3306 on the server, remote connections are allowed.

What I've done:
1. Turned off the Firewall completely (didn't work)
2. Restarted MySQL and MariaDB services
3. Adjusted the config file to bind 0.0.0.0
4. I have a user with FULL ACCESS

 

[melifetaji]

How can I manually add a firewall port rule from Plesk Dashboard?

I did this from terminal but it didnt help:

1. sudo iptables -A INPUT -p tcp --dport 3306 -i your_interface -j ACCEPT

 

[Peter Debik]

- Which database server and which version are you using? E.g. for MariaDB 10.6 and newer you'd omit the bind-address line altogether while for previous versions it should be "bind-address = ::".
- Does your datacenter have a firewall in front of your server that you can configure in your data center's control panel?

 

[melifetaji]

Thank you Peter, you are a hero

The problem was Google Cloud Firewall, totally forgot to configure firewall there.