SELECT user_name FROM user WHERE user_real_name = 'Joe User' SELECT user_name FROM user WHERE user_name = 'username' Go to the SQL tab and enter one of the following commands: The second option requires that you know at least one of those actual values. If you only have a handful of users, this is not a bad way to go. Open it in a text editor and you’ll see its actual value. You have two options here:įirst, you can actually click on any of those values I just mentioned and download the. Note that MediaWiki stores both the user_name, user_real_name, and user_email as binary values, so you can’t actually tell which user you are looking at. This is from a localhost install that I created to test things out, so it only has one user. Navigate to that table and you’ll see something like this: MediaWiki stores user information in a table called “user”. If you don’t, consult your host’s knowledge base for instructions.) (I’m going to assume that you know how to log in to your instance of phpMyAdmin. Fortunately, there’s an easy way using phpMyAdmin. But sometimes that doesn’t work (which was the case here-I need to update that install, which is why I was changing passwords), and sometimes you need to reset a password for a user, rather than yourself. MediaWiki does, like all other CMSs, have a “reset password” option. For some reason, my browser didn’t store the new one, and I hadn’t yet written it down. See wikitech:Password and 2FA reset#For users for instructions on requesting 2FA removal for your Developer account.I recently locked myself out of my own wiki while changing passwords. Please note, 2FA removal by staff is not always granted. ![]() You should also create a task on Phabricator if you still have access to it. If you don't have enough scratch codes, you may contact Trust and Safety at ca to request removal of 2FA from your account (please send an email using your registered email address of your wiki account). Visit Special:OATH and use a different scratch code to disable two-factor authentication.If you are not already logged in, this will require use of a scratch code. It will require you to use up to two scratch codes to accomplish this: You will need access to the scratch codes that you were provided when enrolling in order to un-enroll from two-factor authentication. Time-based OTP on our wikis has been known to fail with 2 minutes difference. If you have an existing 2FA device which has simply stopped generating the correct codes, check that its clock is reasonably accurate. Recovering from a lost or broken authentication device You may find further information on how to configure this. Please note, OAuth and bot passwords can not be used to log on interactively to the website, only to the API.įor example, tools like AutoWikiBrowser (AWB) do not yet support two-factor authentication, but can use bot passwords. You may use OAuth or bot passwords to restrict API sessions to specific actions, while still using two-factor authentication to protect your full access. Two-factor authentication is not utilized when using OAuth or bot passwords to log in via the API. Some security sensitive actions, such as changing your email address or password, may require you to re-authenticate with a code even if you chose the keep-me-logged-in option. Actions such as logging out or clearing browser cookies will require a code on your next login. If you choose this option when logging in, you normally will not need to enter an authentication code when using the same browser. ![]() Note: This code changes about every thirty seconds. Enter in a one-time six digit authentication code as provided by the TOTP client.Provide your username and password, and submit as before.This bears the same limitations as the above, but may be worth looking into if you already use one for other things. Password managers such as 1Password, LastPass, and KeePass also tend to support/have plugins to support TOTP.Keep in mind that if you log in from the computer used to generate TOTP codes, this approach does not protect your account if an attacker gains access to your computer. You can also use a desktop client such as the OATH Toolkit (Linux, macOS via Homebrew), or WinAuth (Windows). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |