PDA

View Full Version : Letting People to Connect to your Database Easily!



Hephaestus
07-01-09, 08:52 AM
Hephaestus' Guide of How to Connect to eachother's Database on Different PCs with SQLyog/Navicat/HeidiSQL Only!

<----------------------->
-> Requirements:

- MySQL 5.0 (Installed)
- SQLyog/Navicat/HeidiSQL (Installed)
- Public Server via. Hamachi or Non-Hamachi

<----------------------->
-> How to do it:

1. Click on "Start", then on "Programs" and find "MySQL" and Click on "MySQL Server Instance Config Wizard":
http://i42.tinypic.com/16c6qo1.jpg

Then you have to Click and do This:
http://i40.tinypic.com/nwy1k6.jpg

Then you have to Click and do This:
http://i39.tinypic.com/wursk5.jpg

Then you have to Click and do This:
http://i44.tinypic.com/25rf76a.jpg

Then you have to Click and do This:
http://i40.tinypic.com/2irpzwn.jpg

Then the Last thing is:
http://i44.tinypic.com/2q99fr5.jpg


<----------------------->
-> Editing the Config:

1. Open up the Config "ArcEmu-World.cfg" / "World.cfg":
- Edit these things so people can Connect:



<RemoteConsole Enabled="Edit it to 1"
Host="Your Database's IP"
Port="8092">
* Notice: You need a Public Server to do this! You need to Execute Databases to the Server IP (Hamachi IP/Non-Hamachi IP) as the Localhost IP wont work! *

<----------------------->

Need Help? Comment on this Post!