List:General Discussion« Previous MessageNext Message »
From:Luis Garay Date:September 22 2005 2:09am
Subject:Re: I forgot the admin password
View as plain text  
Thanks to all. This was a Linux machine and im also learning how to interact
with this so iwill try to do all you said. Thanks.

lgaray


On 9/21/05, valentin_nils@stripped <
valentin_nils@stripped> wrote:
>
> Martijn,
>
> sorry if I sounded perhaps unfriendly. That was not against you.
>
> Imagine that many people read the list (+20.000), some which read this
> which might take your word for granted and just do as you told ;-).
>
> I just wanted to clear that before it becomes practice. I understand that
> in an Microsoft environment it is usual practice to reinstall software
> when the original cause cant be find. Unfortunately that is poor practice.
>
> If feasable, it is important to understand what the original cause is and
> how to stop it, rather than fixing around it.
>
> Reinstalling an
>
> This time its perhaps not REAL data but when disaster strikes, often there
> is not much time to "learn" how it should have been done - mostly that
> means it is already to late. Its important to learn how to do it proberly
> with test data BEFORE disaster strikes.
>
> O.K I believe you got my points. Again, didnt mean to hurt anybody. Peace
> ;-)
>
>
> Best regards
>
> Nils Valentin
> Tokyo / Japan
> http://www.be-known-online.com
>
>
> >>> > > Uninstall, reinstall.
> >>> >
> >>> > That will not work !! MySQL doesnt delete an existing database. No
> >>> > offense, but you should have known better as professional.
> >>> >
> >>> > "--skip-grant-tables" is what the original user wanted to know.
> >>>
> >>> Well, given that the OP only said " I installed it a few weeks ago
> >>> and now I want to start practicing ", it doesn't really matter...
> >>>
> >>> Just reinstall it and you're fresh to go, right?
> >>
> >>NO! depending on how the Luis installed MySQL in the first place (which
> > method was used), the "uninstaller" may not remove or >overwrite the
> > mysql.user table rendering this exercise fruitless as well as being
> > overkill. I understand you work with many >databases other than MySQL
> and
> > for some of them the only way to recover from a lost admin password
> would
> > be
> > to >remove/replace/restore. However, in this case Valentin was correct.
> >
> > Right -- perhaps I should have mentioned: uninstall and delete
> everything
> > :-)
> > Done that a couple of times myself...
> >
> > I understand that Valentin is correct for the "normal" approach,
> > especially
> > when you have a running server and/or databases.
> >
> > I kinda figured, the fastest way (without having to search for an e-mail
> > list), would be just to reinstall the thing. MySQL - on Windows - has a
> > very nice install these days, kudos for that.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
> SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> >
> >
>
>

Thread
I forgot the admin passwordLuis Garay21 Sep
  • Re: I forgot the admin passwordJohan Höök21 Sep
    • Re: I forgot the admin passwordArno Coetzee21 Sep
  • Re: I forgot the admin passwordMartijn Tonies21 Sep
    • Re: I forgot the admin passwordvalentin_nils21 Sep
  • Re: I forgot the admin passwordMartijn Tonies21 Sep
    • Re: I forgot the admin passwordSGreen21 Sep
      • Re: I forgot the admin passwordMartijn Tonies21 Sep
        • Re: I forgot the admin passwordvalentin_nils22 Sep
          • Re: I forgot the admin passwordLuis Garay22 Sep
      • Re: I forgot the admin passwordMartijn Tonies22 Sep
Re: I forgot the admin passwordvalentin_nils22 Sep