In regards to the configuration of MAMP MySQL being identical to my live server’s, I’m afraid I have no way of knowing how the latter is configured.
Seems I don’t have a _connections table at all!
Here’s what I have:
Reply To: Local Backup using Duplicator has no entries