I’ve setup a copy of this site on one of the PCs at home so that I could play with WordPress without totally trashing the live version. Last night I thought I would have a bit of a play with altering the site on the PC and tried to login….only I couldn’t because I’ve forgotten the username and password and because it is a local version of the site I haven’t set up an email address. No problem I thought, I’ll just access the MySQL database and hack the relevant table..except I can’t remember the password for that either. I’m sure I wrote it down somewhere……
Depending on the setup of your mysql database, it is possible that you may still be able to log in with username “root” and no password. It’s massively insecure, but seems to be the default for many installs.