From: Pat Murray
Date: March 22 1999 1:35pm
Subject: mysql server problems
List-Archive: http://lists.mysql.com/mysql/766
Message-Id: <3.0.6.32.19990322133533.0096bc80@bodkin.ucg.ie>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

mysqlbug

Hi,
My OS version is OSF1 zig.ucg.ie V4.0 878 alpha
Initially I got the server going mut now starting it again with 
>./bin/safe_mysql &
I get the following error message
[9] 19451
zig.ucg.ie : ~/database/mysql > Starting mysqld daemon with databases from
/u2/home/astro/pat/database/mysql-3.22.19-dec-osf4.0b-alpha/data
mysqld daemon ended


The information I recieved in the log file which i couldn't understand was
as follows

/u2/home/astro/pat/database/mysql-3.22.19-dec-osf4.0b-alpha/bin/mysqld:
ready for
 connections
A mysqld process already exists at  Mon Mar 15 14:11:52 GMT 1999
A mysqld process already exists at  Tue Mar 16 14:58:38 GMT 1999
mysqld started on  Tue Mar 16 15:35:38 GMT 1999
990316 15:35:38  Can't start server: Bind on TCP/IP port: Address already
in use
990316 15:35:38  Do you already have another mysqld server running on port:
3306 
?
990316 15:35:38  Aborting

mysqld ended on  Tue Mar 16 15:35:38 GMT 1999
mysqld started on  Tue Mar 16 16:43:30 GMT 1999
990316 16:43:30  Can't start server: Bind on TCP/IP port: Address already
in use
990316 16:43:30  Do you already have another mysqld server running on port:
3306 
?
990316 16:43:30  Aborting

mysqld ended on  Tue Mar 16 16:43:30 GMT 1999
mysqld started on  Sun Mar 21 21:05:26 GMT 1999
990321 21:05:27  Can't start server: Bind on TCP/IP port: Address already
in use
990321 21:05:27  Do you already have another mysqld server running on port:
3306 
?
990321 21:05:27  Aborting

mysqld ended on  Sun Mar 21 21:05:27 GMT 1999
mysqld started on  Sun Mar 21 21:09:18 GMT 1999
990321 21:09:18  Can't start server: Bind on TCP/IP port: Address already
in use
990321 21:09:18  Do you already have another mysqld server running on port:
3306 
?
990321 21:09:18  Aborting

mysqld ended on  Sun Mar 21 21:09:19 GMT 1999
mysqld started on  Sun Mar 21 23:02:53 GMT 1999
990321 23:02:54  Can't start server: Bind on TCP/IP port: Address already
in use
etc.



I tried to change pathnames in mysqld but but example error messages were
returned such as
zig.ucg.ie : ~/database/mysql/bin > mysqld
--language=/u2/home/astro/pat/database/mysql/share/mysql/english/
mysqld: Can't change dir to '/usr/local/mysql/var/' (Errcode: 2)
990322 12:21:04  Aborting


Also maybe the fact I started mysql_install_db  few times..
Thanks
Patrick.murray@stripped