Hi Restart mysqld with the --skip-grant-tables option
More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html --Praj On Mon, 10 Apr 2006 12:57:32 +0600 "Kosala Atapattu" <[EMAIL PROTECTED]> wrote: > Hi people, > > I have a small problem. I forgot the password for user root in my > personal MySQL instance. I'm a Linux user and running Debian Sarge on my > computer. I have few other DBs which I created and which I have access > to (still I remember the passwords) but are not having access to MySQL > database. > > Is there any way to recover from this situation. If I reinitialize the > DB (somehow) how can I port my existing information back in to the > initialized DB (without exporting and importing). > > Any Debian friends who can help me. > > Cheers, > Kosala > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]