Re: mysql bind-address refuses to work

[schnitzel meister <schnitzelmeister@gmail.com>]

On 5/13/05, Robert Vangel <vangelr@rfgt.net> wrote:
> schnitzel meister wrote:
> > On 5/13/05, Robert Vangel <vangelr@rfgt.net> wrote:
> >
> >>schnitzelmeister wrote:
> >>
> >>>In my.cnf I have:
> >>> bind-address            = localhost
> >>>
> >>>This does not work. netstat shows the server bound to both the public
> >>>and loopback ip addresses.
> >>>
> >>>I'm running "mysql  Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) on
> >>>Sarge.
> >>>
> >>>Any ideas? Thanks
> >>>
> >>>
> >>
> >>Where do you have the bind-address?
> >>
> >>It needs to be in the [mysqld] section, and also try using 127.0.0.1
> >>instead of localhost
> >>
> >
> >
> > I have it in the [mysqld] section. 127.0.0.1 does the same thing.
> >
> 
> Can you check the mysqld.log/mysqld.err/syslog for anything? Also try
> running mysqld_safe on its own and check the output.
> 
> Please also keep the discussion on-list. Thanks.
> 

I don't have those files, but I do have mysql.err, which is empty.
syslog shows no mysql errors.
Perhaps worryingly, the messages file contains a lot of
 May 13 11:25:15 serv-1-3-152 syslog-ng[19448]: STATS: dropped 214

# /etc/init.d/syslog-ng restart

# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[712]: started

# netstat -nalp|grep sql
tcp        0      0 84.244.3.152:3306       0.0.0.0:*              
LISTEN     714/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     804845794 714/mysqld
/var/run/mysqld/mysqld.sock

(no new messages in messages)