Question Allow local MariaDB/MySQL server to accept external connections

[weareimpulse]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.67 Update #2 Web Host Edition

hi - I'm looking for some advice.

We have a client who wants to remotely push data into a DB we have on our server, however, at the minute their detaisl wont connect.

After reading us, i see that we need to have this check (see attached)

However, as we have about 40-45 other sites on this server, Is this a security risk as it seems to be a server-wide setting??

Any advice welcomed

Thanks - Tim

 

[scsa20]

I wouldn't recommend allowing remote connections if there's no external firewall to regulate it and everything else is done behind the firewall since you're just opening yourself up for a world of hurt but if you really want to you can by enabling that and making sure that the firewall rules allows the connection but again it's not recommended.

If your client needs the ability to push to the database remotely I would recommend moving them to their own server and have it on them if anything happens.