Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : How to allow only 2 IP in SQL Host



Threaded Mode | Print  

 How to allow only 2 IP in SQL Host, how to use the plain text in webuzo database (3 Replies, Read 7310 times)
sdgoaegis
Group: Member
Post Group: Newbie
Posts: 3
Status:
Hello, So I am using Webuzo Premium with Softaculous (Premium too). The point is I am trying to allow only 2 IP to do remote SQL connection to my SQL database. I see this option Board Image

Question is, how do I write more that 2 IP? I tried comma(,), semicolon(;), and colon( :) like ???.???.???.???;???.???.???.??? but it didn't work. Any solutions?

Thanks  :D
IP: --   

How to allow only 2 IP in SQL Host
nikhil89
Group: Softaculous Team
Post Group: Elite Member
Posts: 467
Status:
Hi,

We regret to inform you that currently you cannot do the above with multiple IP's from Webuzo.

We shall check the feasibility and try to add it in future. Currently you can make a different user and grant privileges using the above process for other IP too.

Hope this helps.

Please let us know if you need any further information. We will be happy to help you.
IP: --   

How to allow only 2 IP in SQL Host
sdgoaegis
Group: Member
Post Group: Newbie
Posts: 3
Status:
Quote From : nikhil89 February 3, 2017, 1:20 pm
Hi,

We regret to inform you that currently you cannot do the above with multiple IP's from Webuzo.

We shall check the feasibility and try to add it in future. Currently you can make a different user and grant privileges using the above process for other IP too.

Hope this helps.

Please let us know if you need any further information. We will be happy to help you.


Yes, I did that too. But there are some problems.
if I use localhost from the option, Database from php can only get connected if I put "localhost" as DB Host String (using hostname or Server IP can't get you connected).

Setting to anyhost can only get me connected from my php code if I use "localhost" as host from my server code, the same problem with localhost problem, can't connect if I use hostname or server IP (this caused my to unable to connect from remote/other server)

if I use plain text and input my server IP, I can't use "localhost" as my mysqli_connect host, instead I can only use the server IP or hostname as my php code sql connect host. (phpmyadmin can't access DB).

and the last one, if I use plain text again but put remote/other server's IP, then no one can connect, remote server and phpmyadmin can't connect to my db (of course the server itself can't connect too) can't connect.

What cause this? firewall? blocking? etc?

Thanks for helping :D
IP: --   

How to allow only 2 IP in SQL Host
sdgoaegis
Group: Member
Post Group: Newbie
Posts: 3
Status:
Quote From : sdgoaegis February 3, 2017, 2:44 pm
Quote From : nikhil89 February 3, 2017, 1:20 pm
Hi,

We regret to inform you that currently you cannot do the above with multiple IP's from Webuzo.

We shall check the feasibility and try to add it in future. Currently you can make a different user and grant privileges using the above process for other IP too.

Hope this helps.

Please let us know if you need any further information. We will be happy to help you.


Yes, I did that too. But there are some problems.
if I use localhost from the option, Database from php can only get connected if I put "localhost" as DB Host String (using hostname or Server IP can't get you connected).

Setting to anyhost can only get me connected from my php code if I use "localhost" as host from my server code, the same problem with localhost problem, can't connect if I use hostname or server IP (this caused my to unable to connect from remote/other server)

if I use plain text and input my server IP, I can't use "localhost" as my mysqli_connect host, instead I can only use the server IP or hostname as my php code sql connect host. (phpmyadmin can't access DB).

and the last one, if I use plain text again but put remote/other server's IP, then no one can connect, remote server and phpmyadmin can't connect to my db (of course the server itself can't connect too) can't connect.

What cause this? firewall? blocking? etc?

Thanks for helping :D


EDIT: If I use anyhost, I can connect using hostname/server ip from the server it self but still can't connect from remote server
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 11:59 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.019