This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Database user Remote Access from multiple IP addresses
#1
Database user Remote Access from multiple IP addresses
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 - Website - GitHub
Reply
Thanks given by:
#2
RE: Database user Remote Access from multiple IP addresses
Like putting a ":" between the IPs.
MrKaKisen - Website - GitHub
Reply
Thanks given by:
#3
RE: Database user Remote Access from multiple IP addresses
Hello? Is there anyone that has a answer to this? Thanks!
MrKaKisen - Website - GitHub
Reply
Thanks given by:
#4
RE: Database user Remote Access from multiple IP addresses
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.
Reply
Thanks given by:
#5
RE: Database user Remote Access from multiple IP addresses
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
Reply
Thanks given by:
#6
RE: Database user Remote Access from multiple IP addresses
(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!
MrKaKisen - Website - GitHub
Reply
Thanks given by:
#7
RE: Database user Remote Access from multiple IP addresses
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
-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
Reply
Thanks given by:
#8
RE: Database user Remote Access from multiple IP addresses
(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
Wink

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
MrKaKisen - Website - GitHub
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
SSH Access rsthomas 2 5 ,827 01-06-2021, 12:14 AM
Last Post: rsthomas
How to run multiple version PHP with Apache (use Sentora panel) on Centos ??? BigBang 4 9 ,178 12-23-2020, 03:31 PM
Last Post: djkashdui1
MySQL Database user prefix MosleyCale 1 5 ,596 10-17-2020, 09:11 PM
Last Post: Ron-e

Forum Jump:


Users browsing this thread: 1 Guest(s)