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: +628562208680
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]