Date: Mon, 27 Jul 2009 18:30:02 -0800 From: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net> To: freebsd-questions@freebsd.org Cc: Tim Judd <tajudd@gmail.com>, Stew Houston <stewhouston@gmail.com> Subject: Re: mysql50-server root login Message-ID: <200907271830.03006.mel.flynn%2Bfbsd.questions@mailing.thruhere.net> In-Reply-To: <ade45ae90907271921w7cc2e874t718490834d33257f@mail.gmail.com> References: <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com> <ade45ae90907271921w7cc2e874t718490834d33257f@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Monday 27 July 2009 18:21:04 Tim Judd wrote:
> After running mysql_install_db, the mysql files are owned by
> root:wheel instead of mysql:mysql
>
> I've noticed that is a missing step in the docs.
> # mysql_install_db
> # chown -R mysql:mysql /var/db/mysql
Or...you can just not do this at all.
> # /usr/local/etc/rc.d/mysql start
Will create the auth tables, if they don't exist, with the correct ownerships:
mysql_prestart()
{
if [ ! -d "${mysql_dbdir}/mysql/." ]; then
mysql_create_auth_tables || return 1
fi
--
Mel
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200907271830.03006.mel.flynn%2Bfbsd.questions>