Difference between revisions of "Administrative Account"
Line 1: | Line 1: | ||
All accounts on [[MediaWiki]] are registered in the relational database ([[ | All accounts on [[MediaWiki]] are registered in the relational database ([[MySQL]]). Due to this design, in case you lost the admin password, which is the first user of the MediaWiki system, you must go to the database and change the password using SQL. Detailed instructions [https://hostlantern.com/clients/knowledgebase/807/How-to-reset-my-MediaWiki-admin-password.html here]: (Sample code is shown as follows) | ||
<syntaxhighlight lang=SQL> | <syntaxhighlight lang=SQL> | ||
UPDATE user SET user_password = MD5( CONCAT( user_id, '-', MD5( 'NEWPASS' ) ) ) WHERE user_id =1; | UPDATE user SET user_password = MD5( CONCAT( user_id, '-', MD5( 'NEWPASS' ) ) ) WHERE user_id =1; |
Latest revision as of 03:10, 23 August 2021
All accounts on MediaWiki are registered in the relational database (MySQL). Due to this design, in case you lost the admin password, which is the first user of the MediaWiki system, you must go to the database and change the password using SQL. Detailed instructions here: (Sample code is shown as follows)
UPDATE user SET user_password = MD5( CONCAT( user_id, '-', MD5( 'NEWPASS' ) ) ) WHERE user_id =1;
Otherwise, one can use the changePassword.php maintenance script. Just launch the following command in a terminal (command line interface) application.
php changePassword.php --user=target_username --password=new_password
For detailed instructions, one can refer to MediaWiki's Manual:Resetting passwords.
The following instruction steps are inspired by the article[1]:
Operating System Accounts
To add a new user account with administrator access, one must follow these steps:
- Log in to the system with root access, using a terminal applications.
- Create a new user name, say xlp, by using the
adduser
command:
adduser xlp
- Make the user xlp, possess
admin
rights.
usermod -aG sudo xlp
- Verify its rights using
id xlp
- Log in as
xlp
, by key in the following command
su - xlp
- Then run some
sudo
command
sudo ls -l /etc/
If the the above worked, you have created an administrative account with user name:xlp
.