Re: telnet localhost 3306 Connection refused

[l'[e-mail]]

Have you checked that the user failing to connect has the right privileges?
Check the user table of mysql database to see if that user has a select 
privilege in that table.

Laurie

At 01:01 AM 7/7/2005, 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
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1