Hi there,
I can't believe it, but I seem to have forgotten my admin password. The email reset does not ever send an email. Can someone walk me through how to reset the password through the php? I am using the eguru theme... Does that change anything. I would so very much appreciate some HELP!!!!!
Thanks in advance!
Hi,
1. Login to your moodle database and find the user table mdl_user (moodle ver. 3.3)
2. which admin password is stored using php function 'password_hash' so run the following code with your desired password (I have used 'test' as password).
output:
3. copy the password and update the table with copied password.
that's all now login with the password you used in php encryption.
Thank you.
This should also work:
UPDATE mdl_user SET password=MD5('NEW_PASSWORD') WHERE username='admin';
On the next login Moodle will convert from insecure MD5 hash to the proper one - so log in straight away.
Excelent, this solution works perfectly!
Puvikanth Sundaralingam thank you very much this worked. I'm a little bit new to this moodle this and community here is really helpfull.
I tried the solution that suggested using password_hash, but that didn't work. I looked at the code that Moodle uses to hash the password, and it seems that the second parameter should be PASSWORD_DEFAULT and not PASSWORD_BCRYPT.
Has anyone else encountered this? Is it a matter of Moodle version? I'm running Moodle 3.3.4
Hmm, generating your own bcrypt or MD5 hash and then updating the user table in the sql database is kind of the long way around. If you're already at a command prompt, a simpler method is to use the script designed for that purpose:
sudo -u apache /usr/bin/php admin/cli/reset_password.php
You may need to change the word apache above to say "www-data" (Ubuntu) or "httpd" (CentOS) or something depending on your server. But basically, this script allows an admin to reset any password...
Hope this helps
Would this work for standalone Moodle? Where should I write this command?
Hi Sofia
Coming to your question a bit late, but for the benefit of others - this is back end access to the server - if you don't have that, you can ask your hosting company to help you.
Chris
I've tried all the methods suggested. Adam's method above says "password changed" but then I cannot log in after that.
Seems very odd
Dave
Very odd indeed.
Dave, is the account you're resetting the password for, suspended? Sometimes multiple failed login attempts will result in a locked account.
In SQL, try this query:
SELECT username, deleted, suspended FROM mdl_user WHERE id<=10;
That should get you the first few accounts created on the site (including the first admin account). If there is a 1 in either the deleted or suspended columns, that could be what's stopping you logging in.
Otherwise, please describe the problem in more detail.
Good luck.
I have checked and tried all methods but still getting the error. Here any change occurs or any update in this issue, please? Please make an answer by an expert and resolve the issue, please
Sadi Sadi,
Still getting what error? I have used the cli password reset multiple times over the past few years and it never fails. If you're getting error messages, perhaps sharing the actual error message might help us to help you.
Also, if you want an "expert" to answer you, please contact your local Moodle Partner who will no doubt be glad to have your business.
