Tools you will be needed
Quote:
- A copy of World of Warcraft either enUS or enGB.
- MaNGOS Bins (Rev 3200 + MCH) -> Click me!
- SDB 0.6.1 -> Click me!
- The map extracting tool ad.exe -> Click me!
- The *.dbc extraction tool mpqe.exe -> Click me
- MySQL -> Click me!
- A MySQL admin tool, such as Navicat or SQLyog, in this guide I will be using SQLyog because it is free and is almost the same as Navicat -> Click me!
- WAMP PHP5 Apache MySQL (For your website) -> Click me!
Step 1: Creating your Workspace + Installing your files
Extracting MaNGOS Bins
Installing tools
- Download and extract your MaNGOS bins wherever you want, but this is where your server files will be placed. I will be referring to this as the MaNGOS directory. Please make sure that once you open that folder, there is no folder inside, so when you open your MaNGOS Dir. you will see the batch files mangosd.exe and realmd.exe, and other files. If you do not see these, cut the files and put them in the correct folder.
Configuring your MySQL Server
- After downloading, double click the MySQL installation tool and begin installing your files. You don't need to sign up to use this, but you can do this later (I think it's free). After skipping the sign up, pick whatever dir. you want to install it (feel free to leave it as default), and then beginning installing. After it's completely, make sure that "Configure my MySQL Server Now" is checked off and then click Finish.
Getting Maps + DBCs
- Once the window pops up introducing you to the config wizard, click next
- Choose standard configuration then click next
- Then choose to Install As Windows Service then click next
- In the two empty dialog boxes, type in the password you wish to use for the MySQL root (aka Administrator) account. This is the most important account on MySQL and has full access to all databases and functionality. It's recommended you use a very strong password to prevent access to your MySQL server instance. Also, if you want to make your server public, check off "Enable root access from remote machines". Then click next
- In this new window you should see 4 white bullets, and below a button called Execute. Click that button and wait for it to finish, it should then say below those 4 buttons in black that you have succesfully configured your MySQL server. That's when you click finish.
Maps
DBC's[list=1][*]Download this: Click Me![*]Extract the folder into your Mangos Directory
- Copy your ad.exe folder to your 1.12.1 enUS/enGB WoW Directory.
- Create a folder called maps in your 1.12.1 enUS/enGB WoW Directory
- Double click the ad.exe tool. Wait till it has finished extracting the map files.
- Once completely copy&paste or cut&paste the "maps" folder which should have 2400+ map files / 700mb of space to your Mangos Directory. Your Mangos Directory should now have the folders "maps" and "sql".
Step 2: Setting up your Database
Connecting to your MySQL Server
Creating Empty Databases
- Open up SQLyog. Please make sure it looks something like this:
The difference would be that firstly, the "password" you put was the one in step 4 for MySQL configuration, aka, your MySQL root password. [b]Make sure that at the bottom it has the 2 databases: realmd;mangos (not mangod).
Creating Spawned Databases
- Click connect.
- On the left there is a tab called root@localhost. To create your databases. Right click that and click "Create new database" Name it "mangos"
- Repeat this step but name it this time "realmd"
- If the databases are already there, then you can skip these steps
I suggest you close your SQLyog and open it again so you can see the new databases, which should look like this on the left tab:
If it looks like this, then we can move onto the next step, if it doesn't then it sux2beu (or I suggest you re-do EVERYTHING).
Configuring MaNGOS!
- Right click Realmd and click Restore from SQL Dump. This will open a new window. At the top there is a white bar, to the right there is a button with "..." inside, click that button, then go to your Mangos Directory, click the "sql" folder, and double click realmd. It should take you back to that window, now you can click execute. After it finishes, close the window.
- Right click mangos and click Restore from SQL Dump. This will open a new window. At the top there is a white bar, to the right there is a button with "..." inside, click that button, then look for where you extracted SDB (if you haven't do so now and then refresh the folder). Double click the SQL file and click Execute. Wait till it finishes loading (this may take a while depending on your CPU). After it's finished entirely, close the window.
Alright, so you have set up all your files, and you have gotten everything in tip top shape So then one last step until you are ready to starting up your MaNGOS LAN Server.
CONGRATULATIONS, MANGOS IS NOW FULLY CONFIGURED AND FUNCTIONAL
- Open up your MaNGOS Directory
- Right click on realmd.conf and open as Notepad, Textpad, anything with "pad" at the end :P
- Find
Quote:
LoginDatabaseInfo =" Change it to "LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
Your password should be the MySQL Root Password and then everything else should look like what's in the code. After edited, save and close realmd.conf- Right click on mangos.conf and open as Notepad or Textpad
- Open mangosd.conf in notepad. It should be in your root server directory ("C:\MaNGOS).
- Find these lines and set as shown:
o DataDir = "."
o WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
o LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"- Save and close file.
Connecting to your MaNGOS Server
Voila! Create your characters and screw around!
- Go to your MaNGOS Directory
- Double click on realmd.exe
- Double click on mangos.exe
- While it's loading, go to your WoW Directory, open up the realmlist, and change the contents to:
Quote:
set realmlist 127.0.0.1- Start up your WoW.exe
- Wait for the "beep" which indicates that MaNGOS has loaded and you can connect. Then log in with the following sample info (for maximum commands
Quote:
user: administrator
pass: administrator