From owner-freebsd-questions@FreeBSD.ORG Sat Sep 20 11:44:01 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 04B3616A4B3 for ; Sat, 20 Sep 2003 11:44:01 -0700 (PDT) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.89]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5BEAC43FE5 for ; Sat, 20 Sep 2003 11:44:00 -0700 (PDT) (envelope-from barryhawkins@mac.com) Received: from mac.com (smtpin07-en2 [10.13.10.152]) by smtpout.mac.com (Xserve/MantshX 2.0) with ESMTP id h8KIhx9D020821; Sat, 20 Sep 2003 11:43:59 -0700 (PDT) Received: from mac.com (dsl027-161-197.atl1.dsl.speakeasy.net [216.27.161.197]) (authenticated bits=0) by mac.com (Xserve/8.12.9/MantshX 2.0) with ESMTP id h8KIhv21012612; Sat, 20 Sep 2003 11:43:58 -0700 (PDT) Date: Sat, 20 Sep 2003 14:43:58 -0400 Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v552) To: Jan van Stekelenburg From: Barry Hawkins In-Reply-To: <20030920160624.GB961@bacon.truedestiny.net> Message-Id: <6560AB83-EB9A-11D7-B2E2-000A95A0485E@mac.com> Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.552) cc: Shawn Guillemette cc: freebsd-questions@freebsd.org Subject: Re: error with mysql when doing mysql -u root X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 20 Sep 2003 18:44:01 -0000 X-List-Received-Date: Sat, 20 Sep 2003 18:44:01 -0000 On Saturday, Sep 20, 2003, at 12:06 US/Eastern, Jan van Stekelenburg wrote: > On Sat, Sep 20, 2003 at 10:31:43AM -0700, Shawn Guillemette wrote: >> is there a way to reset the mysql root user passwd? I'm starting to >> wonder >> if I finger mumbled the passwd or something.. > > It's written here: > http://www.mysql.com/doc/en/Resetting_permissions.html > > Good luck. > Jan. > _______________________________________________ > 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" > > > Shawn, After you reset your MySQL root user password, did you reload the tables so that your new password would be recognized? That is done using either of the following: mysqladmin -u root reload mysqladmin -u root flush-privileges NOTE: The "-u root" portion is based on an assumption that prior to changing your password, the password had been blank. Regards, -- Barry C. Hawkins All Things Computed site: www.allthingscomputed.com/ weblog: www.allthingscomputed.com/blog/