CMS Made Simple Forums

HELP

I've locked myself out of my CMSMS

Have tried

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

Which, if I read right should change password to 'admin'

No good.

Have also tried

UPDATE cms_users SET password = md5('type_new_pass_here') WHERE user_id = 1;

Still no good.

I'm inputing the two commands above in the PHPMyAdmin window called 'Run SQL query/queries on database DBNAME'

But still cannot gain access....

Thanks Calguy

Think I panicked cause I 'forgot' about the Lost Password link.....

It all happend when I was changing the username & password

My stats show several failed hack attempts

Are there any characters not allowed? i.e. can I use <, %, £ etc?

What are the limits on numbers of characters in both username and password?

There are reports about special characters like ! and $ not working in passwords... but I've never had a problem. The input field accepts a limited number of characters but it's reasonable (50 or something)... this is hashed into a 16 byte value anyways.