I was finally able to resolve this 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.
I was finally able to resolve this 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.