Manually change the moodle admin password with acces to phpMyAdmin or create another admin account?

Question

The password for an admin login in a moodle platform is lost.

I have access to the phpMyAdmin.

I went to the mdl_user table and there I can see or edit this table.

How should I proceed? Can I change the admin encripted password and secret key to a known password or is it simpler to just add an admin user?

How would that be?

Answer 1

Apparently Moodle version 1.9.9 only hashes the passwords with md5 once (with no salt at all!!).

So the only thing to do is to replace the in the admin row the password filed with whatever password you want with a md5 applied.