Have you ever forgotten your password? It can happen to the best of us. DesktopServer makes it really easy to create multiple sites fast and losing one of your passwords isn’t uncommon. Perhaps you got side tracked working on another project or the client delayed getting back to you. You revisit your existing site and attempt a login only to realize you’ve totally forgotten the login details! Thankfully, DesktopServer includes the phpMyAdmin utility for administering your WordPress website’s MySQL database and it allows you to update your password painlessly. Here is how to do it:
First, open your web browser and visit http://127.0.0.1/phpmyadmin. All of your website databases will appear on the left hand side. When DesktopServer creates or imports a new WordPress website, it chooses a name based on the first few characters of your website’s domain name, followed by ‘db’ and a few random characters. For instance, the website www.example.dev might have a database name of ‘exampleDBxyz123′. You can be absolutely sure by checking your website’s wp-config.php file for the line that defines the DB_NAME value. When you find your database, click the link on the left hand side.
Now that your database has been selected, a list of tables should appear as links on the left hand side. Locate the wp_users table and click the link. Next, the contents of the wp_users table should appear displaying users. Find the line listing the user you want to change the password for. You can use the user_login or user_email columns to help you locate the user. In our example, we have only one user, ‘admin’. Click the left most edit link to modify this user’s password.
A detail page will appear when you click the Edit link for a given user. In the first column, look for the row titled ‘user_pass’ and set the drop down combo box value to MD5 for the function column. The value column will contain your current password in an encrypted form. You can replace the contents of the value text field with your new password. Simply type it in plain text. Lastly, click the ‘Go’ button. The MD5 setting in the drop down combo box will automatically scramble and secure the password for you.
You can now visit your WordPress website’s login page and enter your username and new password to login.