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.
On 9/21/05, valentin_nils@stripped <
> 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
> >>> > > 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
> > for some of them the only way to recover from a lost admin password
> > be
> > to >remove/replace/restore. However, in this case Valentin was correct.
> > Right -- perhaps I should have mentioned: uninstall and delete
> > :-)
> > 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
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com