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>