Re: Can't Bind to Port

[Drew Jenkins]

----- Original Message ----
From: Borokov Smith <borokov@stripped>
To: Drew Jenkins <drewjenkinsjr@stripped>
Cc: mysql@stripped
Sent: Friday, March 2, 2007 6:21:59 PM
Subject: Re: Can't Bind to Port

>netstat -nlp | grep 3306

Option p requires a protocol. What protocol should I give it?
Drew

greetz,

boro

Drew Jenkins wrote:
> 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
>   








 
____________________________________________________________________________________
Looking for earth-friendly autos? 
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/