View Single Post
  #8  
Old 7th May 2010, 06:30
Sinchan Sinchan is offline
Member
 
Join Date: Nov 2006
Posts: 48
Thanks: 14
Thanked 2 Times in 2 Posts
Default

i have 2 server :
111.222.333.1 = ns1.mydomain.com
111.222.333.2 = ns2.mydomain.com

first installation in my primary and slave server, i am closed all mysql connection from the outside, and i had fail install ISPConfig in slave server using expert method.
And then, i opened mysql connection from ns2.mydomain.com with comment out bind_address in my.cnf and adding root user privileged in primary server (ns1.mydomain.com) with result like this :
mysql> select user,host from user;
+--------------------+---------------------------+
| user | host |
+--------------------+---------------------------+
| root | 127.0.0.1 |
| root | 111.222.333.2 |
| debian-sys-maint | localhost |
| root | localhost |
+------------------+---------------------------+
4 rows in set (0.00 sec)

and installation work perfectly.

my question is :
1. is it needed to open mysql connection from 111.222.333.1 in 111.222.333.2 mysql databases if iam using those server as DNS server? i means act as ns1 and ns2
2. how to setting bind_address in my.cnf so can only accept connections from 127.0.0.1, 111.222.333.1 and 111.222.333.2 ?
i had try :
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1, 111.222.333.1, 111.222.333.2

but its still didn't work
Reply With Quote