on 10/19/05 7:47 PM, Luke Vanderfluit at [EMAIL PROTECTED] wrote: > I can't access the database as root anymore. > Accessing as other users doesn't allow me to set any GRANT statements. > Is there any way I can reset the root password? (Ouch).
You probably want to start it up with the skip grants options, and reset it from there, then start it up normal: <http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html> -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]