Sentora Support Forums

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.

Like putting a ":" between the IPs.

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

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

to your db
thanks.

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.

(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!

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

(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