drush and connecting with a non-localhost database
Occurred to me right after I posted my question to check whether someone had created another my.conf or .my.conf file on the system at sometime in the past. And yes there was a .my.conf file that had been created some years ago. Renamed the file and viola, drush pml works as expected.

Hopes this helps someone puzzled by incorrect database connection.