Wordpress problem

Amp34 · 25 Nov 2007 at 14:02

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 *******?

mr.sly · 25 Nov 2007 at 14:28

Use the 'Lost My Password' link? And get it emailed to you?

Amp34 · 25 Nov 2007 at 14:46

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...

~J~ · 25 Nov 2007 at 14:56

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?

robmiller · 25 Nov 2007 at 15:24

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:

Code:

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.)

Amp34 · 25 Nov 2007 at 15:41

~J~ said:
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.

robmiller said:
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:

Code:

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.