Resolved Remote connection to database refused

[zakaria]

Server operating system version

Debian 10.12

Plesk version and microupdate number

Plesk Obsidian 18.0.44 Update #3

Hi, hope everyone is doing well

I have a problem connecting remotely to a database on the server
the connection is refused, so I guess I'm not using the correct info
but I am not sure how is it possible since I got this info by going to Databases for that domain go to the needed database and clicked on Connection Info

what could I be missing

e

 

[Maarten.]

Can you open a telnet session from the remote location to the server on port 3306?

telnet <servername> 3306

 

[zakaria]

No I can't, for <servername> I used the hostname then the server IP address

it says couldn't open connection to the host on port 3306: connect failed

 

[Maarten.]

Does this article help?

https://support.plesk.com/hc/en-us/articles/213904365-How-to-enable-remote-access-to-MySQL-server-in-Plesk-

 

[zakaria]

I'll check it out, thanks

 

[zakaria]

Thank you very much, that fixed it