How to login into existing Drupal 8 website using Drush or database access

When we install Drupal 8 website from the beginning we set super admin login credentials. But sometimes we get codebase and database dump of an existing website which was set up by someone else.This video explains how you can log in to existing drupal8 website.