MoodleConversations - Changing Users Password via SQL
Although there are specific ways to adjust a Moodle password, here’s one I didn’t know about using SQL commands:
UPDATE `nameofyourdatabase`.`mdl_user` SET `password` = MD5( ‘oldpasswordhere’ ) WHERE `mdl_user`.`id` =3 LIMIT 1 ;
I haven’t seen the new code and haven’t tested how it works but I suppose developers will soon give some more info… have you reported to tracker?
PS. Note that password does not need to be ‘oldpasswordhere’ - it’s just an example…PS2. If this does not work the other trial could be to create a new account and copy the new salted password to your troublesome field - and delete the new account.
I’m sure this came out of the inexhaustible supply of advice out of the Moodle.org Forums, but I don’t have the link handy. Sorry.
Subscribe to Around the Corner-MGuhlin.org
Everything posted on Miguel Guhlin’s blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure