Well if you are going with default settings, you are having the clients trying to connect to IP address 127.0.0.1 which won't fly if your flatmate is trying to connect to it. Without fiddling with too much, try installing hamachi on both systems, https://secure.logmein.com/products/.../download.aspx . After that run hamachi on both systems. In Client window under network, create a new network on the host computer, then have the second computer put in the same info to connect to the VPN on their client. Next fire up MySQL via command in _Server folder. Connect to the database with your fav editor, I prefer HeidiSQL and there are those that swear by navicat. Under "auth" there should be a section for realmlist. Change this to the hamachi clients IPv4 address of the system that is hosting the server (5 .189.00.001) or whatever your number is. After that, edit the realmlist on each computer in the \World of Warcraft\Data\enUS\ folder and have it only say "set realmlist *your hamachi IPv4 address*" without quotes or asterisks. Once that is changed use a skyfire modded launcher to start the game. Add new accounts via command line in worldserver.exe with .account create $username $password. One handed typing with baby hope I covered it all.

---------- Post added at 11:32 AM ---------- Previous post was at 10:55 AM ----------

MySQL sets itself up as an automatic server. Go to START>Run ant type services.msc. This will pop up running services. Find MySQL and set it to manual. After that, when trying to connect to your MySQL database via navicat or whatever maker sure credentials are correct. If not then you need to do some editing in your Skyfire server core worldserver.conf and authserver.conf. Ooh almost forgot authserver.conf needs to be cofigured with the hamachi number too! Under "BIND IP". Cheers.



---------- Post added at 12:10 PM ---------- Previous post was at 11:32 AM ----------

I never us MySQL so that is why I have it set to manual so I have to start the service by launching the MySQL.bat in the _Server folder.