Posts: 40
Threads: 6
Joined: Apr 2016
Reputation:
0
Sex: Undisclosed
Thanks: 7
Given 1 thank(s) in 1 post(s)
Database user Remote Access from multiple IP addresses
05-14-2016, 10:41 PM
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.
Posts: 40
Threads: 6
Joined: Apr 2016
Reputation:
0
Sex: Undisclosed
Thanks: 7
Given 1 thank(s) in 1 post(s)
RE: Database user Remote Access from multiple IP addresses
05-20-2016, 02:34 AM
Like putting a ":" between the IPs.
Posts: 40
Threads: 6
Joined: Apr 2016
Reputation:
0
Sex: Undisclosed
Thanks: 7
Given 1 thank(s) in 1 post(s)
RE: Database user Remote Access from multiple IP addresses
05-25-2016, 02:51 AM
Hello? Is there anyone that has a answer to this? Thanks!
Posts: 13
Threads: 1
Joined: May 2016
Reputation:
0
Sex: Male
Thanks: 2
Given 1 thank(s) in 1 post(s)
RE: Database user Remote Access from multiple IP addresses
05-25-2016, 03:36 AM
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.
Posts: 3 ,657
Threads: 241
Joined: May 2014
Reputation:
85
Sex: Male
Thanks: 406
Given 597 thank(s) in 462 post(s)
RE: Database user Remote Access from multiple IP addresses
05-25-2016, 02:37 PM
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.
-TGates - Project Council
SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE
Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Posts: 40
Threads: 6
Joined: Apr 2016
Reputation:
0
Sex: Undisclosed
Thanks: 7
Given 1 thank(s) in 1 post(s)
RE: Database user Remote Access from multiple IP addresses
05-25-2016, 09:17 PM
(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!
Posts: 3 ,657
Threads: 241
Joined: May 2014
Reputation:
85
Sex: Male
Thanks: 406
Given 597 thank(s) in 462 post(s)
RE: Database user Remote Access from multiple IP addresses
05-25-2016, 11:47 PM
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
-TGates - Project Council
SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE
Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Posts: 40
Threads: 6
Joined: Apr 2016
Reputation:
0
Sex: Undisclosed
Thanks: 7
Given 1 thank(s) in 1 post(s)
RE: Database user Remote Access from multiple IP addresses
06-23-2016, 07:12 PM
(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
|