Reset all users passwords

[clarkcoet]

Hi All,
My mail keeps getting hacked and spammed.
I need to reset all user passwords and I need to have the system send them system generated passwords.
I am not a techie so please explain carefully.
Thanks for your help

[itoctopus]

Here's a query that resets everyone's password to a specific string (you can run it in phpMyAdmin):

Code: Select all

UPDATE #__users SET password=MD5('arandompassword')";

Note that the above will reset the password of every user to the same password. If you want to have a different password for each and every users (which should be the case), then you will need to write a small PHP script that will loop through all the users and set a random password for each one of those users and then email each user his/her password.

[clarkcoet]

Thanks but I am not a developer so I will have to find someone to do it for me thanks