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
> `-
> --------------------------
--
anoop
aaryal@foresightint.com
Reply to: