Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 18 Feb 2006 14:04:39 +0100
From:      =?ISO-8859-15?Q?Bj=F6rn_K=F6nig?= <bkoenig@cs.tu-berlin.de>
To:        Roman Shakin <rshakin@unixfreak.org>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Remving All of MySQL Database
Message-ID:  <43F71B67.5010603@cs.tu-berlin.de>
In-Reply-To: <43F67A50.6040702@unixfreak.org>
References:  <43F67A50.6040702@unixfreak.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43F71B67.5010603>