but looking back at everything, the --net flag seemed to be the missing link all other settings for mysql were matching what i setup on my local, including having a local IP address and adding a mysql user that would be allowed to login using that local ip instead of localhost