changed admin user name and now can't log in

[Kickice]

I searched on here to see how to change my 'admin' user name, and did so in the CPadmin panel.

But now, I can no longer log in! I try to log in with my new name, and it won't let me. So, urrrm, a bit stuck now as to what to do. Any ideas?

[Lynne]

Did you clear your cookies? Try a different browser?

[Kickice]

just tried it on another browser, and still saying wrong user name or password. And it's locked me out now anyway as i tried 5 times.

[Lynne]

Are you sure when you changed the name that you spelled it how you thought you spelled it? You may want to verify it in the database.

Did you change *anything* else when you changed the username?

[Kickice]

definitely the right spelling.

only other thing was changing the time to the correct time zone!

[Lynne]

Time zone wouldn't matter. Did you change the password at all?

To reset the password via a database query (do via phpMyAdmin), do this:

UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = X

...with 'X' being your userid number and <prefix> being your table prefix.