----- Original Message ----
From: Tommy Nordgren <tommy.nordgren@stripped>
To: Drew Jenkins <drewjenkinsjr@stripped>
Cc: mysql@stripped
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 <tommy.nordgren@stripped>
> To: Drew Jenkins <drewjenkinsjr@stripped>
> Cc: mysql@stripped
> 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
tommy.nordgren@stripped
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
____________________________________________________________________________________
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
