I've got mysql running on my home system. I was playing with access (trying to allow access from something other than localhost) and being a complete db noob/loser if locked my root user out.
The only way i can get in at the moment is if a start a mysqld_safe process with the --skip-grant-tables & option (discovered after googling).
I've tried UPDATE User set Host='localhost' where user='root'; and that doesn't seem to work.
Is there a way to 'start fresh'? I'd still like to keep the data so don't really want to do a full reinstall.
I'm not worried about security since its just my local box (i.e quick and dirty fix will do). Just looking for a 'reset' option or something. I'm a sql hacker, so not afraid of command line, just don't have a clue what I'm doing. help! :-(