RE: [MySQL] mysqld ended

2003-11-17 Thread Victor Pendleton
do a ps -ef | grep mysql (or the equivalent for your system) and see if you
have any other mysql daemons running?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:40 PM
To: [EMAIL PROTECTED]
Subject: [Mysql] mysqld ended


Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the
mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the
output from the log file.

I am on a Sun Sparc running Debian.

Any help would greatly be appreciated.
Thanks,
Matthew

Command Prompt
--
taco:/usr/local/mysql-standard-4.0.7-gamma-unknown-linux-sparc# Starting
mysqld
daemon with databases from
/usr/local/mysql-standard-4.0.7-gamma-unknown-linux-s
parc/data
031117 15:29:07  mysqld ended

Log File

031117 15:09:55  mysqld started
031117 15:09:55  Can't start server: Bind on TCP/IP port: Address already in
use
031117 15:09:55  Do you already have another mysqld server running on port:
3306
 ?
031117 15:09:55  Aborting

031117 15:09:55  /usr/local/mysql/bin/mysqld: Shutdown Complete

031117 15:09:55  mysqld ended


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: [Mysql] mysqld ended

2003-11-17 Thread Joakim Ryden
On Nov 17, 2003, at 12:40 PM, [EMAIL PROTECTED] wrote:

Hi, I am installing a binary version of mysql 4.0.7, but I cannot get 
the mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the 
output from the log file.
[...]

031117 15:09:55  Can't start server: Bind on TCP/IP port: Address 
already in use
031117 15:09:55  Do you already have another mysqld server running on 
port: 3306
 ?
'fuser -n tcp 3306' should give you the process id of the process 
holding up the port.

--Jo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: [Mysql] mysqld ended

2003-11-17 Thread Matthew Hagen

I executed the command:

fuser -n tcp 3306

and it returned: 

3306/tcp:  187

I then ran ps -ef to find what program was using this port and I found
it was:

root   187 1  0 Nov13 ?00:00:00 /usr/sbin/inetd

Is it ok to kill this process ? If not, is there a way to specify mysqld
to use another port ?

Thanks for the help,
Matthew


-Original Message-
From: Joakim Ryden [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 17, 2003 4:17 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Mysql] mysqld ended


On Nov 17, 2003, at 12:40 PM, [EMAIL PROTECTED] wrote:

 Hi, I am installing a binary version of mysql 4.0.7, but I cannot get 
 the mysql daemon running. Mysqld ends right after I start it up.
 I attached the command I use and the output. I also cut and pasted the

 output from the log file.

[...]

 031117 15:09:55  Can't start server: Bind on TCP/IP port: Address 
 already in use
 031117 15:09:55  Do you already have another mysqld server running on 
 port: 3306
  ?

'fuser -n tcp 3306' should give you the process id of the process 
holding up the port.

--Jo



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: [Mysql] mysqld ended

2003-11-17 Thread Joakim Ryden
On Nov 17, 2003, at 4:13 PM, Matthew Hagen wrote:

I executed the command:

fuser -n tcp 3306

and it returned:

3306/tcp:  187

I then ran ps -ef to find what program was using this port and I found
it was:
root   187 1  0 Nov13 ?00:00:00 /usr/sbin/inetd

Is it ok to kill this process ? If not, is there a way to specify 
mysqld
to use another port ?
Look through /etc/inetd.conf for anything that could potentially be 
configured to use 3306 and remove it and restart inetd.

--Jo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]