Re: Can't Bind to Port

[Drew Jenkins]

26----- Original Message ----
From: "replies-lists-a1z2-mysql@stripped"
<replies-lists-a1z2-mysql@stripped>
To: Drew Jenkins <drewjenkinsjr@stripped>
Sent: Saturday, March 3, 2007 10:53:45 AM
Subject: Re: Can't Bind to Port

>kill off the first instance, the port will/should free up and then you
>can start your [second] instance.

# ps wax|grep mysqld
 3986  p1- I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe
 4034  p1- S      0:11.21 /usr/local/libexec/mysqld --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my
# kill -9 3986
# kill -9 4034
# ps wax | grep mysqld
# netstat -nlap tcp | grep 3306
# /usr/local/bin/mysqld_safe &
[1] 14836
# Starting mysqld daemon with databases from /var/db/mysql

# ps wax|grep mysqld
14836  p1  I      0:00.01 /bin/sh /usr/local/bin/mysqld_safe
14887  p1  I      0:00.15 /usr/local/libexec/mysqld --basedir=/usr/local
--datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my
# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M
070303  9:03:10  InnoDB: Started; log sequence number 0 46403
/usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist
070303  9:03:10 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
070303  9:03:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070303  9:03:10 [ERROR] Aborting


Am I missing something here?
TIA,
Drew






 
____________________________________________________________________________________
The fish are biting. 
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php