Re: mysql bind-address refuses to work

[Robert Vangel <vangelr@rfgt.net>]

schnitzel meister wrote:
> > 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

I think that's something syslog-ng specific, can't help on that sorry.

> # /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)

I am assuming this is the /etc/mysql/my.cnf file?

Can you attach it? (Perhaps also making sure any bits you might not want 
us seeing are removed)