From owner-freebsd-questions  Wed Nov 29 15:58:44 2000
Delivered-To: freebsd-questions@freebsd.org
Received: from humpty.finadmin.virginia.edu (humpty.finadmin.Virginia.EDU [128.143.87.245])
	by hub.freebsd.org (Postfix) with ESMTP id 68F0937B402
	for <questions@freebsd.org>; Wed, 29 Nov 2000 15:58:41 -0800 (PST)
Received: (from mrg8n@localhost)
	by humpty.finadmin.virginia.edu (8.9.3/8.9.3) id TAA07068
	for questions@freebsd.org; Wed, 29 Nov 2000 19:02:41 -0500 (EST)
	(envelope-from mrg8n)
Date: Wed, 29 Nov 2000 19:02:41 -0500
From: Mike Galvez <mrg8n@mail.virginia.edu>
To: questions@freebsd.org
Subject: Problems starting MySQL Server
Message-ID: <20001129190241.G4092@m.mail.virginia.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
X-Mailer: Mutt 1.0.1i
X-Operating-System: FreeBSD
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Hello to all

I have searched the mail archive for this. I found questions but no answers=
. I
have installed MySQL 3.22.32 on my 4.0 FreeBSD server. This server was upgr=
aded
from 3.3 Release with MySQL installed. I have since deinstalled and reinsta=
lled
MySQL from the ports.  When I try to start MySQL from the script or using
 /usr/local/bin/safe_mysqld &  it fails. If I start it using
 /usr/local/bin/safe_mysqld --skip-grant-tables & it starts. I have run the
following scripts:

mysql_install_db   (this one ran without complaint)

/usr/local/bin/mysql_fix_privilege_tables   (this one ran without complaint)

mysqladmin flush-privileges   (this one also ran without complaint)

The MySQL error log shows the following:

--------------- output from tail
=1B[0;32m001129 17:57:20  /usr/local/libexec/mysqld: Normal shutdown=1B[0;0m

001129 17:57:20  /usr/local/libexec/mysqld: Shutdown Complete

mysqld ended on  Wed Nov 29 17:57:20 EST 2000
mysqld started on  Wed Nov 29 17:57:35 EST 2000
=1B[1;31m001129 17:57:35  Found old style password for user 'root'. Restart=
 using --old-protocol=1B[0;0m
=07mysqld ended on  Wed Nov 29 17:57:35 EST 2000
mysqld started on  Wed Nov 29 18:04:25 EST 2000
--------------- End Log

I hope someone can shed some light on this. I figure it's the grant tables =
but I'm
not sure what to do to them.

Thanks

--=20

Michael Galvez
Computer Systems Sr. Engineer         Office: 804-982-2975
Financial Analysis                    E-Mail: mrg8n@virginia.edu
University of Virginia        Messenger Mail: Carruthers Hall


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message