"Martijn Tonies" <m.tonies@stripped> wrote on 09/21/2005 01:56:16 PM:
> > > 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.
> With regards,
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
> Upscene Productions
> Database development questions? Check the forum!
Unimin Corporation - Spruce Pine