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


Discover more from Another Think Coming

Subscribe to get the latest posts sent to your email.

Leave a comment