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
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
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!