DB Credentials via Drush

Go to drupal root, then:

1drush st --show-passwords database

In drush 9.7.2 (may also work for other sub-versions of drush 9), the following command should be used:

1drush st DB