Re: mysql bind-address refuses to work
schnitzel meister wrote:
On 5/13/05, Robert Vangel <email@example.com> 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
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.