WordPress in docker-compose. 

Reset admin password using SQL (user/password for DB is in the docker-compose file)

vi password.txt
cat password.txt| tr -d '\r\n' | md5sum | tr -d ' -'
docker ps -a
docker exec -it wp-mysql sh
root@server4:~/wordpress# echo "password" >password.txt
root@server4:~/wordpress# cat password.txt| tr -d '\r\n' | md5sum | tr -d ' -'
5f4dcc3b5aa765d61d8327deb882cf99
mysql -u dbuser -p
show databases;
use wpdata;
show tables;
SELECT ID, user_login, user_pass FROM wp_users;
update wp_users SET user_pass="5f4dcc3b5aa765d61d8327deb882cf99" WHERE user_login="wpadmin";


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| performance_schema |
| wpdata             |
+--------------------+
3 rows in set (0.00 sec)

mysql> use wpdata;
mysql> show tables;
+-------------------------------+
| Tables_in_wpdb                |
+-------------------------------+
| wp_commentmeta                |
| wp_comments                   |
| wp_links                      |
| wp_options                    |
| wp_postmeta                   |
| wp_posts                      |
| wp_term_relationships         |
| wp_term_taxonomy              |
| wp_termmeta                   |
| wp_terms                      |
| wp_usermeta                   |
| wp_users                      |
+-------------------------------+
12 rows in set (0.00 sec)

mysql> SELECT ID, user_login, user_pass FROM wp_users;
+----+------------+------------------------------------+
| ID | user_login | user_pass                          |
+----+------------+------------------------------------+
|  1 | wpadmin    | $P$BLdOgqDgIzpH8RLQgH2pzE7vdkyFSB/ |
|  2 | wpuser     | $P$B8DsDOKZTg.xxydKw2ep/vRdJgaBZg. |
+----+------------+------------------------------------+
2 rows in set (0.00 sec)

mysql> update wp_users SET user_pass="5f4dcc3b5aa765d61d8327deb882cf99" WHERE user_login="wpadmin";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


  • No labels