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