blocks|key|2136665|text|显然，Moodle1.9.9版本只使用md5散列密码一次(根本没有盐！！)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2136666|因此，唯一要做的就是将admin行中的password字段替换为您希望应用md5的任何密码。|2136667|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

blocks|key|1301006|text|仅在Moodle+2上测试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1301007|您可以从命令行重置任何用户密码。在您的Moodle根目录中：|1301008|1301009|+php+admin/cli/reset_password.php|blockquote|1301010|1301011|1301012|对于dev+prod环境，您可能还想禁用密码策略检查(这样您就可以输入一个小的、快速键入的密码)。编辑reset_password.php和注释：|1301013|1301014|+//+if+(!check_password_policy($password，$errmsg))+{|1301015|1301016|//+cli_error($errmsg)；|1301017|//+}|1301018|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|Y|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|G|7|13|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|15|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|16|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|U|$]]

only tested on Moodle 2

You can reset any user password from command line. In your Moodle root:

<blockquote>
 php admin/cli/reset_password.php
</blockquote>

For dev prod environment you may also want to disable the password policy check (so you can enter a small and quick to type password). Edit reset_password.php and comment:

<blockquote>
 // if (!check_password_policy($password, $errmsg)) { 
 // cli_error($errmsg);
 
 // }
</blockquote>

blocks|key|498858|text|打开Moodle的config.php文件，找到定义$CFG->passwordsaltmain的那一行，然后复制它的值(它是一个由随机字符组成的长字符串)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|498859|在PHPMyAdmin中，运行以下查询，并根据需要替换相应的值：|498860|UPDATE+mdl_user+SET+password+=+MD5(CONCAT('<new+password>',+'<password+salt+copied+from+config>'))+WHERE+id+=+<id+of+admin+user>|code-block|syntax|javascript|498861|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Open up Moodle's config.php file, find the line where $CFG->passwordsaltmain is defined, and copy it's value (it's a long string of random characters).

In PHPMyAdmin, run the following query, substituting values as appropriate:

<pre><code>UPDATE mdl_user SET password = MD5(CONCAT('&lt;new password&gt;', '&lt;password salt copied from config&gt;')) WHERE id = &lt;id of admin user&gt;
</code></pre>

blocks|key|2320698|text|另一种更快速、更简单的方法来生成新的MD5散列密码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2320699|2320700|转到http://www.miraclesalad.com/webtools/md5.php并创建一个新密码，如...|ordered-list-item|offset|length|2320701|复制从您提交的单词生成的md5散列密码(这很容易)并准备粘贴它。使用phpMyAdmin编辑，登录您的MySQL+database.|2320702|Navigate+to+|2320703|+user表(对于Moodle，名为"mdl_user")并浏览数据。|2320704|找到“|2320705|”用户帐户后，单击“|2320706|”，然后粘贴您在步骤2中复制的新密码("003df036e1a99aad3eaba7c3ca46723d")。(输入密码字段。)这将用您的管理员用户帐户和新密码(密码:+wintersnow123~)|2320707|+)替换您的previously.|2320708|Try登录|unordered-list-item|2320709|2320710|entityMap|0|LINK|mutability|MUTABLE|url|http://www.miraclesalad.com/webtools/md5.php^0|0|0|2|18|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|19|8|@]|9|@$F|1A|G|1B|1|1C]]|A|$]]|$1|H|3|I|5|E|7|1D|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|E|7|1I|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1J|8|@]|9|@]|A|$]]|$1|V|3|W|5|X|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16]]]]

ANOTHER, MORE QUICK AND EASY WAY TO GENERATE A NEW MD5 HASH PASSWORD: 

<ol>
<li>Go to <a href="http://www.miraclesalad.com/webtools/md5.php" rel="nofollow">http://www.miraclesalad.com/webtools/md5.php</a> and create a new password like...
wintersnow123~ 
(it will look like this: "003df036e1a99aad3eaba7c3ca46723d" without quotes).</li>
<li>Copy the md5 hash password generated from the word you submitted (it's easy) and be prepared to paste it. </li>
<li>Using phpMyAdmin, log into your MySQL database.</li>
<li>Navigate to the user table (for Moodle, it's called "mdl_user") and browse the data.</li>
<li>When you find the "admin" user account, click on edit, and paste in the new password you copied in Step 2 ("003df036e1a99aad3eaba7c3ca46723d"). (Into the password field.) This will replace what you had previously.</li>
<li>Try logging in with your admin user account and the new password (Password: wintersnow123~)</li>
</ol>

blocks|key|2320571|text|你可以检查源码，看看哈希值是如何计算出来的。然后你可以用你的新密码和他们的散列函数生成一个新的散列。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2320572|我检查了source-code，根据配置，它使用md5或sha1进行了哈希处理。因此，请检查您的配置，并创建您自己的散列。|offset|length|2320573|//+From+the+sourcecode:
if+($this->config->passtype+===+'md5')+{+++//+Re-format+password+accordingly
++++++$extpassword+=+md5($extpassword);
}+else+if+($this->config->passtype+===+'sha1')+{
++++++$extpassword+=+sha1($extpassword);
}|code-block|syntax|javascript|2320574|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/moodle/moodle/blob/a4d25731df2155e72abd2ea01136d69195e27724/auth/db/auth.php^0|0|4|B|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You could just check the sourcecode and see how the hash is calculated. You could then make a new hash with your new password with their hashing-function.

I checked the <a href="https://github.com/moodle/moodle/blob/a4d25731df2155e72abd2ea01136d69195e27724/auth/db/auth.php" rel="nofollow">source-code</a> and depending on the configuration, its hashed with md5 or sha1. So check your config and make a hash of your own.

<pre><code>// From the sourcecode:
if ($this-&gt;config-&gt;passtype === 'md5') { // Re-format password accordingly
 $extpassword = md5($extpassword);
} else if ($this-&gt;config-&gt;passtype === 'sha1') {
 $extpassword = sha1($extpassword);
}
</code></pre>

blocks|key|1300968|text|如何使用MD5哈希更改密码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1300969|1300970|登录到phpMyAdmin。cpanel主机将在cPanel中有一个名为PhpMyAdmin的数据库实用程序。如果Moodle安装在非cPanel主机上，请联系主机公司以获取有关如何在服务器上编辑数据库的信息。有关登录PhpMyAdmin的更多信息，请参阅文章"How+do+I+manage+a+MySQL+database+in+PhpMyAdmin+in+my+control+panel+(Cpanel)？“。|ordered-list-item|1300971|在PHPMyAdmin中，找到名为mdl_user的表并选择它。因为Moodle有很多表格，所以mdl_user表格可能在第二页。选择第二页。单击mdl_user表。|1300972|选择该表后，查找正在编辑的用户的表行。单击带有铅笔图标的编辑链接。|1300973|密码字段中将出现一系列字符和数字。这是一个加密的密码，因此无法在数据库中查看。将加密文本替换为登录的新密码。|1300974|下一步，在左侧的下拉菜单中选择MD5，然后单击Go。|1300975|1300976|也可以对电子邮件地址和用户名执行此操作。电子邮件和用户名不需要MD5哈希。|1300977|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|X|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|Y|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

HOW TO CHANGE THE PASSWORD USING MD5 HASH:

<ol>
<li>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
logging into PhpMyAdmin, please see the article on "How do I manage
a MySQL database in PHPMyAdmin in my control panel (cpanel)?".</li>
<li>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. Click the mdl_user table.</li>
<li>After selecting the table, find the table row for the user that is being edited. Click the Edit link with the pencil icon.</li>
<li>There will be a series of 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. </li>
<li>Next, in the drop down menu to the left, select MD5 then click Go. </li>
</ol>

This can also be done for the Email address and the Username. The Email and the Username do not need the MD5 hash.

blocks|key|2136692|text|目前，Moodle在密码中引入了一个salt来对每个安装中的密码进行唯一加密。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2136693|如果您没有删除或更改访客帐户密码，您可以将其值复制到管理员用户密码，以便能够登录。|2136694|稍后，您可以将其更改为您喜欢的任何内容。|2136695|用户帐户存储在mdl_user表中。|2136696|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Currently Moodle introduces a salt in passwords to uniquely encrypt passwords in each installation.

If you didn't delete or changed guest account password you can copy its value to admin user password to be able to login.

Later you can change it to whatever you like.

User accounts are stored mdl_user table.

blocks|key|2136997|text|适用于Moodle的3.10..|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2136998|第1步在Moodle根目录中创建一个temp+PHP文件以生成密码。|2136999|<?php
include('config.php');
echo+password_hash('new_password',+PASSWORD_BCRYPT);|code-block|syntax|javascript|2137000|现在运行此php脚本以获取Moodle框架生成的新密码。|2137001|Moodle步骤2:打开PHPMyAdmin并选择数据库。运行此查询。|2137002|update+mdl_user+set+password="new_password_hash"+where+username="admin";|2137003|步骤3:从Moodle根目录中删除temp+php脚本文件。|2137004|entityMap^0|A|6|0|0|3|0|0|0|P|A|0|0|0|U|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|S|3|T|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|V|$]]

For Moodle 3.10.
Step 1
Create a temp PHP file in Moodle root directory to generate the password.
<pre><code>&lt;?php
include('config.php');
echo password_hash('new_password', PASSWORD_BCRYPT);
</code></pre>
Now run this php script to get the new password generated by the Moodle framework.
Step 2:
Open PHPMyAdmin and select the Moodle database.
Run this query.
<pre><code>update mdl_user set password=&quot;new_password_hash&quot; where username=&quot;admin&quot;;
</code></pre>
Step 3:
Delete the temp php script file from the Moodle root directory.

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?

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

moodle平台中管理员登录的密码丢失。我有phpMyAdmin的权限。我转到mdl_user表，在那里我可以看到或编辑这个表。我应该如何继续？我可以将管理员加密密码和密钥更改为已知密码吗?还是只添加一个管理员用户更简单？那会是什么呢？

问手动更改moodle管理员密码并访问phpMyAdmin或创建另一个管理员帐户？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问手动更改moodle管理员密码并访问phpMyAdmin或创建另一个管理员帐户？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问手动更改moodle管理员密码并访问phpMyAdmin或创建另一个管理员帐户？
EN