Re: lost mysql root password
maybe you are not using linux debian distribution.
So this way is geereal way. You can setup same version
of mysql in an other machine create new mysql root
password there and copy. all files under (if your
mysql datadir is an other location, look the place of
it from /etc/my.cnf ) /var/lib/mysql /mysql/* from
new machine to your old machine and restart mysql. And
now you can use new root password in your old machine.
--- Matt Price <matt.price@utoronto.ca> 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.
>
> 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
> `-
> --------------------------
>
>
> --
> To UNSUBSCRIBE, email to
> debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact
> listmaster@lists.debian.org
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Reply to: