Database user Remote Access from multiple IP addresses

[MrKaKisen]

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.

[MrKaKisen]

Like putting a ":" between the IPs.

[MrKaKisen]

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

[bluephantom]

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.

[TGates]

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.

[MrKaKisen]

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!

[TGates]

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

[MrKaKisen]

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