Creating an extension of this post about resetting your password, but placing all technical details here.
See this issue on github on sections to take over with the following note:
- promote WP CLI above the other options, for being the safest.
- 2022-09-27: Adding the bare essentials.