So you’ve forgotten your WP admin pass, and haven’t configured your WP install to send email. Whoops.

Requirements:

  • Access to your VM

  • MySQL root pass

  
Login to your VM
  
ubuntu@ip-172-16-1-1:~$ mysql -u root -p
  
Enter password:
  
mysql> USE wordpress;
  
Database changed
  
mysql> UPDATE wp\_users SET user\_pass = MD5('Password1') WHERE ID=1;
  
Query OK, 0 rows affected (0.00 sec)
  
Rows matched: 1 Changed: 0 Warnings: 0

mysql> SELECT ID, user\_pass FROM wp\_users WHERE ID = 1;
  
+----+----------------------------------+
  
| ID | user_pass |
  
+----+----------------------------------+
  
| 1 | e0644agbeb8ccef4c6f56440f4b77cca |
  
+----+----------------------------------+
  
1 row in set (0.00 sec)

mysql>

Now login with your new password.

(Note: the above md5sum is NOT the actual pass for this install :))