Been there, done that - over and over. It is one of the FAQs:
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
>-Original Message-
>From: Noah Garrett Wallach [mailto:no...@yahoo-inc.com]
>Sent: Thursday, August 13, 2009 2:49 AM
>To: mysql@lists.mysql.com
>Subject: settin
Maybe this thread [0] is useful for you.
http://forums.mysql.com/read.php?10,70927,71012#msg-71012
On Thu, Aug 13, 2009 at 1:48 PM, Noah Garrett Wallach
wrote:
> Okay it appears my mysql database is simply screwed up.
>
> I am attempting to rebuild the root account and privileges and now I
> can