List:General Discussion« Previous MessageNext Message »
From:l'eau@mediacult.com Date:July 7 2005 9:49pm
Subject:Re: telnet localhost 3306 Connection refused
View as plain text  
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

Thread
telnet localhost 3306 Connection refusedDaevid Vincent7 Jul
Re: telnet localhost 3306 Connection refusedLouie Miranda7 Jul
Re: telnet localhost 3306 Connection refusedPhilippe Poelvoorde7 Jul
Re: telnet localhost 3306 Connection refusedAdy Wicaksono7 Jul
Re: telnet localhost 3306 Connection refusedGleb Paharenko7 Jul
  • RE: telnet localhost 3306 Connection refused [SOLVED]Daevid Vincent11 Jul
Re: telnet localhost 3306 Connection refusedl'eau@mediacult.com7 Jul