Home / ubuntu / Questions / 122662
Accepted
Mohammad Moghimi
Asked: 2012-04-17 12:48:49 +0800 CST

Different responses when telnetting into mysql's port via hostname

  • 772

I'm trying to connect to mysql server installed on my computer.

When I enter "telnet localhost 3306", I get some garbage characters meaning that I'm connected to the server.

But when I enter "telnet my_computer_name 3306", I am getting this error:

Trying 127.0.1.1...
telnet: Unable to connect to remote host: Connection refused

I know that I has something to do with the firewall.

I also pasted output of my iptables-save here: http://pastebin.com/rKMc1bG8

I tried to add a rule to accept incoming connecting to 3306 but no success. Any fix?

mysql firewall

1 Answers

  1. Best Answer

    It is not a problem with your firewall, it is an issue of mysql.

    Edit /etc/mysql/my.cnf , change the bind-address

    bind-address = 127.0.0.1

    To your local ipaddress

    bind-address     = your_ip_address

    Restart the mysql or reboot.

    • 2