How can I upload user´s passwords??

How can I upload user´s passwords??

by Daniel Quesada -
Number of replies: 2

Hi, I would like to known how can I upload user´s passwords in phpmyadmin, because I need upload a lot of user´s passwods each 60 days.

I used the next SQL sentence:

UPLOAD `mdl_user` SET `password` = MD5( 'mayday' ) WHERE `id` = 55

but this don´t work in moodle, because I get an invalid password message when I try to log in. (In phpmyadmin it seem works well), what´s the problem?? Please help me, is very important to me resolve this trouble.

Average of ratings: -
In reply to Daniel Quesada

Re: How can I upload user´s passwords??

by Eduardo Hernandez -

Daniel,

Why not to upload users by using a CSV file from the admin interface or by using the external database authentication in case your users passwords are stored in an external system?

Eduardo

Average of ratings: -
In reply to Daniel Quesada

Re: How can I upload user´s passwords??

by Thomas Robb -
I think you meant "update" not "upload" in your example.    Why can't you use the moodle "upload users" function to do this?  Won't it overwrite the old password with the new one?
Average of ratings: -