Database user Remote Access from multiple IP addresses

Database user Remote Access from multiple IP addresses - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: Database user Remote Access from multiple IP addresses (/showthread.php?tid=2840)

Database user Remote Access from multiple IP addresses - MrKaKisen - 05-14-2016

Hello,

In Sentora, when creating a mysql user, if using "Only from single IP", is there any option to allow more than one IP?

Thanks.

RE: Database user Remote Access from multiple IP addresses - MrKaKisen - 05-20-2016

Like putting a ":" between the IPs.

RE: Database user Remote Access from multiple IP addresses - MrKaKisen - 05-25-2016

Hello? Is there anyone that has a answer to this? Thanks!

RE: Database user Remote Access from multiple IP addresses - bluephantom - 05-25-2016

never have done it before with sentora, but try editing your mysql/my.cnf change bind-address section to allow your ip and

Code:
TO 'user'@'%'

to your db
thanks.

RE: Database user Remote Access from multiple IP addresses - TGates - 05-25-2016

Yes, Disable Single IP... then any IP will be able to connect provided they know the port, user name and password.

More info: As per MySQL documentation, you can only bind to none, one or all. Not multiple.

RE: Database user Remote Access from multiple IP addresses - MrKaKisen - 05-25-2016

(05-25-2016, 02:37 PM)TGates Wrote: Yes, Disable Single IP... then any IP will be able to connect provided they know the port, user name and password.

More info: As per MySQL documentation, you can only bind to none, one or all. Not multiple.

Aha, I see. Thanks!

RE: Database user Remote Access from multiple IP addresses - TGates - 05-25-2016

Although, you can use firewall rules to only allow your preferred IPs to connect remotely to MySql for added security if that is a concern
Wink

RE: Database user Remote Access from multiple IP addresses - MrKaKisen - 06-23-2016

(05-25-2016, 11:47 PM)TGates Wrote: Although, you can use firewall rules to only allow your preferred IPs to connect remotely to MySql for added security if that is a concern

Yes, that I knew. The problem is, I need a specific database to only allow connections from two IPs, while the other databases on the same node needs to allow connections from everywhere. Solved it by buying another VPS xD