Using a host computer

[777devil777]

I tried searching six times, I remember seeing this somewhere but couldn't find it. I have two computers and a laptop atm and want to have one computer as a host for my server, but I also want to be able to connect to the DB for edits from my secondary computer for emergencys. Any way to do this?

PS: Im trying to do this because Illidari struck my server while I was away and had nothing but a wireless internet laptop at the time.

[slyfox101]

Set up your server as if your host computer would be the only one connecting to it. Set your secondary computer's realmlist to your host computer's Internal IP.

How to find your Internal IP:

Click on Start.
Go to Run...
Type in cmd, and press OK.
Once in the command console, type in ipconfig.
The IP Address it gives you is your Internal IP, usually starting with 192.168.0.#.

[777devil777]

but I also want to be able to connect to the DB for edits from my secondary computer for emergencys.

I dont see how I can edit the DB, only how to connect to my own server wich isnt exactly a problem as I already can.

[slyfox101]

Ah, I misread, my apologies. You have two options in this regard:

1. Remote into your laptop and go straight into the DB from there.

2. Set up a MySQL website on your host computer and use it to edit the DB from your secondary computer.

[Froogle]

Just go to start then look at this screen shot . . .



Then, skim through all the options and click Next for everything until you reach this page . . .



Just make sure root access is enabled.

Then, on the other computer just connect to the SQL server as you would normally . . . I suggest Navicat, here's the connection info you should enter in . . .




You're welcome!

[slyfox101]

Slyfox is an idiot. Go Froogle, you are the true <3.

I guess you learn something new every day. :P

[777devil777]

Sweet thx, I already promised my rep to a guy to write me up a guide for a sig so heres a 1337 [Store-Bought Cookie]

[Dalamar]

You can give more than one person with 1 rep power, and your guide is in progress. I'm sick so I've been working on it off and on.

[777devil777]

Lol, I've been on this site for over a month and didnt know how the rep system worked, thought that 1rep is how much I have to give away at all till I get more