Date: Sat, 20 Sep 2003 14:43:58 -0400 From: Barry Hawkins <barryhawkins@mac.com> To: Jan van Stekelenburg <janvs@truedestiny.net> Cc: freebsd-questions@freebsd.org Subject: Re: error with mysql when doing mysql -u root Message-ID: <6560AB83-EB9A-11D7-B2E2-000A95A0485E@mac.com> In-Reply-To: <20030920160624.GB961@bacon.truedestiny.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6560AB83-EB9A-11D7-B2E2-000A95A0485E>