On 5/13/05, Robert Vangel <[EMAIL PROTECTED]> wrote: > schnitzel meister wrote: > > On 5/13/05, Robert Vangel <[EMAIL PROTECTED]> 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)
