I was finally able to resolve a similar problem I was having with a solution on this post Unable to run Db Export via CLI
don’t know how i missed this earlier but the –socket argument after my wp cli db command totally works. There’s a screenshot on that post that explains it. Good luck!