How to Configure MaNGOS the World of Warcraft Emulator

Please check the new version on how to create wow private server for better version. Besides the new guide list everything in a single page for easier reading

This is the old version of my WoW Private Server Guide, the new version that gives you a detailed step (with images) can be found at below links :

  1. Installing MySQL
  2. Setting up the Mangos
  3. Just in case you want to create lan party
  4. Setting up the webserver to put registration page

It’s been a while since the last time i post something to my blog and that’s because i’ve been playing World of Warcraft in various private / public server, from WowScape, WowFusion, b3ckswow, etc (i’m switching various server because some of them always disconnect me a lot) …

But let’s keep that aside shall we ? because this time i’ll post a guide on how to setup your own world of warcraft private server using MaNGOS (i’m sure there are many other WoW Emulator out there, but i choose this one instead)

And as a note, currently i’m using the World of Warcraft classic version (1.12.1) and this guide might or might not be useful for you if you’re trying to setup TBC (The Burning Crusade) server

So here’s the step …

Update :

If you find this guide a little bit confusing, maybe you should try reading my new guide on how to create wow private server the easier way .. also to those who’s keep getting SQL error or want the easiest way of importing the sql, i already uploaded my mangos sdb (updated till changeset 156) and already tested to work with Mangos Rev3462

You can find all of the files required (including mangos itself) in my new post .. so be sure to check it out too ;)

Required Software :

  • MySQL : This is important because MaNGOS use MySQL as it’s database and currently i’m running the 5.0.xx version
  • MaNGOS : Without this you can not run a private server of course but do not forget to get the binary files instead of the source files unless you have Microsoft Visual Studio 2003 ++ installed and want to compile it by yourself (currently i only have MSVC 6 so there’s no way i can compile it, and the Visual Studio 2005 Express version is to large for me to download it)
  • Map Extractor (both of them included) :
  1. Ad.exe : This is used to extract maps files from your World of Warcraft files
  2. MPQE : This is used to create DBC files which is extracted from WoW games data too
  • SDB : This is the database used by MaNGOS and to make your private server playable of course this is a must. And the one you must download first is SDB FULL 0.6.2 including it’s hotfix and it’s update (you must register first)
  • New Update :

    Im sorry previously i did not upload the changeset 141 till 156 files because i thought everyone can find the changesets files easily (also i do not know if the SDB team allowed me to put that thing here) … but to make thing easier (and that’s the purpose) .. i decided to upload the changesets file here (if it’s not allowed i’ll removed it immediately) :

    You must run the sql files in order (eg 141, 142, 143, and so on) and the step to execute this sql script is described in step 5

    Optional Software :

    • MySQL Client such as Phpmyadmin, etc (although in this example i did not tell you how to use those mysql client) so feel free to use mysql client or not

    Special Note :

    • If you get an error message saying the maps files is outdated or anything similar to that message from the Mangos Log, that means the Ad.exe you’re using is incompatible (i have experienced this) and i’m pretty sure the Ad.exe you’re using is for the Burning Crusade client so try getting the old version a little bit
    • Im currently using Mangos Revision 3459, because the later revision from 3463 and above did not work for me (i have tested it) and i’m sure it was caused because i do not have TBC installed
    • Im currently using SDB 0.6.2 and updated till changeset 1.5.6
    • And as a reminder, i’m using World of Warcraft Client version 1.12.1

    Let’s begin …

    I assume you’ve downloaded all the required software and now as for the next step :

    Note : If you did not set up password for the root account of your mysql database the default password is blank .. but in this example i’ll write username as username and password as password :P

    1. Install MySQL and do not forget to enable InnoDB when prompted also check to make sure MySQL is in the Environment Variable Path … and activate the mysql service if you havent do so or if it is not started yet and you’re done installing MySQL

    Note : Setting up environment variable for mysql is necessary to make thing easier, because you can execute it from any location

    2. Extract the mangos program you’ve downloaded into your desired location for example, C:\WoW\Mangos

    3. Open the Run command (Start -> Run) and type cmd and press enter and you’ll see command prompt window

    4. Now type this in the command prompt :

    • cd /d C:\WoW\Mangos\sql
    • mysql -u username -p -v < create_mysql.sql
    • mysql -u username -p -v -D realmd < realmd.sql

    Note : Feel free to adjust database name to your liking but in this example i only show you the easiest way of doing it

    5. Extract the SDB Full 0.6.2 file, SDB 0.6.2 Hotfix, and SDB Update into desired location, for example C:\WoW\SDB and type this in the command prompt :

    • cd /d C:\WoW\SDB
    • mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB.sql
    • mysql -u username -p -v -D mangos < SDB_0.6.2_FULL_DB_HotFix.sql
    • and continue with the update by typing the same command with the exception you must change the filename after “<” character

    Note : You must update the database according to it’s version number (0.6.2 Full database equal to changelog / revision 1.4.0) so the update you must get is 1.4.1 and above .. as an addition, it might take a while before the full database imported so you can take a break while doing so

    And now you’re done setting up database for MaNGOS … and feel free to delete the extracted sdb file

    6. Copy the ad.exe into your WoW game directory, for example C:\Program Files\World of Warcraft. And create maps directory in there and run the ad.exe .. and yet another break time :) .. and when this process finished move the maps directory into your desired location, for example C:\WoW\data\maps

    7. Now you’ll need to copy MPQE you’ve downloaded earlier into WoW games data directory, for example C:\Program files\World of Warcraft\Data. And now open command prompt again and type this :

    • cd /d C:\Program Files\World of Warcraft\Data
    • MPQE /p dbc.MPQ DBFilesClient\*.dbc

    You’ll see another directory created called MPQOUT inside the data directory. Now go open that directory and rename the DBFilesClient directory to DBC, and move it into C:\WoW\Data\DBC for example

    Congratulation, now you’ve finished setting up the data required for mangos

    8. Now for the last step you’ll need to open the mangosd.conf inside the mangos directory and edit below lines :

    • Change the DataDir = “@[email protected]” into your data location inside the quotes, in this example it would be like this “C:\WoW\data”

    Now you’ve finished configuring Mangos and it’s database completely, as for the next step .. try running the mangosd.exe and realmd.exe and see if you can run it without problem or not .. if there’s no problem you can go to the next step (you do not need to close the realmd process and mangosd process)

    9. Go to your World of Warcraft game directory and open the file using notepad or other text editor program .. and edit it like below :

    • set realmlist

    Now you’ve finished configuring WoW to used your mangos server

    10. Now you can connect to your own server, if you want to create new user account you can do so by typing create username password from the mangosd window (it’ll create normal user account). But if you want to create GM account you can do so by typing this from normal command line (type cmd in the run command) and type below lines :

    • mysql -u username -p
    • USE `realmd`;
    • INSERT INTO `account` VALUES (NULL, 'username', 'password', '3', NULL, NULL, NULL, '', CURRENT_TIMESTAMP, '0', '', '0', '0', '0000-00-00 00:00:00', '0');
    • quit

    To get commands for your GM account, you can type : .commands at the chat window inside the game

    That’s it you’re finished configuring Mangos and WoW to be played locally :) and here’s some screenshot (please don’t laugh on my equipment because i dont know anything about good items or equipment in WoW and that’s why i choose to play it locally first to learn about WoW) :)

    WoW Screenshot 1

    WoW Screenshot 2

    Updated Screenshot :

    WoW Screenshot 2

    WoW Screenshot 3

    WoW Screenshot 4


    Note: Comment may not appear right away.

    389 comments on “How to Configure MaNGOS the World of Warcraft Emulator

    1. Hi,
      Do you know any IRC script that can change the channel`s topic to the server status for example:
      World: .:ONLINE:. Realmd .:Online:.

    2. Ive set up my own mangos server right,now at a lan i was playing with friends and i came far so i used the writepdump command to save my character and saved it in my server folder,how do i use the loadpdump command to load that account again so i can play with it? plzzz help

    3. When I try running Mangosd.exe it runs and auto-closes, so I look in the log file and it says:

      ERROR:Realm ID not defined in configuration file

      I tried setting the Realm ID to a list of different things, including the server IP and the numerical values that represent each type of server (1 for Normal, 4 for PVP, as listed in the mangosd conf file) but nothing is working, I keep getting that error.

      Aside from that, a helpful and well written guide.

      hit me up on AOLIM as m0nk31sl4y3r or I’ll keep checking the boards to see if there’s a response.

      Thanks, D

    4. Hi,

      I finish the above procedure, but when i run mangosd.exe, at first all seems ok and then display showw lines like these:

      TEST Ship moved to -1209.486938 -4533.784180 0.000000
      Feathermoon Ferry moved to -5121.050293 3185.962646 0.000000
      Proudmoore’s Treasure moved to -4263.525391 -4823.310547 0.000000
      TEST Ship moved to -1312.261719 -4778.081543 0.000000
      Proudmoore’s Treasure moved to -4201.202637 -4718.658203 0.000000
      Zeppelin – Orgrimmar to Undercity moved to 2731.303467 1577.617310 145.945023
      Feathermoon Ferry moved to -5130.470215 3471.471436 0.000000
      Proudmoore’s Treasure moved to -4100.875488 -4692.390137 0.000000
      TEST Ship moved to -1448.969604 -4947.816895 0.000000
      Feathermoon Ferry moved to -5089.303711 3705.992188 0.000000
      TEST Ship moved to -1652.698853 -5107.111816 0.000000
      TEST Ship moved to -14366.628906 1302.032959 0.000000
      Feathermoon Ferry moved to -5009.833496 3853.381592 0.000000
      Zeppelin – Orgrimmar to Undercity moved to 2318.575439 1226.515869 153.362000
      Proudmoore’s Treasure moved to -4016.389893 -4740.588379 0.000000
      Feathermoon Ferry moved to -4880.222168 3939.895752 0.000000
      TEST Ship moved to -14338.303711 1081.086792 0.000000
      Feathermoon Ferry moved to -4693.104980 3962.071289 0.000000
      Zeppelin – Orgrimmar to Undercity moved to 2123.634033 1023.386597 153.473007
      TEST Ship moved to -14366.722656 867.312866 0.000000

      What is that???

      If i run realmd.exe all seems OK..

      1. that mean, mangos is working … you can prevent mangos from showing debug information by changing the debug value in mangosd.conf :)

    5. Hello I’m trying to set up my own private server is this server good? “DJ Executable Mangos Server”

      If not??? My client is 2.0 enUS is this compatible with your Mangos.

      Please Reply Thanks

    6. do you mind helping me? ok i got mangos all set up and everything i am able to play on it but is there any way that you can update it so there arnt a 100000000 bugs? such as when i put a money command in it works i can buy stuff but it says i dont have any money and anotherthing is most of the commands dont works

    7. hi,
      i was wondering if you know how i can do something so that when people chat on my irc server from my website what they say shows on the game server(mangos).

    8. I am looking for a good GM command compilation. Mainly the command to raise professions to max level and to raise the riding skill to max level. Thanks for your time.

      1. If you get an answer to this question, please let me know. I’m trying to find the same thing.

    9. Is anyone else haveing Problems with the Hunter class not being able to Revive Pet and Feed Pet. Also with warlock not being able to pruchase grimores for their pets and able to get thier Other pets like VW SC FH please if anyone knows what the tag numbers for the hunter spells please email me to let me know. [email protected]

    10. i changed my realmlist source thing to a private server and i forgot to save the original, so what is the original source thing? sorry I know this isn’t what this story is about, but i don’t really know where else to ask=(

      1. lol … nah dont worry about it :)

        here’s the original US WoW realmlist

    11. I’m having a similar problem to this, as well:

      2007-05-29 02:33:12 World Database:;3306;mangos;mangos;mangos
      2007-05-29 02:33:12 Login Database:;3306;mangos;mangos;realmd
      2007-05-29 02:33:12 Realm running as realm ID 1
      2007-05-29 02:33:12 Using DataDir C:\WoW\Data/
      2007-05-29 02:33:12 Initialize data stores…
      2007-05-29 02:33:12
      2007-05-29 02:33:12 >> Loaded 28 data stores
      2007-05-29 02:33:12
      2007-05-29 02:33:12 Cleaning up instances…
      2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` 0
      2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.creature_respawn’ doesn’t exist
      2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` 0
      2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.gameobject_respawn’ doesn’t exist
      2007-05-29 02:33:12 ERROR:SQL: SELECT `id` FROM `instance`
      2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
      2007-05-29 02:33:12 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1180377192)
      2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.instance’ doesn’t exist
      2007-05-29 02:33:12
      2007-05-29 02:33:12 >> Initialized 0 instances, deleted 0 old instances
      2007-05-29 02:33:12 Packing instances…
      2007-05-29 02:33:12
      2007-05-29 02:33:12 >> Instance numbers remapped, next instance id is 1
      2007-05-29 02:33:12 Loading Game Object Templates…
      2007-05-29 02:33:12 ERROR:SQL: SELECT MAX(`entry`) FROM `gameobject_template`
      2007-05-29 02:33:12 ERROR:query ERROR: Table ‘mangos.gameobject_template’ doesn’t exist
      2007-05-29 02:33:12 ERROR:Error loading `gameobject_template` table (not exist?)

    12. When I run ad.exe I get an error saying error opening patch-2.MPQ or somthing like that but ad.exe keeps running is this a problem? if it is how do I get patch-2.MPQ? ty I am really stuck on this!

    13. My server is working perfectly… apart from the Dark Portal… it’s not working -.- i can’t go through it… anyone help?