Releasing ports bound to a specific IP

[bplimpton at sopris.net]

Hello all

I’m installing snort and using acid as a front end.  The database is mysql.  
Everything is installed from ports.

Mysql started normally until I added the “–-bind-address=127.0.0.1” directive 
to my mysql-server.sh script in /usr/local/etc/rc.d/.

Now the error I receive in the hostname.err log states:

Can't start server: Bind on TCP/IP port: Can't assign requested address
Do you already have another mysqld server running on port: 3306 ?
Aborting

ps –ax dosen’t show a mysqld running
netstat –an shows nothing listening on port 3306

I’ve tried changing the port number that mysqld uses to 3308 and 3310, but I 
still get the same error about a bind on the port.

I think it has more to do with the address 127.0.0.1 than the port number.

Is there as way to reset or release all the bindings on a specific address?
My FreeBSD is 4.8 
Snort-2.1.0
MySql – version 14.3 Distrib 5.0 for ports
Acid-0.9.6b23

I’ve checked google and mysql faq’s, plus anything else I can think of.

If anyone has any ideas I would greatly appreciate it.

Thanks in advance

Ben
bplimpton at sopris.net