Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 27 Jul 2009 20:21:04 -0600
From:      Tim Judd <tajudd@gmail.com>
To:        Stew Houston <stewhouston@gmail.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql50-server root login
Message-ID:  <ade45ae90907271921w7cc2e874t718490834d33257f@mail.gmail.com>
In-Reply-To: <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com>
References:  <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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
# /usr/local/etc/rc.d/mysql start



How it sticks long enough until reboot sounds like a memory cache,
which is flushed of course at reboot.

--TJ

On 7/27/09, Stew Houston <stewhouston@gmail.com> wrote:
> I'm having trouble getting my MySQL server root password to "stick."  After
> installing through ports, I run mysql_install_db which gives me two commands
> to set the root password through mysqladmin.  I do this and all is well.  I
> can login as root with no problems.  After a reboot however, the I can't get
> in.  Any ideas?
>
> Stew
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
>



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