From owner-freebsd-questions@FreeBSD.ORG Wed Apr 2 15:33:51 2003 Return-Path: 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 10DBE37B401 for ; Wed, 2 Apr 2003 15:33:51 -0800 (PST) Received: from pa-plum1b-166.pit.adelphia.net (pa-plum1b-122.pit.adelphia.net [24.53.161.122]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4D6B843F75 for ; Wed, 2 Apr 2003 15:33:50 -0800 (PST) (envelope-from wmoran@potentialtech.com) Received: from potentialtech.com (working [172.16.0.95]) h32NXmJP009593; Wed, 2 Apr 2003 18:33:49 -0500 (EST) (envelope-from wmoran@potentialtech.com) Message-ID: <3E8B6A17.30403@potentialtech.com> Date: Wed, 02 Apr 2003 17:54:15 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.2.1) Gecko/20030301 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Konrad Scorciapino References: <200304011641.35926.fallenbr@uol.com.br> <20030402055102.GA58899@peitho.fxp.org> <200304022020.17985.fallenbr@uol.com.br> In-Reply-To: <200304022020.17985.fallenbr@uol.com.br> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-questions@freebsd.org Subject: Re: MySQL Problem X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 Apr 2003 23:33:51 -0000 Konrad Scorciapino wrote: > Hi, > >>Look in /var/db/mysql/ and look for the error logs. >>I think they are labeled hostname.err. >> >>They should tell you what is wrong. > > Hmmm... The problems started when I deleted the "mysql" database... Now I've > fixed it.... > > I've deleted the database as a regular user, as could anyone else do. Is there > any way to prevent regular users from deleting those important databases? a) How did you delete it? rm -r? b) What do you mean by "regular user"? If you use rm to delete the directory, then that's a problem that should be fixed ... MySQL shouldn't install it's data files rw by just any user. However ... I'm looking at my MySQL install and all the data directories are rw only by user mysql. If you logged into mysql and use "drop database" and it succeeded, then you probably weren't a "regular user". Read the docs on MySQL security, there's a lot to it. -- Bill Moran Potential Technologies http://www.potentialtech.com