password lost

[hundehviskeren]

I have access to my MySql and I reset my password. But i still cannot log in after?

Any idea what im doing wrong?

[Dr.CSS]

How did you reset the password?...

Most do it with a SQL query that sets it to admin using the same name as before...

[hundehviskeren]

I reset it by using this sql query proposed in the FAQ.

like this

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

[Dr.CSS]

That is not correct "md5('admin')" admin is a word not an md5 hash, try to use this one exactly as it is...

http://forum.cmsmadesimple.org/viewtopi ... 337#p70727

[hundehviskeren]

Did that as well. Still now working.

I see the password when browsing the table and they are the same as in the statement you linked to.

I have another user in my db which works but that user does not have complete admin status. CMSMS has levels on user right? (long time since used this) When i log in with that user it seems like i have less choices (no user management for instance)

Is their a way I can this working user more rights by tampering in the db?

[Dr.CSS]

I've never had it not work, the password should be admin, but you may want to look at the user in the DB to make sure you are using the correct username...

[hundehviskeren]

checked that as well. Tried renaming as well, does not change anything.

I tried adding a new user via SQL as well. No luck signing in with that either.

Do you know about how to set different rigths via database? Maybe i can upgrade the user current working.

[Dr.CSS]

Run install...

BUT AT STEP 5 DON'T CREATE TABLES OR INSTALL DEFAULT CONTENT this will give you the chance to add a full admin rights user...

Always make sure you do full backup which includes the folders and the DB...

[hundehviskeren]

Tried running install without new tables and content.

It creates no new user in the database.

I did download a new Install folder so there might be a difference ?

[hundehviskeren]

Ahh I got it fixed now.

I told you there was another user without admin rights. So i found the cms_user_groups table and made sure this none admin user got admin rights. Then i logged in with this user and changed my original admin account password.

thanks for helping