Can"t Bind to Port

--0-1000563165-1172873009=:38863
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi;=0AI just installed MySQL from FreeBSD port. I specified using openssl. =
Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, le=
aving the innodb stuff commented out. In preparing to install my database, =
I got this error: server312# mkdir /usr/local/localhost=0Aserver312# c=
hown mysql:mysql /usr/local/localhost/=0Aserver312# /usr/local/libexec/mysq=
ld -uroot -hlocalhost --max_allowed_packet=3D999M=0AInnoDB: The first speci=
fied data file ./ibdata1 did not exist:=0AInnoDB: a new database to be crea=
ted!=0A070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB=0AInno=
DB: Database physically writes the file full: wait...=0A070302 15:58:29 In=
noDB: Log file ./ib_logfile0 did not exist: new to be created=0AInnoDB: Set=
ting log file ./ib_logfile0 size to 5 MB=0AInnoDB: Database physically writ=
es the file full: wait...=0A070302 15:58:29 InnoDB: Log file ./ib_logfile1=
did not exist: new to be created=0AInnoDB: Setting log file ./ib_logfile1 =
size to 5 MB=0AInnoDB: Database physically writes the file full: wait...=0A=
InnoDB: Doublewrite buffer not found: creating new=0AInnoDB: Doublewrite bu=
ffer created=0AInnoDB: Creating foreign key constraint system tables=0AInno=
DB: Foreign key constraint system tables created=0A070302 15:58:29 InnoDB:=
Started; log sequence number 0 0=0A/usr/local/libexec/mysqld: Table 'mysql=
..general_log' doesn't exist=0A070302 15:58:29 [ERROR] Can't start server: B=
ind on TCP/IP port: Address already in use=0A070302 15:58:29 [ERROR] Do you=
already have another mysqld server running on port: 3306 ?=0A070302 15:58:=
29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown...=0A07=
0302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403=0A07=
0302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps=
wax|grep mysqld=0A 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_=
safe=0A 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=3D/usr=
/local --datadir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var/db/my=0A=
=0Aserver312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.=
org/nmap/ ) at 2007-03-02 16:02 UTC=0AInteresting ports on localhost.by2012=
..com (127.0.0.1):=0ANot shown: 1672 closed ports=0APORT STATE SERVICE=
=0A22/tcp open ssh=0A25/tcp open smtp=0A110/tcp open pop3=0A143/tcp=
open imap=0A993/tcp open imaps=0A3306/tcp open mysql=0A8021/tcp open =
ftp-proxy=0A8080/tcp open http-proxy I presume everything went well =
here until it went to bind to the port. There's no other MySQL running on t=
he server, so why can't it connect to the port? This server isn't yet set u=
p with an URL, so if it's reading from rc.conf or what have you, that could=
be tripping it up. Please advise.=0ATIA,=0ADrew =0A =0A________=
____________________________________________________________ _______________=
_=0AFinding fabulous fares is fun. =0ALet Yahoo! FareChase search your fav=
orite travel sites to find flight and hotel bargains.=0Ahttp://farechase.ya=
hoo.com/promo-generic-14795097
--0-1000563165-1172873009=:38863--

Re: Can"t Bind to Port

netstat -nlp | grep 3306

greetz,

boro

Drew Jenkins wrote:
> Hi;
> I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this error:
>
> 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/ ) 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
>
> I presume everything went well here until it went to bind to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise.
> TIA,
> Drew
>
>
>
>
>
> ____________________________________________________________ ________________________
> Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.
> http://farechase.yahoo.com/promo-generic-14795097
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Can"t Bind to Port

--0-1821318012-1172876534=:85069
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Borokov Smith =0ATo:=
Drew Jenkins =0ACc: mysql@lists.mysql.com=0ASent:=
Friday, March 2, 2007 6:21:59 PM=0ASubject: Re: Can't Bind to Port >n=
etstat -nlp | grep 3306 Option p requires a protocol. What protocol sh=
ould I give it?=0ADrew greetz, boro Drew Jenkins wrote:=0A> =
Hi;=0A> I just installed MySQL from FreeBSD port. I specified using openssl=
.. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, =
leaving the innodb stuff commented out. In preparing to install my database=
, I got this error:=0A>=0A> server312# mkdir /usr/local/localhost=0A> serve=
r312# chown mysql:mysql /usr/local/localhost/=0A> server312# /usr/local/lib=
exec/mysqld -uroot -hlocalhost --max_allowed_packet=3D999M=0A> InnoDB: The =
first specified data file ./ibdata1 did not exist:=0A> InnoDB: a new databa=
se to be created!=0A> 070302 15:58:29 InnoDB: Setting file ./ibdata1 size =
to 10 MB=0A> InnoDB: Database physically writes the file full: wait...=0A> =
070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be cr=
eated=0A> InnoDB: Setting log file ./ib_logfile0 size to 5 MB=0A> InnoDB: D=
atabase physically writes the file full: wait...=0A> 070302 15:58:29 InnoD=
B: Log file ./ib_logfile1 did not exist: new to be created=0A> InnoDB: Sett=
ing log file ./ib_logfile1 size to 5 MB=0A> InnoDB: Database physically wri=
tes the file full: wait...=0A> InnoDB: Doublewrite buffer not found: creati=
ng new=0A> InnoDB: Doublewrite buffer created=0A> InnoDB: Creating foreign =
key constraint system tables=0A> InnoDB: Foreign key constraint system tabl=
es created=0A> 070302 15:58:29 InnoDB: Started; log sequence number 0 0=0A=
> /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist=0A> 07=
0302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address alre=
ady in use=0A> 070302 15:58:29 [ERROR] Do you already have another mysqld s=
erver running on port: 3306 ?=0A> 070302 15:58:29 [ERROR] Aborting=0A>=0A> =
070302 15:58:30 InnoDB: Starting shutdown...=0A> 070302 15:58:32 InnoDB: =
Shutdown completed; log sequence number 0 46403=0A> 070302 15:58:32 [Note] =
/usr/local/libexec/mysqld: Shutdown complete=0A>=0A> # ps wax|grep mysqld=
=0A> 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe=0A> 4034=
p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=3D/usr/local --dat=
adir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var/db/my=0A>=0A> server3=
12# nmap localhost=0A>=0A> Starting Nmap 4.11 ( http://www.insecure.org/nma=
p/ ) at 2007-03-02 16:02 UTC=0A> Interesting ports on localhost.by2012.com =
(127.0.0.1):=0A> Not shown: 1672 closed ports=0A> PORT STATE SERVICE=0A=
> 22/tcp open ssh=0A> 25/tcp open smtp=0A> 110/tcp open pop3=0A> 14=
3/tcp open imap=0A> 993/tcp open imaps=0A> 3306/tcp open mysql=0A> 802=
1/tcp open ftp-proxy=0A> 8080/tcp open http-proxy=0A>=0A> I presume every=
thing went well here until it went to bind to the port. There's no other My=
SQL running on the server, so why can't it connect to the port? This server=
isn't yet set up with an URL, so if it's reading from rc.conf or what have=
you, that could be tripping it up. Please advise.=0A> TIA,=0A> Drew=0A>=0A=
>=0A>=0A>=0A> =0A> _______________________________________________________=
_____________________________=0A> Finding fabulous fares is fun. =0A> Let =
Yahoo! FareChase search your favorite travel sites to find flight and hotel=
bargains.=0A> http://farechase.yahoo.com/promo-generic-14795097=0A> =0A=
=0A_______________________________________________=
_____________________________________=0ALooking for earth-friendly autos? =
=0ABrowse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.=0Ahttp:=
//autos.yahoo.com/green_center/
--0-1821318012-1172876534=:85069--

Re: Can"t Bind to Port

Drew Jenkins wrote:
> ----- Original Message ----
> From: Borokov Smith
> To: Drew Jenkins
> Cc: mysql@lists.mysql.com
> Sent: Friday, March 2, 2007 6:21:59 PM
> Subject: Re: Can't Bind to Port
>
>
>> netstat -nlp | grep 3306
>>
>
> Option p requires a protocol. What protocol should I give it?
> Drew
>

Maybe on FreeBSD :)
do netstat -nl | grep 3306 then

it should show you which process is occupying port 3306.
and you can take it up from there.

greetz,

boro




> greetz,
>
> boro
>
> Drew Jenkins wrote:
>
>> Hi;
>> I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this error:
>>
>> 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/ ) 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
>>
>> I presume everything went well here until it went to bind to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise.
>> TIA,
>> Drew
>>
>>
>>
>>
>>
>> ____________________________________________________________ ________________________
>> Finding fabulous fares is fun.
>> Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains.
>> http://farechase.yahoo.com/promo-generic-14795097
>>
>>
>
>
>
>
>
>
>
>
>
> ____________________________________________________________ ________________________
> Looking for earth-friendly autos?
> Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
> http://autos.yahoo.com/green_center/
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Can"t Bind to Port

--0-1093494121-1172877669=:67336
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Oops. Forgot to add I passed it tcp as the protocol and it returned blank:=
# netstat -nlp tcp| grep 3306=0A# I presume that means nothing's=
listening on that port? If so, then why did nmap return mysql on that port=
? At any rate, what do?=0ATIA,=0ADrew =0A =0A___________________=
____________________________________________________________ _____=0ANow tha=
t's room service! Choose from over 150,000 hotels=0Ain 45,000 destinations=
on Yahoo! Travel to find your fit.=0Ahttp://farechase.yahoo.com/promo-gene=
ric-14795097
--0-1093494121-1172877669=:67336--

Re: Can"t Bind to Port

On 3 mar 2007, at 00.21, Drew Jenkins wrote:

> Oops. Forgot to add I passed it tcp as the protocol and it returned
> blank:
>
> # netstat -nlp tcp| grep 3306
> #
>
> I presume that means nothing's listening on that port? If so, then
> why did nmap return mysql on that port? At any rate, what do?
> TIA,
> Drew
>
>
>
>
>
You need to add the -a option to netstat, to show server processes

------
What is a woman that you forsake her, and the hearth fire and the
home acre,
to go with the old grey Widow Maker. --Kipling, harp song of the
Dane women
Tommy Nordgren
tommy.nordgren@comhem.se




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Can"t Bind to Port

--0-992652723-1172904172=:68327
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

26----- Original Message ----=0AFrom: Tommy Nordgren ..se>=0ATo: Drew Jenkins =0ACc: mysql@lists.mysql.c=
om=0ASent: Friday, March 2, 2007 7:32:16 PM=0ASubject: Re: Can't Bind to Po=
rt =0Aserver312# netstat -nlap tcp | grep 3306=0Atcp4 0 0 =
*.3306 =0A *.* 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=0Aser=
ver312# chown mysql:mysql /usr/local/localhost/=0Aserver312# /usr/local/lib=
exec/mysqld -uroot -hlocalhost --max_allowed_packet=3D999M=0AInnoDB: The fi=
rst specified data file ./ibdata1 did not exist:=0AInnoDB: a new database t=
o be created!=0A070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 =
MB=0AInnoDB: Database physically writes the file full: wait...=0A070302 15:=
58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created=0AIn=
noDB: Setting log file ./ib_logfile0 size to 5 MB=0AInnoDB:=0A Database phy=
sically writes the file full: wait...=0A070302 15:58:29 InnoDB: Log file .=
/ib_logfile1 did not exist: new to be created=0AInnoDB: Setting log file ./=
ib_logfile1 size to 5 MB=0AInnoDB: Database physically writes the file full=
: wait...=0AInnoDB: Doublewrite buffer not found: creating new=0AInnoDB: Do=
ublewrite buffer created=0AInnoDB: Creating foreign key constraint system t=
ables=0AInnoDB: Foreign key constraint system tables created=0A070302 15:58=
:29 InnoDB: Started; log sequence number 0 0=0A/usr/local/libexec/mysqld: =
Table 'mysql.general_log' doesn't exist=0A070302 15:58:29 [ERROR] Can't sta=
rt server: Bind on TCP/IP port: Address already in use=0A070302 15:58:29 [E=
RROR] Do you already have another mysqld server running on port: 3306 ?=0A0=
70302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shut=
down...=0A070302 15:58:32 InnoDB: Shutdown completed; log sequence number =
0 46403=0A070302 15:58:32 [Note]=0A /usr/local/libexec/mysqld: Shutdown com=
plete # ps wax|grep mysqld=0A 3986 p1- I 0:00.01 /bin/sh /usr/lo=
cal/bin/mysqld_safe=0A 4034 =0Ap1- I 0:11.16 /usr/local/libexec/mysqld=
--basedir=3D/usr/local=0A--datadir=3D/var/db/mysql --user=3Dmysql --pid-fi=
le=3D/var/db/my server312# nmap localhost Starting Nmap 4.11 ( ht=
tp://www.insecure.org/nmap/87 ) at 2007-03-02 16:02 UTC=0AInteresting ports=
on localhost.by2012.com (127.0.0.1):=0ANot shown: 1672 closed ports=0APORT=
STATE SERVICE=0A22/tcp open ssh=0A25/tcp open smtp=0A110/tcp op=
en pop3=0A143/tcp open imap=0A993/tcp open imaps=0A3306/tcp open mysq=
l=0A8021/tcp open ftp-proxy=0A8080/tcp open http-proxy =0ATIA,=0ADre=
w =0A =0A___________________________________________=
_________________________________________=0AIt's here! Your new message! =
=0AGet new email alerts with the free Yahoo! Toolbar.=0Ahttp://tools.search=
..yahoo.com/toolbar/features/mail/
--0-992652723-1172904172=:68327--

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.

On 3 mar 2007, at 07.42, Drew Jenkins wrote:

> 26----- Original Message ----
> From: Tommy Nordgren
> To: Drew Jenkins
> 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
tommy.nordgren@comhem.se




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Can"t Bind to Port

--0-1566459103-1172930726=:72692
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Tommy Nordgren e>=0ATo: Drew Jenkins =0ACc: mysql@lists.mysql.com=
=0ASent: Saturday, March 3, 2007 5:00:26 AM=0ASubject: Re: Can't Bind to Po=
rt >Try the command: >find / -name mysql 2>/dev/null=0A>then you =
will find out if you have multiple mysql installations on =0Ayour system,=
=0A>which I consider highly likely. # find / -name mysql 2>/dev/null=
=0Afind: 2: unknown option On 3 mar 2007, at 07.42, Drew Jenkins wrote=
: > 26----- Original Message ----=0A> From: Tommy Nordgren gren@comhem.se>=0A> To: Drew Jenkins =0A> Cc: mysq=
l@lists.mysql.com=0A> Sent: Friday, March 2, 2007 7:32:16 PM=0A> Subject: R=
e: Can't Bind to Port=0A>=0A>=0A> server312# netstat -nlap tcp | grep 3306=
=0A> tcp4 0 0 *.3306=0A> *.* LISTEN=0A>=0A>=
So... mysqld *is* listening on 3306? Why does it complain that the =0A> p=
ort is being used and that it can't bind to it?=0A>=0A> server312# mkdir /u=
sr/local/localhost=0A> server312# chown mysql:mysql /usr/local/localhost/=
=0A> server312# /usr/local/libexec/mysqld -uroot -hlocalhost -- =0A> max_al=
lowed_packet=3D999M=0A> InnoDB: The first specified data file ./ibdata1 did=
not exist:=0A> InnoDB: a new database to be created!=0A> 070302 15:58:29 =
InnoDB: Setting file ./ibdata1 size to 10 MB=0A> InnoDB: Database physicall=
y writes the file full: wait...=0A> 070302 15:58:29 InnoDB: Log file ./ib_=
logfile0 did not exist: new =0A> to be created=0A> InnoDB: Setting log fil=
e ./ib_logfile0 size to 5 MB=0A> InnoDB:=0A> Database physically writes th=
e file full: wait...=0A> 070302 15:58:29 InnoDB: Log file ./ib_logfile1 di=
d not exist: new =0A> to be created=0A> InnoDB: Setting log file ./ib_logf=
ile1 size to 5 MB=0A> InnoDB: Database physically writes the file full: wai=
t...=0A> InnoDB: Doublewrite buffer not found: creating new=0A> InnoDB: Dou=
blewrite buffer created=0A> InnoDB: Creating foreign key constraint system =
tables=0A> InnoDB: Foreign key constraint system tables created=0A> 070302 =
15:58:29 InnoDB: Started; log sequence number 0 0=0A> /usr/local/libexec/m=
ysqld: Table 'mysql.general_log' doesn't exist=0A> 070302 15:58:29 [ERROR] =
Can't start server: Bind on TCP/IP port: =0A> Address already in use=0A> 0=
70302 15:58:29 [ERROR] Do you already have another mysqld server =0A> runn=
ing on port: 3306 ?=0A> 070302 15:58:29 [ERROR] Aborting=0A>=0A> 070302 15:=
58:30 InnoDB: Starting shutdown...=0A> 070302 15:58:32 InnoDB: Shutdown c=
ompleted; log sequence number 0 =0A> 46403=0A> 070302 15:58:32 [Note]=0A> =
/usr/local/libexec/mysqld: Shutdown complete=0A>=0A> # ps wax|grep mysqld=
=0A> 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe=0A> 4034=
=0A> p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=3D/usr/local=0A=
> --datadir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var/db/my=0A>=0A> =
server312# nmap localhost=0A>=0A> Starting Nmap 4.11 ( http://www.insecure.=
org/nmap/87 ) at =0A> 2007-03-02 16:02 UTC=0A> Interesting ports on localh=
ost.by2012.com (127.0.0.1):=0A> Not shown: 1672 closed ports=0A> PORT S=
TATE SERVICE=0A> 22/tcp open ssh=0A> 25/tcp open smtp=0A> 110/tcp op=
en pop3=0A> 143/tcp open imap=0A> 993/tcp open imaps=0A> 3306/tcp open=
mysql=0A> 8021/tcp open ftp-proxy=0A> 8080/tcp open http-proxy=0A>=0A>=
=0A> TIA,=0A> Drew=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A>=0A> ________________=
______________________________________________________ =0A> ______________=
=0A> It's here! Your new message!=0A> Get new email alerts with the free Ya=
hoo! Toolbar.=0A> http://tools.search.yahoo.com/toolbar/features/mail/=0A=
=0A----=0AKine dies, Kinfolk dies, and thus at last yourself=0AThis I know =
that never dies, how a dead mans deeds are deemed. -- =0AElder edda=0ATomm=
y Nordgren=0Atommy.nordgren@comhem.se =0A-- =0AMySQL General Mai=
ling List=0AFor list archives: http://lists.mysql.com/mysql=0ATo unsubscrib=
e: http://lists.mysql.com/mysql?unsub=3Ddrewjenkinsjr@yahoo.com =0A=
=0A_____________________________________________________=
_______________________________=0A8:00? 8:25? 8:40? Find a flick in no time=
=0Awith the Yahoo! Search movie showtime shortcut.=0Ahttp://tools.search.y=
ahoo.com/shortcuts/#news
--0-1566459103-1172930726=:72692--

Re: Can"t Bind to Port

--0-1106957229-1172932276=:33655
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: ed =0ATo: Drew Je=
nkins =0ASent: Saturday, March 3, 2007 10:24:54 AM=
=0ASubject: Re: Can't Bind to Port >be root/superuser;=0A>try it as "f=
ind / -name mysql" and then, (as in 2nd) send they instances =0A>of mysql t=
hat you do not want to /dev/null=0A>this assumes a *nix not MS WIndows inst=
all, I do believe... # find / -name mysql=0A/usr/local/bin/mysql=0A/us=
r/local/include/mysql=0A/usr/local/lib/mysql=0A/usr/local/li bdata/ldconfig/=
mysql=0A/usr/local/share/mysql=0A/usr/backup/usr/local/inclu de/mysql=0A/var=
/db/mysql=0A/var/db/mysql/mysql I believe I want all of those ;)=0ATIA=
,=0ADrew > Tommy Nordgren=0A> tommy.nordgren@comhem.se=0A>=0A>=0A>=0A>=
=0A> =0A =0A_____________________________________=
_______________________________________________=0AFood fight? Enjoy some he=
althy debate =0Ain the Yahoo! Answers Food & Drink Q&A.=0Ahttp://answers.ya=
hoo.com/dir/?link=3Dlist&sid=3D396545367
--0-1106957229-1172932276=:33655--

Re: Can"t Bind to Port

--0-376386466-1172934296=:46296
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

26----- Original Message ----=0AFrom: "replies-lists-a1z2-mysql@listmail.in=
novate.net" =0ATo: Drew Jen=
kins =0ASent: Saturday, March 3, 2007 10:53:45 AM=
=0ASubject: Re: Can't Bind to Port >kill off the first instance, the p=
ort will/should free up and then you=0A>can start your [second] instance.=
# ps wax|grep mysqld=0A 3986 p1- I 0:00.01 /bin/sh /usr/local/b=
in/mysqld_safe=0A 4034 p1- S 0:11.21 /usr/local/libexec/mysqld --base=
dir=3D/usr/local --datadir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var=
/db/my=0A# kill -9 3986=0A# kill -9 4034=0A# ps wax | grep mysqld=0A# netst=
at -nlap tcp | grep 3306=0A# /usr/local/bin/mysqld_safe &=0A[1] 14836=0A# S=
tarting mysqld daemon with databases from /var/db/mysql # ps wax|grep =
mysqld=0A14836 p1 I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe=0A148=
87 p1 I 0:00.15 /usr/local/libexec/mysqld --basedir=3D/usr/local --d=
atadir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var/db/my=0A# /usr/loca=
l/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=3D999M=0A070303 9=
:03:10 InnoDB: Started; log sequence number 0 46403=0A/usr/local/libexec/m=
ysqld: Table 'mysql.general_log' doesn't exist=0A070303 9:03:10 [ERROR] Ca=
n't start server: Bind on TCP/IP port: Address already in use=0A070303 9:0=
3:10 [ERROR] Do you already have another mysqld server running on port: 330=
6 ?=0A070303 9:03:10 [ERROR] Aborting =0AAm I missing something here?=
=0ATIA,=0ADrew =0A =0A____________________________________=
________________________________________________=0AThe fish are biting. =0A=
Get more visitors on your site using Yahoo! Search Marketing.=0Ahttp://sear=
chmarketing.yahoo.com/arp/sponsoredsearch_v2.php
--0-376386466-1172934296=:46296--

Re: Can"t Bind to Port

--0-159563625-1172936587=:54890
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: "replies-lists-a1z2-mysql@listmail.inno=
vate.net" =0ATo: Drew Jenki=
ns =0ASent: Saturday, March 3, 2007 11:25:37 AM=0A=
Subject: Re: Can't Bind to Port I rebooted, then... server312# ps=
wax|grep mysqld=0Aserver312# /usr/local/bin/mysqld_safe &=0A[1] 801=0Aserv=
er312# Starting mysqld daemon with databases from /var/db/mysql server=
312# ps wax | grep mysqld=0A 801 p0 S 0:00.01 /bin/sh /usr/local/bi=
n/mysqld_safe=0A 849 p0 S 0:00.16 /usr/local/libexec/mysqld --based=
ir=3D/usr/local --datadir=3D/var/db/mysql --user=3Dmysql --pid-file=3D/var/=
db/my=0Aserver312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allow=
ed_packet=3D999M=0A070303 9:42:18 InnoDB: Started; log sequence number 0 =
46403=0A/usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist=
=0A070303 9:42:18 [ERROR] Can't start server: Bind on TCP/IP port: Address=
already in use=0A070303 9:42:18 [ERROR] Do you already have another mysql=
d server running on port: 3306 ?=0A070303 9:42:18 [ERROR] Aborting 07=
0303 9:42:18 InnoDB: Starting shutdown...=0A070303 9:42:20 InnoDB: Shut=
down completed; log sequence number 0 46403=0A070303 9:42:20 [Note] /usr/l=
ocal/libexec/mysqld: Shutdown complete I must be the only person in th=
is conversation that remains unconvinced that there are *two* mysql servers=
running.=0ATIA,=0ADrew =0A______________________________=
______________________________________________________=0ABe a PS3 game guru=
..=0AGet your game face on with the latest PS3 news and previews at Yahoo! G=
ames.=0Ahttp://videogames.yahoo.com/platform?platform=3D1201 21
--0-159563625-1172936587=:54890--

Re: Can"t Bind to Port

--0-1419174001-1172939529=:75369
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: "replies-lists-a1z2-mysql@listmail.inno=
vate.net" =0ATo: Drew Jenki=
ns =0ASent: Saturday, March 3, 2007 12:03:40 PM=0A=
Subject: Re: Can't Bind to Port >At this point, make=0A>certain that t=
he mysql instance that you started (pid 801) is shut down=0A>properly, then=
probe at port 3306 to see what's going on. it's possible=0A>that you have =
some other application that's taking over that port. # kill -9 8=
01=0A[1] Killed /usr/local/bin/mysqld_safe=0A# ne=
tstat -nl|grep 3306=0A# Ed suggests it's a permissions problem. Since =
I've had a sea of permissions problems to deal with, I bet he's right. What=
files/ folders should I check for permissions, and what should those permi=
ssions be?=0ATIA,=0ADrew =0A =0A________________________________=
____________________________________________________=0ASucke r-punch spam wi=
th award-winning protection. =0ATry the free Yahoo! Mail Beta.=0Ahttp://adv=
ision.webevents.yahoo.com/mailbeta/features_spam.html
--0-1419174001-1172939529=:75369--

Re: Can"t Bind to Port

On 3 mar 2007, at 15.31, Drew Jenkins wrote:

> ----- Original Message ----
> From: ed
> To: Drew Jenkins
> Sent: Saturday, March 3, 2007 10:24:54 AM
> Subject: Re: Can't Bind to Port
>
>> be root/superuser;
>> try it as "find / -name mysql" and then, (as in 2nd) send they
>> instances
>> of mysql that you do not want to /dev/null
>> this assumes a *nix not MS WIndows install, I do believe...
>
> # find / -name mysql
> /usr/local/bin/mysql
> /usr/local/include/mysql
> /usr/local/lib/mysql
> /usr/local/libdata/ldconfig/mysql
> /usr/local/share/mysql
> /usr/backup/usr/local/include/mysql
> /var/db/mysql
> /var/db/mysql/mysql
>
> I believe I want all of those ;)
> TIA,
> Drew
>
There is no need to be superuser to run find. But there can be problems
if there is another find command earlier in the PATH, than the
standard unix find utility.
Try running :
/usr/bin/find / -name 'mysqld' 2>/dev/null

This will show if you have multiple instances of the mysqld server
daemon on your system.
the syntax 2>/dev/null
redirects standard error to /dev/null,
skipping error messages about unaccessible directories
----
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@comhem.se




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Can"t Bind to Port

--0-1396806298-1172940524=:40338
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Tommy Nordgren e>=0ATo: Drew Jenkins =0ACc: mysql@lists.mysql.com=
=0ASent: Saturday, March 3, 2007 12:34:37 PM=0ASubject: Re: Can't Bind to P=
ort =0A>There is no need to be superuser to run find. But there can be=
problems=0A>if there is another find command earlier in the PATH, than the=
=0A>standard unix find utility.=0A>Try running :=0A>/usr/bin/find / -name=
'mysqld' 2>/dev/null # /usr/bin/find / -name 'mysqld' 2>/dev/null=
=0Afind: 2: unknown option Again, it just doesn't like the"2". As Ed s=
uggested, I really believe it's probably a permissions problem, but I don't=
know what to look for or what to change it to.=0ATIA,=0ADrew =
=0A_________________________________________________________ __=
_________________________=0ANeed Mail bonding?=0AGo to the Yahoo! Mail Q&A =
for great tips from Yahoo! Answers users.=0Ahttp://answers.yahoo.com/dir/?l=
ink=3Dlist&sid=3D396546091
--0-1396806298-1172940524=:40338--

Re: Can"t Bind to Port

--0-239746874-1172941807=:2655
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Tommy Nordgren e>=0ATo: Drew Jenkins =0ASent: Saturday, March 3, =
2007 1:03:30 PM=0ASubject: Re: Can't Bind to Port =0A>You are probably=
using another shell than bash or another sh variant. No, I'm us=
ing bash...the standard shell. Didn't do anything fancy when I built out th=
is server. Isn't there some other command(s) I could use to achieve the sam=
e effect?=0ATIA,=0ADrew =0A =0A_________________________________=
___________________________________________________=0A8:00? 8:25? 8:40? Fin=
d a flick in no time =0Awith the Yahoo! Search movie showtime shortcut.=0Ah=
ttp://tools.search.yahoo.com/shortcuts/#news
--0-239746874-1172941807=:2655--

Re: Can"t Bind to Port

--0-276628478-1172942697=:30640
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: ed =0ATo: Drew Je=
nkins =0ASent: Saturday, March 3, 2007 1:06:16 PM=
=0ASubject: Re: Can't Bind to Port None of those directories existed o=
n my system. So I decided to try and find the ones to which you referred. T=
he matches were inexact. Now, before I go changing permissions and regret a=
mistake, please advise me according to the following: # find / -name =
mysqld=0A/usr/local/libexec/mysqld=0A# find / -name mysql=0A/usr/local/bin/=
mysql=0A/usr/local/include/mysql=0A/usr/local/lib/mysql=0A/u sr/local/libdat=
a/ldconfig/mysql=0A/usr/local/share/mysql=0A/var/db/mysql=0A /var/db/mysql/m=
ysql=0A# ls -al /usr/local/libexec/mysqld=0A-r-xr-xr-x 1 root wheel 5035=
236 Mar 1 06:53 /usr/local/libexec/mysqld=0A# ls -al /usr/local/bin/mysql=
=0A-r-xr-xr-x 1 root wheel 65644 Mar 1 06:37 /usr/local/bin/mysql=0A# l=
s -al /usr/local/include/mysql=0Atotal 348=0Adrwxr-xr-x 2 root wheel 1=
024 Mar 1 06:37 .=0Adrwxr-xr-x 10 root wheel 1536 Mar 1 06:37 ..=0A-r=
--r--r-- 1 root wheel 3785 Mar 1 06:37 errmsg.h=0A-r--r--r-- 1 root=
wheel 6778 Mar 1 06:37 keycache.h=0A-r--r--r-- 1 root wheel 20593 =
Mar 1 06:37 m_ctype.h=0A-r--r--r-- 1 root wheel 7683 Mar 1 06:37 m_s=
tring.h=0A-r--r--r-- 1 root wheel 1859 Mar 1 06:37 my_alloc.h=0A-r--r=
--r-- 1 root wheel 31704 Mar 1 06:37 my_config.h=0A-r--r--r-- 1 root=
wheel 4496 Mar 1 06:37 my_dbug.h=0A-r--r--r-- 1 root wheel 3509 M=
ar 1 06:37 my_dir.h=0A-r--r--r-- 1 root wheel 3000 Mar 1 06:37 my_ge=
topt.h=0A-r--r--r-- 1 root wheel 46625 Mar 1 06:37 my_global.h=0A-r--r=
--r-- 1 root wheel 1515 Mar 1 06:37 my_list.h=0A-r--r--r-- 1 root =
wheel 3611 Mar 1 06:37 my_net.h=0A-r--r--r-- 1 root wheel 1591 Mar =
1 06:37 my_no_pthread.h=0A-r--r--r-- 1 root wheel 23125 Mar 1 06:37 m=
y_pthread.h=0A-r--r--r-- 1 root wheel 1784 Mar 1 06:37 my_semaphore.h=
=0A-r--r--r-- 1 root wheel 36574 Mar 1 06:37 my_sys.h=0A-r--r--r-- 1=
root wheel 2710 Mar 1 06:37 my_xml.h=0A-r--r--r-- 1 root wheel 331=
80 Mar 1 06:37 mysql.h=0A-r--r--r-- 1 root wheel 17215 Mar 1 06:37 my=
sql_com.h=0A-r--r--r-- 1 root wheel 1224 Mar 1 06:37 mysql_embed.h=0A=
-r--r--r-- 1 root wheel 2184 Mar 1 06:37 mysql_time.h=0A-r--r--r-- =
1 root wheel 800 Mar 1 06:37 mysql_version.h=0A-r--r--r-- 1 root wh=
eel 20111 Mar 1 06:37 mysqld_ername.h=0A-r--r--r-- 1 root wheel 20166=
Mar 1 06:37 mysqld_error.h=0A-r--r--r-- 1 root wheel 9766 Mar 1 06:=
37 plugin.h=0A-r--r--r-- 1 root wheel 1751 Mar 1 06:37 sql_common.h=
=0A-r--r--r-- 1 root wheel 11049 Mar 1 06:37 sql_state.h=0A-r--r--r-- =
1 root wheel 1055 Mar 1 06:37 sslopt-case.h=0A-r--r--r-- 1 root wh=
eel 2212 Mar 1 06:37 sslopt-longopts.h=0A-r--r--r-- 1 root wheel 11=
56 Mar 1 06:37 sslopt-vars.h=0A-r--r--r-- 1 root wheel 1265 Mar 1 06=
:37 typelib.h=0A# ls -al /usr/local/lib/mysql=0Atotal 5770=0Adrwxr-xr-x 2=
root wheel 512 Mar 1 06:52 .=0Adrwxr-xr-x 12 root wheel 2560 =
Mar 1 06:37 ..=0A-r--r--r-- 1 root wheel 13338 Mar 1 06:52 libdbug.=
a=0A-r--r--r-- 1 root wheel 42044 Mar 1 06:52 libheap.a=0A-r--r--r--=
1 root wheel 320090 Mar 1 06:52 libmyisam.a=0A-r--r--r-- 1 root w=
heel 24866 Mar 1 06:52 libmyisammrg.a=0A-rw-r--r-- 1 root wheel 133=
1032 Mar 1 06:37 libmysqlclient.a=0A-rwxr-xr-x 1 root wheel 896 Ma=
r 1 06:37 libmysqlclient.la=0Alrwxr-xr-x 1 root wheel 20 Mar 1 0=
6:37 libmysqlclient.so -> libmysqlclient.so.15=0A-rwxr-xr-x 1 root wheel=
1030523 Mar 1 06:37 libmysqlclient.so.15=0A-rw-r--r-- 1 root wheel 1=
338384 Mar 1 06:37 libmysqlclient_r.a=0A-rwxr-xr-x 1 root wheel 92=
8 Mar 1 06:37 libmysqlclient_r.la=0Alrwxr-xr-x 1 root wheel 22 Ma=
r 1 06:37 libmysqlclient_r.so -> libmysqlclient_r.so.15=0A-rwxr-xr-x 1 r=
oot wheel 1036507 Mar 1 06:37 libmysqlclient_r.so.15=0A-r--r--r-- 1 ro=
ot wheel 299208 Mar 1 06:52 libmystrings.a=0A-r--r--r-- 1 root wheel=
268090 Mar 1 06:52 libmysys.a=0A-r--r--r-- 1 root wheel 12290 Mar=
1 06:52 libvio.a=0A# ls -al /usr/local/libdata/ldconfig/mysql=0A-rw-r--r-=
- 1 root wheel 21 Mar 1 06:37 /usr/local/libdata/ldconfig/mysql=0A# ls =
-al /usr/local/share/mysql=0Atotal 936=0Adrwxr-xr-x 26 root wheel 1024=
Mar 1 06:53 .=0Adrwxr-xr-x 24 root wheel 1024 Mar 1 06:37 ..=0A-r--=
r--r-- 1 root wheel 801 Mar 1 06:53 binary-configure=0Adrwxr-xr-x =
2 root wheel 1024 Mar 1 06:53 charsets=0Adrwxr-xr-x 2 root wheel =
512 Mar 1 06:53 czech=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53=
danish=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 dutch=0Adrwxr-xr-=
x 2 root wheel 512 Mar 1 06:53 english=0A-r--r--r-- 1 root wheel=
356623 Mar 1 06:53 errmsg.txt=0Adrwxr-xr-x 2 root wheel 512 Mar =
1 06:53 estonian=0A-r--r--r-- 1 root wheel 399219 Mar 1 06:53 fill_hel=
p_tables.sql=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 french=0Adrw=
xr-xr-x 2 root wheel 512 Mar 1 06:53 german=0Adrwxr-xr-x 2 root =
wheel 512 Mar 1 06:53 greek=0Adrwxr-xr-x 2 root wheel 512 Mar =
1 06:53 hungarian=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 italian=
=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 japanese=0Adrwxr-xr-x =
2 root wheel 512 Mar 1 06:53 korean=0A-r--r--r-- 1 root wheel 4=
702 Mar 1 06:52 mi_test_all=0A-r--r--r-- 1 root wheel 1517 Mar 1 06=
:52 mi_test_all.res=0A-r--r--r-- 1 root wheel 4901 Mar 1 06:53 my-hu=
ge.cnf=0A-r--r--r-- 1 root wheel 20902 Mar 1 06:53 my-innodb-heavy-4G=
..cnf=0A-r--r--r-- 1 root wheel 4878 Mar 1 06:53 my-large.cnf=0A-r--r=
--r-- 1 root wheel 4885 Mar 1 06:53 my-medium.cnf=0A-r--r--r-- 1 r=
oot wheel 2454 Mar 1 06:53 my-small.cnf=0A-r--r--r-- 1 root wheel =
805 Mar 1 06:53 mysql-log-rotate=0A-r-xr-xr-x 1 root wheel 8840 M=
ar 1 06:53 mysql.server=0A-r--r--r-- 1 root wheel 31693 Mar 1 06:37 =
mysql_fix_privilege_tables.sql=0A-r--r--r-- 1 root wheel 589 Mar 1 =
06:53 ndb-config-2-node.ini=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:=
53 norwegian=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 norwegian-ny=
=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 polish=0Adrwxr-xr-x 2 =
root wheel 512 Mar 1 06:53 portuguese=0Adrwxr-xr-x 2 root wheel =
512 Mar 1 06:53 romanian=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:=
53 russian=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 serbian=0Adrwx=
r-xr-x 2 root wheel 512 Mar 1 06:53 slovak=0Adrwxr-xr-x 2 root w=
heel 512 Mar 1 06:53 spanish=0Adrwxr-xr-x 2 root wheel 512 Mar =
1 06:53 swedish=0Adrwxr-xr-x 2 root wheel 512 Mar 1 06:53 ukrainia=
n=0A# ls -al /var/db/mysql=0Atotal 102=0Adrwx------ 15 mysql mysql =
512 Mar 3 11:21 .=0Adrwxr-xr-x 10 root wheel 512 Mar 1 07:48 ..=
=0Adrwx------ 2 mysql mysql 512 Mar 2 15:05 authdaemon=0Adrwx----=
-- 2 mysql mysql 512 Mar 2 15:09 autodepot=0Adrwx------ 2 mysql=
mysql 512 Mar 2 15:09 botBase=0Adrwx------ 2 mysql mysql =
512 Feb 28 02:06 cluster=0Adrwx------ 2 mysql mysql 512 Mar 2 15:=
09 emerald=0Adrwx------ 2 mysql mysql 512 Mar 2 15:09 foxyslager=
=0Adrwx------ 2 mysql mysql 512 Mar 2 15:09 grandjewelers=0A-rw-r=
--r-- 1 mysql mysql 0 Feb 27 11:34 ibdata1=0Adrwx------ 2 mysq=
l mysql 512 Mar 2 15:09 larimarmountain=0A-rw-rw---- 1 mysql mys=
ql 10485760 Mar 3 11:18 log.0000000001=0Adrwx------ 2 mysql mysql =
1536 Mar 2 15:09 mango=0Adrwx------ 2 mysql mysql 1536 Mar 2 15:=
09 mothersrings=0Adrwx------ 2 mysql mysql 512 Mar 2 15:09 mrtabl=
ecloth=0Adrwx------ 2 mysql mysql 2048 Feb 28 02:06 mysql=0A-rw-rw-=
--- 1 mysql mysql 21388 Mar 3 11:21 .web.vi.err=0A-rw-rw---- 1 my=
sql mysql 4 Mar 3 11:21 .web.vi.pid=0Adrwx------ 2 mysql mysql=
512 Feb 28 02:06 test=0A# ls -al /var/db/mysql/mysql=0Atotal 698=0Ad=
rwx------ 2 mysql mysql 2048 Feb 28 02:06 .=0Adrwx------ 15 mysql m=
ysql 512 Mar 3 11:21 ..=0A-rw-rw---- 1 mysql mysql 0 Feb 28 0=
2:06 columns_priv.MYD=0A-rw-rw---- 1 mysql mysql 4096 Feb 28 02:06 co=
lumns_priv.MYI=0A-rw-rw---- 1 mysql mysql 8820 Feb 28 02:06 columns_p=
riv.frm=0A-rw-rw---- 1 mysql mysql 880 Feb 28 02:06 db.MYD=0A-rw-rw-=
--- 1 mysql mysql 5120 Feb 28 02:06 db.MYI=0A-rw-rw---- 1 mysql my=
sql 9582 Feb 28 02:06 db.frm=0A-rw-rw---- 1 mysql mysql 0 Feb 2=
8 02:06 event.MYD=0A-rw-rw---- 1 mysql mysql 4096 Feb 28 02:06 event.=
MYI=0A-rw-rw---- 1 mysql mysql 9817 Feb 28 02:06 event.frm=0A-rw-rw--=
-- 1 mysql mysql 0 Feb 28 02:06 func.MYD=0A-rw-rw---- 1 mysql m=
ysql 1024 Feb 28 02:06 func.MYI=0A-rw-rw---- 1 mysql mysql 8665 Fe=
b 28 02:06 func.frm=0A-rw-rw---- 1 mysql mysql 35 Mar 3 11:21 gene=
ral_log.CSM=0A-rw-rw---- 1 mysql mysql 0 Feb 28 02:06 general_log.=
CSV=0A-rw-rw---- 1 mysql mysql 8776 Feb 28 02:06 general_log.frm=0A-r=
w-rw---- 1 mysql mysql 21497 Mar 1 16:10 help_category.MYD=0A-rw-rw--=
-- 1 mysql mysql 3072 Mar 1 16:10 help_category.MYI=0A-rw-rw---- 1=
mysql mysql 8700 Feb 28 02:06 help_category.frm=0A-rw-rw---- 1 mysql=
mysql 76436 Mar 1 16:10 help_keyword.MYD=0A-rw-rw---- 1 mysql mysql=
14336 Mar 1 16:10 help_keyword.MYI=0A-rw-rw---- 1 mysql mysql 861=
2 Feb 28 02:06 help_keyword.frm=0A-rw-rw---- 1 mysql mysql 6759 Mar =
1 16:10 help_relation.MYD=0A-rw-rw---- 1 mysql mysql 13312 Mar 1 16:1=
0 help_relation.MYI=0A-rw-rw---- 1 mysql mysql 8630 Feb 28 02:06 help=
_relation.frm=0A-rw-rw---- 1 mysql mysql 257428 Mar 1 16:10 help_topic=
..MYD=0A-rw-rw---- 1 mysql mysql 18432 Mar 1 16:10 help_topic.MYI=0A-r=
w-rw---- 1 mysql mysql 8770 Feb 28 02:06 help_topic.frm=0A-rw-rw---- =
1 mysql mysql 0 Feb 28 02:06 host.MYD=0A-rw-rw---- 1 mysql mysq=
l 2048 Feb 28 02:06 host.MYI=0A-rw-rw---- 1 mysql mysql 9510 Feb 2=
8 02:06 host.frm=0A-rw-rw---- 1 mysql mysql 0 Feb 28 02:06 plugin.=
MYD=0A-rw-rw---- 1 mysql mysql 1024 Feb 28 02:06 plugin.MYI=0A-rw-rw-=
--- 1 mysql mysql 8586 Feb 28 02:06 plugin.frm=0A-rw-rw---- 1 mysql=
mysql 576 Feb 28 02:06 proc.MYD=0A-rw-rw---- 1 mysql mysql 4096=
Feb 28 02:06 proc.MYI=0A-rw-rw---- 1 mysql mysql 9691 Feb 28 02:06 p=
roc.frm=0A-rw-rw---- 1 mysql mysql 0 Feb 28 02:06 procs_priv.MYD=
=0A-rw-rw---- 1 mysql mysql 4096 Feb 28 02:06 procs_priv.MYI=0A-rw-rw=
---- 1 mysql mysql 8875 Feb 28 02:06 procs_priv.frm=0A-rw-rw---- 1 =
mysql mysql 35 Mar 3 11:21 slow_log.CSM=0A-rw-rw---- 1 mysql mysq=
l 0 Feb 28 02:06 slow_log.CSV=0A-rw-rw---- 1 mysql mysql 8976 F=
eb 28 02:06 slow_log.frm=0A-rw-rw---- 1 mysql mysql 0 Feb 28 02:06=
tables_priv.MYD=0A-rw-rw---- 1 mysql mysql 4096 Feb 28 02:06 tables_=
priv.MYI=0A-rw-rw---- 1 mysql mysql 8955 Feb 28 02:06 tables_priv.frm=
=0A-rw-rw---- 1 mysql mysql 0 Feb 28 02:06 time_zone.MYD=0A-rw-rw-=
--- 1 mysql mysql 1024 Feb 28 02:06 time_zone.MYI=0A-rw-rw---- 1 my=
sql mysql 8636 Feb 28 02:06 time_zone.frm=0A-rw-rw---- 1 mysql mysql=
0 Feb 28 02:06 time_zone_leap_second.MYD=0A-rw-rw---- 1 mysql mys=
ql 1024 Feb 28 02:06 time_zone_leap_second.MYI=0A-rw-rw---- 1 mysql m=
ysql 8624 Feb 28 02:06 time_zone_leap_second.frm=0A-rw-rw---- 1 mysql =
mysql 0 Feb 28 02:06 time_zone_name.MYD=0A-rw-rw---- 1 mysql mysq=
l 1024 Feb 28 02:06 time_zone_name.MYI=0A-rw-rw---- 1 mysql mysql =
8606 Feb 28 02:06 time_zone_name.frm=0A-rw-rw---- 1 mysql mysql 0 =
Feb 28 02:06 time_zone_transition.MYD=0A-rw-rw---- 1 mysql mysql 1024=
Feb 28 02:06 time_zone_transition.MYI=0A-rw-rw---- 1 mysql mysql 868=
6 Feb 28 02:06 time_zone_transition.frm=0A-rw-rw---- 1 mysql mysql =
0 Feb 28 02:06 time_zone_transition_type.MYD=0A-rw-rw---- 1 mysql mysql=
1024 Feb 28 02:06 time_zone_transition_type.MYI=0A-rw-rw---- 1 mysql =
mysql 8748 Feb 28 02:06 time_zone_transition_type.frm=0A-rw-rw---- 1 =
mysql mysql 216 Feb 28 02:06 user.MYD=0A-rw-rw---- 1 mysql mysql =
2048 Feb 28 02:06 user.MYI=0A-rw-rw---- 1 mysql mysql 10466 Feb 28 02=
:06 user.frm TIA,=0ADrew =0A =0A_____________________=
____________________________________________________________ ___=0ANeed Mail=
bonding?=0AGo to the Yahoo! Mail Q&A for great tips from Yahoo! Answers us=
ers.=0Ahttp://answers.yahoo.com/dir/?link=3Dlist&sid=3D39654 6091
--0-276628478-1172942697=:30640--

Re: Can"t Bind to Port

--0-253230884-1172944445=:72366
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Tommy Nordgren e>=0ATo: Drew Jenkins =0ASent: Saturday, March 3, =
2007 1:39:14 PM=0ASubject: Re: Can't Bind to Port Well, I don't know w=
hat you do with this one, Tommy. I just cut and pasted your command, but wh=
en I hit the up arrow to see the command again, there was that darn white s=
pace: server312# /usr/bin/find / -name 'mysqld' 2>/dev/null=0Afind: 2=
: unknown option=0Aserver312# /usr/bin/find / -name 'mysqld' 2 > /dev/null=
How do I get around that??=0ATIA,=0ADrew =0A_______=
____________________________________________________________ _______________=
__=0AWant to start your own business?=0ALearn how on Yahoo! Small Business.=
=0Ahttp://smallbusiness.yahoo.com/r-index
--0-253230884-1172944445=:72366--

Re: Can"t Bind to Port

--0-1553219013-1172952110=:18580
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

20----- Original Message ----=0AFrom: ed =0ATo: Drew =
Jenkins =0ASent: Saturday, March 3, 2007 12:16:42 =
PM=0ASubject: Re: Can't Bind to Port I figured it wouldn't hurt anythi=
ng to change permissions on files, so I went ahead and changed all the perm=
issions everywhere. I even deleted the symlinks and copied over the origina=
l files to which they pointed and changed those permissions to mysql:mysql.=
That didn't work. Again, here are the dirs in which I changed permissions:=
/usr/local/include/mysql=0A/usr/local/lib/mysql=0A/usr /local/libdata/=
ldconfig/mysql=0A/usr/local/share/mysql=0A/var/db/mysql=0A/v ar/db/mysql/mys=
ql (Actually, some of these were already changed.) I changed perm=
issions on this file, tried my command that has kept failing, then changed =
them back: /usr/local/libexec/mysqld =0AI didn't change permissio=
ns for the following: /usr/local/bin/mysql They're still owned by=
root. Is that correct? Seemed it needed to be owned by root. At any rate, =
unless I've missed something, I think that settles the issue of this not be=
ing a permissions problem...I think! Any other ideas? Tommy, still can=
't run your command.=0ATIA,=0ADrew Drew Jenkins wrote:=0A> ----- Origi=
nal Message ----=0A> From: "replies-lists-a1z2-mysql@listmail.innovate.net"=
=0A> To: Drew Jenkins wjenkinsjr@yahoo.com>=0A> Sent: Saturday, March 3, 2007 11:25:37 AM=0A> Sub=
ject: Re: Can't Bind to Port=0A>=0A> I rebooted, then...=0A>=0A> server312#=
ps wax|grep mysqld=0A> server312# /usr/local/bin/mysqld_safe &=0A> [1] 801=
=0A> server312# Starting mysqld daemon with databases from /var/db/mysql=0A=
>=0A> server312# ps wax | grep mysqld=0A> 801 p0 S 0:00.01 /bin/sh=
/usr/local/bin/mysqld_safe=0A> 849 p0 S 0:00.16 /usr/local/libexe=
c/mysqld --basedir=3D/usr/local --datadir=3D/var/db/mysql --user=3Dmysql --=
pid-file=3D/var/db/my=0A> server312# /usr/local/libexec/mysqld -uroot -hloc=
alhost --max_allowed_packet=3D999M=0A> 070303 9:42:18 InnoDB: Started; lo=
g sequence number 0 46403=0A> /usr/local/libexec/mysqld: Table 'mysql.gener=
al_log' doesn't exist=0A> 070303 9:42:18 [ERROR] Can't start server: Bind =
on TCP/IP port: Address already in use=0A> 070303 9:42:18 [ERROR] Do you a=
lready have another mysqld server running on port: 3306 ?=0A> 070303 9:42:=
18 [ERROR] Aborting=0A>=0A> 070303 9:42:18 InnoDB: Starting shutdown...=
=0A> 070303 9:42:20 InnoDB: Shutdown completed; log sequence number 0 464=
03=0A> 070303 9:42:20 [Note] /usr/local/libexec/mysqld: Shutdown complete=
=0A>=0A> I must be the only person in this conversation that remains unconv=
inced that there are *two* mysql servers running.=0A> TIA,=0A> Drew=0A>=0A>=
=0A>=0A>=0A> =0A =0A_____________________________=
_______________________________________________________=0AGe t your own web =
address. =0AHave a HUGE year through Yahoo! Small Business.=0Ahttp://small=
business.yahoo.com/domains/?p=3DBESTDEAL
--0-1553219013-1172952110=:18580--

Re: Re: Can"t Bind to Port

Drew Jenkins wrote:
> server312# /usr/local/bin/mysqld_safe &
> [1] 801
> server312# Starting mysqld daemon with databases from /var/db/mysql
>
> server312# ps wax | grep mysqld
> 801 p0 S 0:00.01 /bin/sh /usr/local/bin/mysqld_safe
> 849 p0 S 0:00.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my
>
This indicates that you did indeed start the daemon.


> server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M
>
So then why are you trying to start it again? Of course it's going
to tell you there's a daemon already running. You started it with the
mysqld_safe command.

Note, mysqld is the daemon, whereas mysql is the client. If all
you're trying to do it connect to the daemon, you need to run mysql, NOT
mysqld.

--
H | It's not a bug - it's an undocumented feature.
+----------------------------------------------------------- ---------
Ashley M. Kirchner . 303.442.6410 x130
IT Director / SysAdmin / Websmith . 800.441.3873 x130
Photo Craft Imaging . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Re: Can"t Bind to Port

--0-294071817-1172956758=:49136
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

----- Original Message ----=0AFrom: Ashley M. Kirchner =
=0ATo: mysql@lists.mysql.com=0ASent: Saturday, March 3, 2007 4:09:41 PM=0AS=
ubject: Re: [MySQL] Re: Can't Bind to Port >This indicates that you di=
d indeed start the daemon. >So then why are you trying to start it aga=
in? Of course it's going =0A>to tell you there's a daemon already running.=
You started it with the =0A>mysqld_safe command. >Note, mysqld is th=
e daemon, whereas mysql is the client. If all =0A>you're trying to do it c=
onnect to the daemon, you need to run mysql, NOT =0A>mysqld. You=
r logic is sound. So I tried a number of things that don't need repeating. =
Then I thought to myself I should check out the page in the online manual t=
hat talks about max_allowd_packet:=0Ahttp://dev.mysql.com/doc/refman/5.0/en=
/packet-too-large.html=0AI decided after wasting so much time maybe I shoul=
d read the entire page :) Turns out the manual is poorly written in this in=
stance. The comments at the bottom elucidated what to do:=0A* log onto mysq=
l=0A* enter this command:=0ASET GLOBAL max_allowed_packet=3D10000000; =
Done!=0AThanks all!=0ADrew =0A =0A______________________________=
______________________________________________________=0AHav e a burning que=
stion? =0AGo to www.Answers.yahoo.com and get answers from real people who=
know.
--0-294071817-1172956758=:49136--