To everyone, I had a very similar issue I spent hours trying to fix. Turns out, what I really needed was a guide to HeidiSQL, hope this helps someone else!
https://www.emucoach.com/forums/threads/solved-authserver-sends-wrong-realm-ip-to-client-4-3-4-blizzlike-cataclysm-v-7.8087/#post-89337