Custom Search
Creating WoW Private Server the easier way (perhaps)
Posted by Reaper-X May 5 2007 12:27 pm
Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)
Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)
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 :
- Installing MySQL
Setting up the Mangos- Just in case you want to create lan party
- Setting up the webserver to put registration page
Maybe my previous post about creating WoW private server is a little bit confusing for some people and that’s why i create another post on how to set up world of warcraft private server once again but this time … i promise it is not going to be confusing like before :D … and actually i should be thanking everyone who put comments on my previous post, because of their comments i was able to get new topics for my blog … hahaha
Okay and that’s all on the introduction part … now let’s start the guide, but before that please keep this in mind, this guide tested with 1.12.1 World of Warcraft Client (known as WoW Classic) non modified in any part and tested to work with Mangos Revision 3462, but this guide can also be used if you’re going to create The Burning Crusade server although you’ll need to get different database dump from someone else, and of course getting the newer mangos release :
Required Software
1. Mangos Revision 3462 : The mangos release is compiled by Maxi and this release also include the following patches :
- ScriptDev2 R34
- Honor 0.71
- MCH 1.5c
And just like i said to make thing easier, i upload this mangos release (just in case Maxi reading this, and he does not want me to upload his file here … let me know immediately so i can remove it … because i already forgot where i get his release) .. i think it is from his userbeam / beam something folder
2. Complete SDB with Changesets 156 : Because there’re problem for some people when importing each changeset, i decided to release the SDB used by me … and this SDB updated till changesets 156
But i also include, the create database, and realmd database to make thing even easier
3. MySQL : Essential program, the above 2 files can not be used if you dont have this installed :)
4. Map & DBC Extractor : This is tested to work with World of Warcraft Client version 1.12.1 and Mangos Revision 3459 and Revision 3462 only
But just as i said before, to make thing simpler. I’ve uploaded the DBC Files (maps not included because the file size is bigger than i thought, and my connection speed is nothing compared to all of you) .. and that means all you have to do is just using the ad.exe / map extractor to extract the WoW Maps
Mirror to download the above files if you’re having problem with Megaupload :
Complete SDB Dump for Mangos 3462 WoW ClassicMangos 3462 by MaxiWorld of Warcraft 1.12.1 DBC Files
Let’s Start
I assume you’ve already downloaded the required software and already installed it (for more in-depth WoW Mangos installation please refer to my previous post)
1. Install the MySQL Software and configure it accordingly, in this example MySQL installed in C:\MySQL and using the default root password which is blank
2. Extract the Complete Database file somewhere in your harddisk, and you’ll see there’re 3 files :
- create-database.sql
- realm-database-full.sql
- mangos-full-for-rev3462.sql
Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory :)
- C:\MySQL\bin\mysql.exe -u root < create-database.sql
- C:\MySQL\bin\mysql.exe -u root -D realmd < realm-database-full.sql
- C:\MySQL\bin\mysql.exe -u root -D mangos < mangos-full-for-rev3462.sql
Note : The create database will also drop your realmd and mangos database if it is found .. i do this in order to make thing easier (how many times did i say this words in this post) lol
Yet another Note : Extract the database into the same path where your MySQL bin located, or if you already extracted it somewhere adjust the path like below for example :
C:\MySQL\bin\mysql.exe -u root < X:\where_SDB_extracted\create-database.sql
3. Put the downloaded DBC Directory somewhere, in this example C:\WoW\Data\DBC
4. Copy the ad.exe into your WoW installation directory also create directory called maps and run it .. and wait till finished and move the maps directory into C:\WoW\Data\maps
5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below
DataDir = “C:/WoW/Data”
If you’re using the example path given in this guide, you can use the above datadir configuration
6. Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server
7.I’m sorry i forgot to write the last step in this post (thanks to GreekSoul). Now since you’ve finished configuring the server all you have to do now is configuring the client (WoW game) to connect to your server instead of using the default / official server. And it can be done by open the realmlist.wtf in your WoW Game directory and change the realmlist into 127.0.0.1 … and you’re all set
Common Question
I create this part thanks to all the commenters before … especially to metaltildea, PepsiG, Xtonic, luke, Venomz, etc
Q : hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :(
A : If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message … also CMD only work in Windows 2K (correct me if i’m wrong because i already forget about it) and Windows XP (guaranteed to work)
Q : I forget about the signs that dont let me post it.. ERROR 1045 (28000): Access denied for user `username @ localhost` (using password: NO)
A : That error message means, you’re trying to use wrong password for a username, username does not exist, etc .. but in this case, you’re trying to use non existent username (because it was an example)
Q : ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)
A : If you’re trying to use named pipe (this mysql feature only can only be used on NT series such as Windows XP) and you havent configured mysql to do so .. you’ll get that message … to fix it you just have to put below line into you my.ini file (do not forget to restart the mysql service after you done)
enable-named-pipe
Q : Can i import the official data from Blizzard server into my mangos server ?
A : The answer is no, because … blizzard is using different server software which is not available to public .. and no one have access to their server :P ..
Q : my add.exe wont run in my wow map
A : Did you create the maps folder first ? if you did not create it you’ll get an error message. Also you’ll need to run it in your root directory of your WoW installation directory
Q : I can’t run ad.exe or MPQE
A : Im sure there’re missing runtime in your windows system, try downloading and installing below 2 files first and see if it’s fixes the problem or not
- Microsoft .NET 2 Runtime
- Microsoft Visual C++ 2005 Redistributable Package
Q : ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1
A : You’re trying to insert value higher than the allowed value specified in your mysql table … but in this case, this error message seems strange, because i have no problem importing the SDB files including it’s changesets … and that’s why i create this post and upload my database dump :)
Q : I want to be a GM in my mangos server
A : Look at the step #10 in my in-depth explanation on setting up mangos server (do not copy paste the text directly because it’ll give you error message) … and if you get other error message just leave comment here :)
Q : What are the GM Commands ?
A : After making your account to be a GM account, type this ingame .commands and you’ll see available commands to use
Q : My friends can’t connect to my server ?
A : Try checking your configuration especially at port configuration, and make sure there’s no conflict
Okay that’s all for now … i’ll be sure to update this post / create new post if i found something new from you :)
Trackbacks/Pingbacks
Connect with me
in my.ini (typicly in c:\Program Files\mysql\mysql server 5 or c:\windows) and add the following value to the file
# SERVER SECTION
skip_grant_tables = 1
this should allow you to log in to your database, because the grant tables are skipped when mysql is loaded (in services)
also, I *PERSONALLY* recommend the mysql user name be “root” and the password be anything you want, MySQL will work better that way
# Mystic
Ah it seems that you were running the Mangos TBC server … btw if you use new mangos build you’ll need to add ‘1′ after the last ‘0′
# Eagle472
Thank you for helping me :) … and yes Eagle are correct
ok, now i have a error when i try to add a GM account with the command…
ERROR 1136 (21S01): Column count doesn’t match value count at row 1
pls help
RE: Daniel
It kindof sounds like your sql installation directory is no longer in the path. During the MySQL Server Instance Configuration there is a step where you can install MySQL as a service (win 2k/xp) and also set it to be included in the path system variable. To check open a command prompt (cmd.exe), then at any point in the command line type path and press enter. The system will list a bunch of directories, one of these should be C:\(MySQL Install Location)\bin. For example if you followed Reaper’s Installation it would be C:\MySQL\bin. If the path is missing you can re-run the configuration wizard and change the settings to include the Path setting. Hope this helps.
Really appreciate you taking the time to set up this guide. Helped me out alot.
I’m just wondering if you know where I can get the Mangos revision 3735 for BC expansion?
and now i tried it again and it says
C:\Documents and Settings\Daniel>mysql
‘mysql’ is not recognized as an internal or external command,
operable program or batch file.
ok so i typed in mysql, and now it does nothing, it says C:\blah\blah\blah\cmd mysql
is there anyway you can upload the map files? i downloaded the updates for C++ and installed all the missing runtime components and the map add wont work. i have even tried redoing the whole thing a couple of times, it still wont work… please upload them?
unfortunately some people has been asking this question too (yesterday)
and i think it all happen because of the latest blizzard patch (2.1) … some people who previously got their server working without problem always having problem after they’ve upgraded to WoW 2.1 :(
I am sure I must just be missing something. But I am unable to connect to the local server even though all the server parts appear to be functioning, at least they are doing something without displaying an error message. I have downloaded mangos, MySQL, the SDB, the Extractor, and the DBC downloads from above followed the instructions and appear to have the server running the mangos screen shows alot of this thing moved to x,y type information and the realmd program seems to be ok it says something about adding a realm and the process being set to high priority. Then I change the realmlist.wtf file to “set realmlist 127.0.0.1″ and launch it using wow.exe running version 2.1.x.x the latest version blizzard has out. It would come up to the main login page with the dark portal in the background and the music asking for username and password. Then say that it can’t verify game data and that something is corrupt. I then try reinstalling wow then bc and patching up to version 2.0.12.x the version pevious to 2.1.x.x and change the wtf file and get the same problem. I then try another reinstall of wow and then loading bc no patches change the wtf file and again same problem. Is this a problem with my installation of wow or am I missing something from the server that the client does not recognize it as a server and trys to get to blizzard? Please help.
# Bernard
I can help you if you want just add me on msn
# Daniel
open command prompt and type this :
mysql
thats it … tell me what’s the result
# Eagle472
if you’re using TBC client, you’ll need to get the latest ad.exe which is available for download from mangos SVN repository
look at my previous comment here
I managed to fis the other issue I was having by downloading another version of the ad.exe program now mangos complains about a map file being non-compatible “Map file ‘c:/wow/data/maps/0004331.map’ is non-compatible version (outdated?). P
lease, create new using ad.exe program.” Thought maby it was a new map and mangos could not run it with the version I have so I moved the map file but it needs that file apparently so i put it back and continue to get the same old error message.
Maby I am missing something but when I try to run the ad.exe from within my normal working wow directory it displays some errors that appear to mean it can’t find the files. They appear like “Opening ./Data/patch-2.mpq” Then you get “Error opening archive ./Data/patch-2.mpq” I actually found a patch.mpq another file it wanted and when i put it in C:\data\patch.mpq the error went away in the ad.exe program but it still can’t continue after about the fourth MPQ file it says something about an Assertion Failed: and some header things and then like it wants a file from a D: drive. Is there some way to get it to stop or is this just a result of the missing MPQ’s from before the error?
When i use the CMD commands it always says
the system cannot find the specified file, and i can see they are both there. HELP!!
hello is there anyone from europe that can help me using mysql for my server please? or can help me via remote assistance
Im sorry for late reply everyone, because my old computer has finally rest in peace, and today i just bought a new replacement for it :)
# Shinjitsu
Hii shinjitsu … try reading this and if you still have problem feel free to talk to me directly on MSN
# Snaef98
I believe it’ll not work with the trial version, but recently i just talked with someone over MSN, and he says he has a problem with his mangos TBC downloaded from torrent and when i saw carefully it seems that he downloaded mangos and database (which is not work on his full version) that can be used on trial version so i think maybe you should try searching for it (since i forgot the url)
# Kotz
I believe you’re trying to use incorrect password / username for your mysql account … did you change anything when installing mysql ?
# CoolTool
If you can make install wow to use different path and registry, i think its possible although i havent tried it yet :D
perhaps virtual machine software can help you accomplish this ;)
Hint : Microsoft Virtual PC 2007 (free)
I currently play WoW on Official servers But also whould like to have my own private server. Is it possible to have my normal WoW that I log into Bliz servers to play and the Private server at the same time? Please shed some light on this as I would really like to try out the priv server :)
Thank you
To robert,theres a guide on how to create your own realm at the top of the page
can you tell me how to create my own realm
im having a problem with mangosd.exe and realmd.exe,when i start it,its just there for a few seconds and then it shuts down,on the note .log they create it says : mangos :2007-05-21 21:12:41 Using configuration file mangosd.conf.
2007-05-21 21:12:41 MaNGOS daemon /0.7-SVN (Win32)
2007-05-21 21:12:41 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2007-05-21 21:12:41 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-21 21:12:41 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-05-21 21:12:41 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
and on realm :2007-05-21 21:12:42 Using configuration file realmd.conf.
2007-05-21 21:12:42 MaNGOS realm daemon /0.7-SVN (Win32)
2007-05-21 21:12:42 to stop.
2007-05-21 21:12:42 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-21 21:12:42 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-05-21 21:12:42 ERROR:Cannot connect to database
plz,what am i doing wrong ?
I need some help.
In the cmd line i type : “C:\MySQL\bin\mysql.exe -u melon
:D Thanks Reaper-X I got it all up and running now.
i don’t now why it diden’t working last time i tryed, but now it connects just like THAT! now.
Thanks again Reaper-X you realy are doing justice to the community :D
Would this software work with the client downloaded for the free trial account? Its the full version with burning crusade i think its 2.0.0 before patching. If you could point me in the direction of a really good emulator source and Database source that works good with this version id be greatful, it seems alot of the emulator links are outdated or dead due to blizzard cracking down on stuff. thanks
so, i want to get my buddies to play with me, but the catch is, i want them to play from their houses and whatnot. i have everything set properly, mangos and realmd load up fine, however, i also cannot enter the world from my other pc because it keeps sending me back to the realmlist. heres the catch, im using my friends internet to host the server. what should i do?
# dvd
do you mean restore your WoW so it can play on official server again ? if that’s your question
the answer is yes
you just need to edit the realmlist.wtf in your WoW installation directory and change the 127.0.0.1 into :
us.logon.worldofwarcraft.com
Hope that help :)
i need to know how to get my old default wow server back i already played the private server and i got bored and i cant get back on the normal server…so can u help me out?
BUT… wen i load up WoW (witch is not the normal one i play with my account, it is another 1 i installed then changed the name of the original) and try to login, it says Disconnected from Server.
Could you be more specific about this ?
also i don’t have any idea wot my username or password should be for logging in to the server, i’m just putting in any random letters
If you dont want to create new account, you can use the built in account from Mangos
here’s the username you can use to login :
full access
- username : administrator
- password : administrator
GM access
- username : gamemaster
- password : gamemaster
Thank You Very Much Reaper-X i can now run Mangosd.exe and realmd.exe, they both seem to be working.
mangosd all loads up and starts saying the zeppelin is moving…and such
realmd says wot is says ( i read a post where some 1 asks about it and u say it fine.
BUT… wen i load up WoW (witch is not the normal one i play with my account, it is another 1 i installed then changed the name of the original) and try to login, it says Disconnected from Server.
also i don’t have any idea wot my username or password should be for logging in to the server, i’m just putting in any random letters
noob me didnt extract the files when i thought i did lol, nm bout my last posts- now im having a problem with
C:\MySQL\bin\mysql.exe -u root
ok, encountered another problem, how am i supposed to configure the mysql? i see the configuration settings documents but im not sure which fits my comp best
NM about the SQL. looked around the site and found the freeby download section sry bout tht
also to my above post: im trying to set up a 2.0.12 server if any 1 knows another guide that would help greatly, atm 1.12.1 is basically practice for me
Ok sorry I was trying to use it with firefox. It works now. :P
Hello! There’s just one problem about this. What do I do to get Mangos Revision 3462 and the other things? When I click on the link it takes me to the site for Megaupload. I’ve already downloaded it but it still doesn’t want to work. Do you have any other links?
# R3d I
Im sorry but my spam filtering thought your comment was spam lol … fortunately i checked it and saw your legitimate comment :)
as for your question :
2007-05-16 13:09:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@’localhost’ (using password: YES)
if you were using database from this site, did you run (i mean execute) the create_database.sql first ? before launching the mangosd process and realmd process ?
and if you use database and mangos release from another site, try go to the sql directory located in your mangos directory and run create sql first :)
Sorry if this go thow twice dont think it posted the first time
If u can plz help me, iv done step 6 “Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server” (also changed reallist.wtf) and wen i try to log in it says Disconnected from Server.
I looked back over the steps and found Server & Realmd text docs appeard after running mangosd.exe , realmd.exe, and i think there saying my access wos denied.
This is the Server text doc
2007-05-16 13:09:26 Using configuration file mangosd.conf.
2007-05-16 13:09:26 MaNGOS daemon /0.7-SVN (Win32)
2007-05-16 13:09:26 to stop.
MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM
2007-05-16 13:09:26 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-05-16 13:09:27 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-05-16 13:09:27 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
And the Realmd
2007-05-16 13:09:29 Using configuration file realmd.conf.
2007-05-16 13:09:29 MaNGOS realm daemon /0.7-SVN (Win32)
2007-05-16 13:09:29 to stop.
2007-05-16 13:09:29 Database: 127.0.0.1;3306;mangos;mangos;realmd
2007-05-16 13:09:29 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-05-16 13:09:29 ERROR:Cannot connect to database
Can u plz help me with my problem.
# Danman
Try copy paste this directly (i’ve encoded the ` and ' character so you and other can copy paste directly from the post)
INSERT INTO `account` VALUES (NULL, 'username', 'password', '3', NULL, NULL, NULL, '', CURRENT_TIMESTAMP, '0', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0');
try it
Maybe you will be able to help me if I make it easier on you.
This is what I do in the cmd:
mysql -u root -p
I enter my password
USE ‘realmd’;
Then it says Database changed
Then I type:
INSERT INTO `account` VALUES (NULL, ‘username’, ‘password’, ‘3′, NULL, NULL, NULL, ”, CURRENT_TIMESTAMP, ‘0′, ‘127.0.0.1′, ‘0′, ‘0′, ‘0000-00-00 00:00:00′, ‘0′);
and I type it continuesly on the same line with the auto wrap around with no returns or anything like that. But when I hit enter nothing happens except a arrow appears on the next line like it wants me to type something else. I think I am entering that last line incorretly. Should I hit enter and a certain point? All your help is wonderful.
# mike
MySQL is free (grab the community version) :) … so you dont have to worry about it, as for MS SQL, im sorry but i havent tried MS SQL :(
# nicca
Well .. maybe you could give me a detailed description on what error you’re experiencing ?
Do you need to pay for the MySql or is it free?
If you have to pay has anyone tried mircosoft’s SQL server 2005 express edition?
Reaper! You gotta help me out on this one , ive been sitiing here now for 2 days ” yeah 2 days !! ” and stil cant figure out whats cousing my problem.
I get connecting for 10-15secs then it says Unnable to connect ?! – Any ideas PLEASE answer here or add me on msn: playableplayer@hotmail.com
OK sent it, basicly i just need a step by step word for word tab by tab description of what to do …goodluck lol
done (actually i already sent reply at 1:40 PM or 5 minutes after you posted your last message here)
note : the displayed time on comments are using my local timezone :)
Sent a confirmation email first, just reply so i know its you. Ill give quick debreif… I downloaded Mangos Database Handler 0.4Svn from bluesailer.com and updated it to rev 254, Mysql from the mysql.com site (the latest version (6.0)) I use .rar (trail) to open up the files which you posted.. Bigger email coming soon
sure, just take a look at the about me page ;) i already put my email address there lol
Reaper x, where is your email, ill send u a nice big email explaining all the problems im having… oh and the server log is so full of crap u dont wanna see it, i try to open something for 3 seconds and it spams this into the log:
Realmd server crashed at 15/05/2007 4:01:43 PM. It lasted 0 minutes
Yeah so if i could grab ur email ill send u stuff
# Danman
When you type the INSERT INTO did you get response like this :
Query OK, 1 row affected
If you get that message that means its already written into the database .. and you just need to login using that username you just created ;)
# LukeZ
There are 2 possibilities :
1. Your system missing the runtime required
2. You forgot to create the maps folder first before running it :)
# angus
me again :P can u add me on msn or email me to melp me out ?
Sure but what is your timezone ? you can see my local time by using Google
http://www.google.com/search?q=jakarta+time
# cinnam0nr011
Your welcome cinnamon :)
# Inittowinit
Hm … could you post the server log here ?
as for the ERROR Message :
#28000Access denied for user ‘root’@’localhost’(using password:YES)
that means you use wrong password
by default, root password is blank / none :)
Ok im stuck at the same problems for the last 12 hours, first one is when i click start the mangosd it says “The path selected does not contain Mangosd.exe” the second problem is that it keeps saying that My configuration file is rong and that i should modify my options… #28000Access denied for user ‘root’@'localhost’(using password:YES)
I have Mysql 6 and i have the Rev.254 Mangos Database handler…
Any help would be great thanks…
Okay, Thanks for all your help ^^ Appreciated it. This means that my server is all good now. (all thanks to you :D)