[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: lost mysql root password

On Friday 03 March 2006 09:49 am, Matt Price wrote:
> Hi folks,
> a while ago I switched over to mysql-5.0, then forgot about it
> entirely.  Now I'm back to configuring some programs that use mysql,
> and... I can't seem to login as root or any other user.
> One option is just that I've forgotten all my passwords (it's been a
> while since I used any of the programs directly).  Another is that
> some configureation issue has reset permissions or something.  In any
> case I would like to avoid losing all my databases, so I'm wondering
> whetherthere's any way to force a reset of theroot password, or
> decrypt the permissions table, or whatever.

if you installed using apt, you should have a file 
called /etc/mysql/debian.cnf . you should be able to use that username and 
password to log in and reset your password.

> I am *not* a cracker, I'm just a little incompetent.
> APpreciate any help you might give.
> Thanks,
> Matt
> --------------------------
>  .''`.       Matt Price
> : :'  :      Debian User
> `. `'` 	     & hemi-geek
>   `-
> --------------------------



Reply to: