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
Hi reaper… i was just wondering, yes people might of asked this before but i was wondering if it was possible to set this up and play by yourself offline… i mean i got a modem and everything (btw i dont have a static ip) but i dont wawnt to connect to the internet to play on my server… is it possible (if so could you tell me how please)
actually that’s the point of this post (you run the server process on your own computer and connect directly to it from your own computer too) .. beside i dont have static ip myself and still using slow connection :)
Hello, im a Gm in my server, but i cant talk at all…is it a bug?
Hey i keep getting this error message too:
“World Database: 127.0.0.1;3306;root;root;mangos
Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘root’@
‘localhost’ (using password: YES)
Cannot connect to world database 127.0.0.1;3306;root;root;mangos.
So then i tried doing:
GRANT ALL PRIVILEGES ON `mangos` . * TO ‘mangos’@’localhost’ WITH GRANT OPTION ;”
And so I tried doing what reaper-x said but i got another error message saying:
“ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near ”mangos’ . * TO ‘mangos’@'localhost’ WITH GRANT OPTION’ at line 1″
I’m pretty sure I typed everything in correctly. Still, really don’t know what’s going wrong. Help?
so sorry i forgot to encode the special character used, and it should be like below :
1. GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
2. GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
3. GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
as an addition, i’ve edited my previous comment to show the correct syntax :)
Everyone who feels like a complete idiot raise your hand *raise hand* This is the most straight foreward guide ive seen, but im still stuck. Im trying to get this to work on my new laptop [runs on Vista =(] and im just getting confused. I added u on MSN (u can also email me at theeviltorrent@yahoo.com) and need to get some talk time in sometime because im jsut completely lost =(
just in case you havent looked at the new guide, i’ve updated this post with the link to the new guide :)
ok, well, that didnt help me at all, i already did step one, im confused about step 2, i dont know which database file to extract, like the name of it, and i dont know how to extract it, i already used that page you sent me to for step one and all that worked fine. plz help!
HI! WHEN I TRY TO RUN MANGOSD.EXE IT WILL SHUT DOWN IN 1 SECOND .. THAT HAPPENS WITH REALMD.EXE TOO!!! HELP
IN MANGOSD.EXE THIS ERORR:
2007-08-15 11:32:02 World Database: 127.0.0.1;3306;mangos;mangos;mangos
2007-08-15 11:32:02 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-08-15 11:32:02 ERROR:Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
IN REALMD.EXE THIS ERORR:
2007-08-15 11:31:59 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2007-08-15 11:31:59 ERROR:Cannot connect to database
PLSSSS HELP MEE IM TRYING TO RUN THIS FOR A MONTH!!! PLSPSL THX
That error message mean, you haven’t created the mangos username on your mysql database yet
try reimporting the create-database (it’ll delete all of your mangos related database) or you can just simply run these commands from command prompt :
1. mysql -u root -p (enter your root password when prompted)
2. GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
3. GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
4. GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION ;
5. quit
that’s it
as a note, if you change the database name / if you’re using a modified mangos, the above commands might / might not work for you
ok no i didnt, im an idiot, i just saw the emulators thing at the very top of comments and thought this was the place for them after i posted the first one, anyway, i was wonderin bout step 2 on the how to make a wow server the easier way.
if you prefer to look at my new guide with images, you can start from this link
ohh, sry bout my lat comment, commented in the wrong area…
ok, im soo confused on step 2, what database file, and how do i extract it, cause i got like, 10 database files when i just search for one, and i didnt see anythin for wow on those?
I downloaded the latest revision of mangos (I think it’s 4125) but when i want to import the update.sql file into the mangos database it gives me some kind of syntax error.
Please help. Thx ;-)
I might be using an outdated version of mangos and its loading only a percentage of the WoW content, for example some instances won’t have enemies (in Outlands), wont load some of TBC items, glitchy mobs, and Illidan is in front of Black Temple lol. Also I cant use chat feature and my currency number is frozen at 0 copper. It would be nice to catch you on msn.
Guys i have a mac and i havent found how to join or w/e a private server for that can any1 plz help i wanna get into a private server on a mac
email is Messyboy222@aim.com plz help
I get to the point where I execute mangosd.exe and I get the error:
World Database: 127.0.0.1;3306;mangos;mangos;mangos
Could not connect to MySQL database at 127.0.0.1: Can’t connect to MySQL server on ‘127.0.0.1′ (10061)
Cannot connect to world database 127.0.0.1;3306;mangos;mangos;mangos
I am not sure what is wrong? :( BTW, I did add you on MSN and hopefully I will be able to find you on there.
ok… i got the username and password (administrator) (root) but now it wont get past the “Handshaking” phase of the login. any suggestions?
i’m also haveing trouble loggin in… how do i create an account?
to create account you can simply use the create desired_username desired_password from the mangosd window
and about your previous question, the answer is yes, you’ll need at least 1.12.1 (WoW Classic)
you can get update for your wow classic from various website (fileplanet, filefront, etc) :)
ok i’ve done all the steps but i’m using wow ver 1.9.4 (the only ver i have)… and every time i change the relmlist from us.login.worldofwarcraft.com to 127.0.0.1 i get the error “unable to validate version” and then it gives me a link to the wow support… i’m at a loss as to what to do. do i need ver 1.12.1?
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
but I changed my Environment Variable path to
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin
so when I open CMD why doesn’t it have
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin
nonetheless I put in my folder directory where I put my databases in.
C:\Program Files (x86)\CompleteDB
and all I get is a ‘C\Program’ is not recognized as an internal or external command.
I have all databases in a seperate folder like it says in the guide, but this CMD / MySQL is driving me crazy.
I don’t understand why this isn’t working i’m not else sure what to do if theres any alternative or if you could direct me on what im doing wrong it’d be much much much appreciated
thank you very much.
when at the command prompt use double quotes when typing it .. for example :
“C:\Program files\blabla bleble\”
also if you don’t like command prompt you can use various 3rd party mysql client such as Navicat, SQLYog, etc :)
the .additem wont go beyond 30000 #id and whener i use speed modifiers i get “stuck” on one spot with error: RunSpeedChange player is NOT correct (must be 35.000000 instead 0.000000), force set to correct value. keeps spamming
plz help
also when i sell something in te game I do not recieve any credit (gold, silver or copper)
Ok i installed a whole wow server package that works fine, but It will not display TBC content because it starts out as Original WoW (no patches) as soon as I try installing the new mangos or DBC it will not accept it and will throw me an error message for the maps and for the DBC content. How do I make it compatible with the current WoW version?
Mangos rev3462
I used the version mangos u provided, still when i run REALMD.exe it does not load completely, instead it freezes on the (last line) “realmd process priority set to HIGH” shouldnt there be a user input after that? My ad.exe works perfectly on extracting the maps, I even made sure to get the latest version, but my MANGOSD.exe will play russian roulette with loading the maps (sometimes it will sometimes it displays an error) “ERROR:Map file ‘C:/WoW/Data/maps/0004331.map’ is non-compatible version (outdated?). Please, create new using ad.exe program.” I dont know whats going on, I might have screwed up on a step or two since I began… also I cant seem to put a user in.. it would be better of a help if u contacted me via IM on msn.
actually the last line for realmd window / process is that line :)
as for the map problem, which ad.exe you’re using ? is it the map extractor from here ? or using the new ad.exe from somewhere ?
as a note, the ad.exe from map-extractor is tested only for mangos 3462, and if you’ve downloaded new ad.exe version, then i’d suggest to use the mapextractor from here instead
well i found someone that said to dl NAVICAT and said to do a bunch of work ..now it does it to me .
going*
and btw i have the correct ports open adn i am also using the hamachi vpn software..reaper-z thnx for the help so far just push me over the edge.
thnx man
Hey i got my server goig just fine thnx for the help but when another person trys to login it oes to the suggest realm, when they click okay it sends then back…can someone help me?I have good trouble shooting skills but this is a different thing.
this thing is causing me too much stress along with the fact that my responses are being completely ignored, i give up
ah lol im so sorry, but i live in different timezone (GMT+7) and i’ve been busy setting up the new server (i just moved into new server) :)
and about your question :
i need to know which mangos revision you’re using ? because different mangos revision (for example you can’t use new ad.exe with the old mangos revision for wow classic server and vice versa)
I download the new ad.exe at:
http://www.reaper-x.com/2007/06/28/configuring-mangos-for-tbc-server-or-wow-classic-server-setting-up-private-wow-server/
but still results in the same error message, plz e-mail me for help
krankzor@hotmail.com
my email is krankzor@hotmail.com
ERROR:Map file ‘C:\WoW\Data/maps/0004331.map’ is non-compatible version (outdated?). Please, create new using ad.exe program.
ERROR:Correct *.map files not found in path ‘C:\WoW\Data/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.
that one doesnt make any sense, i already have all the .map files in there
try downloading newer ad.exe (the link can be found on my new wow guide with picture) :)
CANNOT CONNECT TO SERVER WTF
plus everytime i start wow it wont even connect
Melissa:
use serch and find “mangosd”
look in the 6thline I see if you can edit the text there for the explore rate
Please, can i get link to download wow server 1.12.0 or 2.1.3. Send me link to sinisa.nikolic@inet.hr
Thanks
hey can anyone pls tell me how i can change my explore rate on my private server ;) thanks
hey can anyone help me and tell me how can i change my explore rate pls ;) thnks.
I have a free “Noob” Version witch isnt realy for noobs it is just very fast to make a server and a SQL built in and working, you can make online and LAN server with it THO i havent been able to do it yet because of my problem above. Anyway if you want a fast and easy way to get a fully working TBC mangos server ver 2.0.12 working with ver 2.1.3 TBC send me a mail big_matte_123@hotmail.com
when i try to download the mangos revison it wants me to buy it can i get it for free????
HELP i am able to put up a server that i can join localy and my brother can see it on the realm list but when he tries to join it it says “Joining game realm” and then it takes him back to the WoW realm selection screen, over and over again. i need to have a working LAN server up by tomorrow because i am hosting a LAN and WoW is one of the headgames this time. i have worked on this for a week now i need a awnser PLEASE! Awnser on mail or MSN is fine aswell. Big_matte_123@hotmail.com
Oh and i would love other ppl to help me too sooo just e-mail the address above
Hi i really need some help makin the private server so if you(maker103) can give me a message on beastckilla957@aim.com that’ll be great
Can someone please help me with the steps… i’m getting really confused. please contact me at beastckilla957@aim.com or u can aim me at beastckilla957. Thx
Just curiouse if it costsd anything to run your own private server, i have heard from several people that you must pay more every month.
Can someone help me im on step 1 sort of i downloaded mangos but i dont know what program to open it with.
JOIN OUR FREE PRIVATE WoW SERVER!!
4X XP rate :: 100X item drop rate :: no E-mail address required to register :: Lag – Free!!!
http://www.freewebs.com/wowpowerserver/
JOIN OUR FREE PRIVATE WoW SERVER!!
4X XP rate :: 100X item drop rate :: no E-mail address required to register :: Lag – Free!!!
right well i have made a private server its all up and running but im new to this so im a bit confused..
i would lke to change the rates and put in custom venders if you wish to contact e-mail its jayp16boi@hotmail.co.uk.
i am very greatful for anu help thank you
Pizzy can u ask ur friend to help me to make a private server… i’ve tryed other guides but they all don’t work for me … i think i might be missing stuff… please send me a message back on Beastckilla957@aim.com
Hi, my friend recently created a private server, i think he used your steps, and he’s the only one who can get on it, whenever the rest of us try to connect we get stuck at “logging into game server” then it takes us right back to the reamlist
we are not running mySQL but the admin can get on w/o it
I don’t understand some of the things on the website sooo… i want to know ur screen name so we can do IM. please send me a mail or somthing for a solution.
faisal, you can just need to update mangos to atleas 4112 to update to 2.1.3
e-turray.com/file/mangos/sdb/?dir= is good for sdb
mangos-file.de.vu is good for mangos revisions. both update fairily often just need to see what works, i dont rembember witch versions i used, sorry
hope it helps
After the latest patch. I can’t connect to the server. It says the versions are not correct. Well the error doesn’t say that but it’s pretty much means that my client has a different version than what’s expected by the server. Is there are way to update/patch the server so it can run the latest Blizzard patched client.
maker103, my server is not on the public internet yet but once I get my new dsl. you are more than welcome to be the GM on there.