[SOLVED] URGENT: I messed up admin with phpMyAdmin

[jack4ya]

I screwed around with phpMyAdmin, switched the user_id of the users (thought it was quicker), didn't work, so I switched back. But now I can't login to backend anymore.

I know this is my stupid mistake, but that's water under the bridge now.

How do I fix this, as my client has a presentation tomorrow!!

[jack4ya]

I've used this query: from the download package

INSERT INTO cms_users ( USER_ID, USERNAME, PASSWORD, ADMIN_ACCESS, FIRST_NAME, LAST_NAME, EMAIL, ACTIVE, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'admin', '6b903fbd0cb295eb1f4d589fefb435a5', 1, 'Admin', 'User', 'ted@cmsmadesimple.org', 1, '2006-07-25 21:22:33', '2006-07-25 21:22:33' );


What's the standard uncoded password... will this work?

[jack4ya]

For future reference

Code: Select all

UPDATE cms_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE user_id = 1;

will reset the password to 'admin'.

Now you can enter with admin & admin