Can't Bind to Port

[Drew Jenkins]

Hi;
I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I
changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented
out. In preparing to install my database, I got this error:

server312# mkdir /usr/local/localhost
server312# chown mysql:mysql /usr/local/localhost/
server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
070302 15:58:29  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070302 15:58:29  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070302 15:58:29  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070302 15:58:29  InnoDB: Started; log sequence number 0 0
/usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist
070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070302 15:58:29 [ERROR] Aborting

070302 15:58:30  InnoDB: Starting shutdown...
070302 15:58:32  InnoDB: Shutdown completed; log sequence number 0 46403
070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete

# ps wax|grep mysqld
 3986  p1- I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe
 4034  p1- I      0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my

server312# nmap localhost

Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC
Interesting ports on localhost.by2012.com (127.0.0.1):
Not shown: 1672 closed ports
PORT     STATE SERVICE
22/tcp   open  ssh
25/tcp   open  smtp
110/tcp  open  pop3
143/tcp  open  imap
993/tcp  open  imaps
3306/tcp open  mysql
8021/tcp open  ftp-proxy
8080/tcp open  http-proxy

I presume everything went well here until it went to bind to the port. There's no other
MySQL running on the server, so why can't it connect to the port? This server isn't yet
set up with an URL, so if it's reading from rc.conf or what have you, that could be
tripping it up. Please advise.
TIA,
Drew




 
____________________________________________________________________________________
Finding fabulous fares is fun.  
Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.
http://farechase.yahoo.com/promo-generic-14795097