From owner-freebsd-questions@FreeBSD.ORG  Sat Feb 18 13:04:29 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DD86D16A420
	for <freebsd-questions@freebsd.org>;
	Sat, 18 Feb 2006 13:04:29 +0000 (GMT)
	(envelope-from bkoenig@cs.tu-berlin.de)
Received: from efacilitas.de (smtp.efacilitas.de [85.10.196.108])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0B6E243D55
	for <freebsd-questions@freebsd.org>;
	Sat, 18 Feb 2006 13:04:26 +0000 (GMT)
	(envelope-from bkoenig@cs.tu-berlin.de)
Received: from eurystheus.local (port-212-202-169-72.dynamic.qsc.de
	[212.202.169.72])
	by efacilitas.de (Postfix) with ESMTP id 35F3A4C821;
	Sat, 18 Feb 2006 14:13:59 +0100 (CET)
Received: from [192.168.1.2] (muhkuh.local [192.168.1.2])
	by eurystheus.local (Postfix) with ESMTP id 292BA5285E;
	Sat, 18 Feb 2006 14:02:41 +0100 (CET)
Message-ID: <43F71B67.5010603@cs.tu-berlin.de>
Date: Sat, 18 Feb 2006 14:04:39 +0100
From: =?ISO-8859-15?Q?Bj=F6rn_K=F6nig?= <bkoenig@cs.tu-berlin.de>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
To: Roman Shakin <rshakin@unixfreak.org>
References: <43F67A50.6040702@unixfreak.org>
In-Reply-To: <43F67A50.6040702@unixfreak.org>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
Cc: freebsd-questions@freebsd.org
Subject: Re: Remving All of MySQL Database
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 18 Feb 2006 13:04:30 -0000

Roman Shakin schrieb:
> hello i need to remove all of the mysql databases... i messed it up... 
> and now cant log in? please help. I tried deleting the /var/dg/mysql and 
> running mysql_install_sh

just start mysql after removing the database, i.e.

/usr/local/etc/rc.d/mysql-server.sh stop
rm -R /var/db/mysql
/usr/local/etc/rc.d/mysql-server.sh start

That's it. Now you have a fresh clean database. The password of the root 
account is "" (without quotes ;-)

Björn