Nope that's not it...
So how does DW connect to a remote server? FTP... So I reviewed my servers FTP Program (FileZilla Server) and updated it to the latest version. Battled that for a few hours as things have changed since my original install. Finally got FTP working but, still the same case. Old sites work fine with the WA Extensions and connecting to the DB and showing tables.
Changed password on connection for MySQL. Nope.
I coded a test page that uses the same connection string and that works as shown but still the Extensions via DW can't load tables for this one site.
I'll play with it more tomorrow and see if I can figure out what's happening.
Maybe a file permissions issue... Nope not permissions.
Moved a working connection from one site to the problem site and same thing, no tables found.
Changed from real_connect( to mysqli( nope...
Tomorrow I'll continue.