26----- Original Message ---- From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port
server312# netstat -nlap tcp | grep 3306 tcp4 0 0 *.3306 *.* LISTEN So... mysqld *is* listening on 3306? Why does it complain that the port is being used and that it can't bind to it? 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/87 ) 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 TIA, Drew ____________________________________________________________________________________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/
