changed admin user name and now can't log in
 

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?

Did you clear your cookies? Try a different browser?

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.

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?

definitely the right spelling.

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

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.