Connection between a cross cable + MySQL Backup

Discussion in 'Installation/Configuration' started by vaio1, Jan 22, 2010.

  1. vaio1

    vaio1 Member

    I need to connect from Server B to Server A by MySQL.
    The Servers are connected by a crosscable.

    Server A: PRODUCTION SERVER
    ===========================
    IP 192.168.0.100

    ISPCONFIG INSTALLED


    Server B: BACKUP SERVER
    =======================
    IP 192.168.0.101

    At the moment there is a NAT Rule installed in the Server A in order to share the internet connection.

    How can I connect to my Server A (Production Server) from the Server B using MySQL?

    If I execute a telnet connection I get this error:
    Code:
    # telnet 192.168.0.100 3306
    Trying 192.168.0.100...
    telnet: connect to address 192.168.0.100: Connection refused
    telnet: Unable to connect to remote host: Connection refused
    
    Thanks
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    netstat -tap | grep mysql
    on server A?
     
  3. vaio1

    vaio1 Member

    # netstat -tap | grep mysql
    tcp 0 0 server1.mydomain:mysql *:* LISTEN 21392/mysqld

    thanks
     
  4. tellar

    tellar New Member

    can the servers see eachother?

    try to ping the servers from each other.

    ping 192.168.0.100

    you can end this with ctrl c

    do you get a similar result

    64 bytes from 192.168.0.100: icmp_seq=1 ttl=64 time=0.242 ms
     
  5. vaio1

    vaio1 Member

    Solved.
    The problem was the bind configuration inside the my.cnf.

    I have commented it and I have created a new root user with the local ip permission in this way:

    Code:
    mysql> CREATE USER 'root'@'192.168.0.101' IDENTIFIED BY 'password';
    mysql> GRANT ALL ON mysql.* TO root@'192.168.0.101' IDENTIFIED BY 'password';
    
    thank you in any case!
     

Share This Page