>> > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
