Re: telnet localhost 3306 Connection refused

[Ady Wicaksono]

Try

/sbin/iptables -L -n

make sure there's no rule that block connection to/from port 3306 (TCP)


Daevid Vincent wrote:

>What is causing me to have this problem in "mysql  Ver 12.22 Distrib 4.0.24,
>for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
>localhost should it? My firewall, web, and mySQL server are the same
>machine.
>
># telnet localhost 3306
>Trying 127.0.0.1...
>telnet: Unable to connect to remote host: Connection refused
>
>I've tried to comment, uncomment and change to * this 'bind-address' line in
>/etc/mysql/my.cnf
># keep secure by default!
>#bind-address    = 127.0.0.1
>#bind-address    = *
>port            = 3306
>
>Of course, I can't connect from any of the other IP addresses that my mySQL
>server is assigned either:
>
># telnet 192.168.1.1 3306
>Trying 192.168.1.1...
>telnet: Unable to connect to remote host: Connection refused
>
># telnet 10.10.10.1 3306
>Trying 10.10.10.1...
>telnet: Unable to connect to remote host: Connection refused
>
>
># ifconfig
>eth1      Link encap:Ethernet 
>          inet addr:192.168.1.1  Bcast:192.168.1.255  Mask:255.255.255.0
>lo        Link encap:Local Loopback  
>          inet addr:127.0.0.1  Mask:255.0.0.0
>wlan0     Link encap:Ethernet    
>          inet addr:10.10.10.1  Bcast:10.255.255.255  Mask:255.255.255.0
>
>
>  
>


-- 
Regards,
Ady Wicaksono
HP: [phone]