How to change the password of a user in phpMyAdmin?


by jerad , in category: Third Party Scripts , a year ago

How to change the password of a user in phpMyAdmin?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by darrion.kuhn , 10 months ago


To change the password of a user in phpMyAdmin, follow these steps:

  1. Open phpMyAdmin in your preferred web browser.
  2. Select the database that the user belongs to from the left-hand sidebar.
  3. Click on the "Users" tab at the top of the page to view a list of users in the database.
  4. Locate the user whose password you want to change and click on the "Edit Privileges" icon (a pencil) next to their name.
  5. In the page that appears, scroll down to the "Change password" section.
  6. Choose the option "Use text field" and enter the new password for the user in the text box.
  7. Make sure to select the correct authentication plugin in the "Authentication Plugin" dropdown menu. By default, it is set to "Native MySQL authentication" for new installations.
  8. Click on the "Go" or "Save" button to save the changes and update the user's password.

The password for the user will now be changed to the new one specified.