Re: mysql50-server root login

[Tim Judd]

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 stewhous...@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-unsubscr...@freebsd.org

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org

Re: mysql50-server root login

[Mel Flynn]

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
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org