Wordpress problem

[Amp34]

I seem to have forgotten my main username on my wordpress account, is there some way of finding it in the database or somewhere else?

Or am I *******?

 

[Amp34]

Doesn't work if you don't know your username.

I'm sure I know what the username is but it doesn't seem to exist so...

 

[Amp34]

IS this on YOUR blog, or is it on the official wordpress.com site? IF it's the former, can't you just go into the SQL table and look what the username is?

It's my blog hosted on my site.

The wp_users table lists the usernames and hashed passwords. There's no way to retrieve your password, but you can reset it: simply set the user_pass field for your user to the MD5'd value of your new password. You can do that pretty easily with phpMyAdmin, or just run the query:

UPDATE wp_users SET user_pass = MD5("your new password here") WHERE username = "admin"

(Where "admin" is the username. "admin" is the default account WP creates during the install.)

Thanks, i'll try that now.