The previous article in the Getting Started with Moodle course explained the process for resetting the Moodle username and password in the Moodle dashboard. In the event the Moodle dashboard is not accessible to do this, the password and username can be reset in the database through PhpMyAdmin.

Using PhpMyAdmin to reset the User Password/Username

  1. Log into phpMyAdmin cPanel hosting will have a database utility called PhpMyAdmin within the cpanel. If the Moodle is installed on a non cPanel hosting, contact the hosting company for information on how to edit your database on the server. For more information on loging into PhpMyAdmin, please see the article on "How do I manage a MySQL database in PHPMyAdmin in my control panel (cpanel)?".
  2. moodle-password-reset-phpmyadmin-second-page In PhpMyAdmin, find the table called mdl_user and select it. Since Moodle has many tables, the mdl_user table may be on the second page. Select the second page.
  3. moodle-password-reset-phpmyadmin-select-mdl_userClick the mdl_user table.
  4. moodle-password-reset-phpmyadmin-editAfter selecting the table, find the table row for the user that is being edited. Click the Edit link with the pencil icon.
  5. moodle-password-reset-phpmyadmin-md5 There will be a series or characters and numbers in the password field. This is an encrypted password so it cannot be viewed in the database. Replace the encrypted text with the new password for the login. Next, in the drop down menu to the left, select MD5 then click Go. This can also be done for the Email address and the Username. The Email and the Username do not need the MD5 hash.

Now that the basics of the Moodle set up is established, it is time to learn more about how to use Moodle. Please check the next article on How to edit the Front page settings in Moodle.

Continued Education in Course 101: Getting Started with Moodle
You are viewing Section 6: Changing the Moodle admin password through PhpMyAdmin
Section 5: How to change the Username and Password in Moodle
Section 7: How to edit the Front page settings in Moodle
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

n/a Points
2014-08-07 3:00 am
thnk u very much. its best!
n/a Points
2014-10-26 12:46 am

Thanks for the Information. Very helpful

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

2 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!