Community Wiki

From (mt) Community Wiki

This walkthrough is provided a courtesy to (mt) Media Temple's WordPress users. Please understand this resolution is outside the scope of (mt) Media Temple's technical support. We do not support third-party software, like WordPress, when it comes to how it functions. To read more about the scope of our support, you read it here at our Statement of Support.

Now, in the unfortunate event that you forget the password to your WordPress admin panel, you can update it by accessing the database related to your WordPress blog and altering it. It involves going into your MySQL database and manually changing the password within the tables. Be aware that there are different versions of MySQL and your version may differ from the instructions.

First, you need to login to phpMyAdmin and access the database. To do that, you just do the following:

1. Login to the AccountCenter (http://ac.mediatemple.net).
2. Click the Admin button.
3. Click Manage Databases.
4. Click the Admin button to any of the databases.
5. Enter your database username and password for the phpMyAdmin window. The username will most likely be db#####, db#####_somename or 1clk_RAnD0mTeXt.

Once in the MySQL database:

1. Click on the wp_users table (the wp_users table may read like wp_blogusers, just be vigilant for "users" in the table name).
2. Click the checkbox for the user_pass field, then click the “Browse” tab.
3. Find the ID number associated with your login (there is usually only one) and click Edit (pencil button).
4. Select the password content and delete it. Type in your new password as you normally would.
5. In the dropdown menu, choose MD5. This will encrypt your password.

6. Click Go at the bottom of the screen.
7. Return to the tab for your WordPress blog admin login page and test the new password. If it doesn’t work, start over.

If you are encountering problems with this, you are encouraged to visit either our User Forums as well as the support forums for WordPress for further assistance.