How to reset Drupal 8 administrator password using phpMyAdmin?

This post describes in brief the steps to reset the Drupal 8  administrator password in case you forget them. Writing down passwords are a big no no, and no matter how hard we try to remember passwords, sometimes, we may miss it, especially if you have various different password for different systems. And forgetting passwords also usually happens on development systems when you set