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.
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]
