Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 02 Apr 2003 17:54:15 -0500
From:      Bill Moran <wmoran@potentialtech.com>
To:        Konrad Scorciapino <fallenbr@uol.com.br>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: MySQL Problem
Message-ID:  <3E8B6A17.30403@potentialtech.com>
In-Reply-To: <200304022020.17985.fallenbr@uol.com.br>
References:  <200304011641.35926.fallenbr@uol.com.br> <20030402055102.GA58899@peitho.fxp.org> <200304022020.17985.fallenbr@uol.com.br>

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3E8B6A17.30403>