Page 1 of 1
[SOLVED] URGENT: I messed up admin with phpMyAdmin
Posted: Tue Apr 24, 2007 9:31 am
by 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!!
Re: URGENT: I messed up admin with phpMyAdmin
Posted: Tue Apr 24, 2007 9:44 am
by 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?
SOLVED: I messed up admin with phpMyAdmin
Posted: Tue Apr 24, 2007 9:49 am
by 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