Remote Admin Access - DB files

[Eq4Life2]

Ok - First - New to this -

My friend and I have recently gotten a server set-up, its listed and anyone can log in. Question we both have at this point, he has it hosted from his computer, so all files are located there. How do we configure, and most importantly what do we configure, to allow my system to remote in to access the files to tweak them?

Example: I DL'd George's tools on my system and I want to create/add items to the server remotely. Open "EQITEM" or a like program on my system and have them saved onto the server. I am not exactly sure how to set it up to be modifying the server file.

Any assistance would be GREATLY appreciated, thanks in advance folks.

[lerxst2112]

Google for "MySQL remote access"

[Eq4Life2]

Ok once we have the access resolved, what is the set-up with the EQITEMS type program?

[Zamthos]

Would be more of a GeorgeS section question, but I'll help you out to the best of my abilities.

host=localhost ##Host
user=root ##username
password=root ##password
database=peq ##database
everquest_folder= ##location of client folder
quest_folder= ##location of quests folder

[Eq4Life2]

What I mean is

host= (IP Address and port?)
user=(whatever my user is)
password=obvious
database=obvious (what format tho? i.e. http://ipadddress:port/x/x/x/x?
everquest_folder=c:users\administrator\desktop\etc \etc or ?

[Zamthos]

No, there is no need for port, the quests folder is not listed in what you typed, the database is the name of the database, for example, 'peq', the most common database in EverQuest Emulator, your EverQuest/Quests folder is the location, and that's it, so like C:\eqemu\quests or C:\EverQuest.

Example:

host=localhost
user=root
password=root
database=peq
everquest_folder=C:\EverQuest
quest_folder=c:\EQEmu\quests

[lerxst2112]

host: the ip address or dns name of the remote machine
database: whatever the database is named, probably 'peq'
everquest_folder: wherever you have the client installed on your local machine.

[Eq4Life2]

Originally Posted by lerxst2112

host: the ip address or dns name of the remote machine
database: whatever the database is named, probably 'peq'
everquest_folder: wherever you have the client installed on your local machine.

dumb question (not a truly savvy guy)

host=xxx.xxx.xx.xxx or http://xxx.xxx.xx.xxx?

[lerxst2112]

Just the IP address or hostname.

[Noport]

i recommend using ESF Database Migration Toolkit Professional Editon 7.4.14

[Eq4Life2]

thanks Lerx

[c0ncrete]

ssh tunneling ftw

[jdoran]

Speaking of ports, if you are using a router make sure that it passes database traffic. Port 3306 is used by mysql.