"Martijn Tonies" <[EMAIL PROTECTED]> 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 SQL > Server > Upscene Productions > http://www.upscene.com > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine