Question Plesk Server Mysql Remote Connection

[Mr_Online]

How to enable remote access to MySQL service on Plesk server

I applied this article. A very useful article.

Plesk my database settings also: "Allow remote connections from any host" but can not connect.

My operating system is Centos 7 and I have a firewall (firewall-cmd). What should I do to access external IPs?

 

[Brujo]

maybe you like to share what the problem is in a bit more detail, so we can start to help you
see also: Unable to connect remotely to MySQL on a Plesk server: Connection refused

 

[Mr_Online]

I cannot connect to my plesk mysql server from another server. I can connect when I turn off the server's firewall.

Default settings for remote access of database users - This settings not working.

 

[Mr_Online]

[root@host-37 ~]# firewall-cmd --permanent --add-service=mysql
success
[root@host-37 ~]# firewall reload
success

I found something that worked. Is this safe?

 

[IgorG]

Is this safe?

It's up to you whether to open MySQL port to the outside.

 

[Brujo]

I cannot connect to my plesk mysql server from another server.
Is this safe?

If the other Server has a fixed IP you just need to open remote access to your mysql database server from the specified IP on your firewall or Database Hosting Settings in the plesk panel Tools & Settings