----- Original Message ---- From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 5:00:26 AM Subject: Re: Can't Bind to Port
>Try the command: >find / -name mysql 2>/dev/null >then you will find out if you have multiple mysql installations on your system, >which I consider highly likely. # find / -name mysql 2>/dev/null find: 2: unknown option On 3 mar 2007, at 07.42, Drew Jenkins wrote: > 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/ ---- Kine dies, Kinfolk dies, and thus at last yourself This I know that never dies, how a dead mans deeds are deemed. -- Elder edda Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ____________________________________________________________________________________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news
