Re: Can't Bind to Port

[Borokov Smith]

netstat -nlp | grep 3306

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
>