From owner-freebsd-questions@FreeBSD.ORG Tue Jul 28 02:21:05 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 77EE2106566C for ; Tue, 28 Jul 2009 02:21:05 +0000 (UTC) (envelope-from tajudd@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.249]) by mx1.freebsd.org (Postfix) with ESMTP id 326698FC08 for ; Tue, 28 Jul 2009 02:21:05 +0000 (UTC) (envelope-from tajudd@gmail.com) Received: by an-out-0708.google.com with SMTP id d14so1839850and.13 for ; Mon, 27 Jul 2009 19:21:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=C9NU/DRvDa6qIDm69dDnhSF+E1t3TYcp61Fb7yeFEnw=; b=uYPjWArg4sSx2Z4y8ivhq3Vtudx6oG5z48Rl/FHLMg/VbLFQMUPXYFLYwppdz+jPK/ g/LJ0+3qAb/TKvKhOVA2wk0hkl2+BkPmyAHmffy2iZq4TvGwx/UleSh2EwxIdU5300EH JlHti3fCLkSYshU0t0K9I1znIGzsIsDZbrBv0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=qAEoiE1gZcMGXK6e4A2jtLR9fpKEXj7+Ru5g9A7KP/FAomRus4CeJm5LRiu5kHrEgO rezQXpcV6MUlKZwsFgH694hcsF4jdam0YMP8ZIOT+rcn4viVeb8ACp3wAgv6KlU0FbkP XGQNz93IhIR8RrpJl5FYfrBa8+v1T1a2UFZlE= MIME-Version: 1.0 Received: by 10.100.125.15 with SMTP id x15mr9229087anc.73.1248747664575; Mon, 27 Jul 2009 19:21:04 -0700 (PDT) In-Reply-To: <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com> References: <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com> Date: Mon, 27 Jul 2009 20:21:04 -0600 Message-ID: From: Tim Judd To: Stew Houston Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: mysql50-server root login X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Jul 2009 02:21:05 -0000 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 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" >