Creating WoW Private Server the easier way (perhaps)
By Reaper-X on May 5, 2007 in Emulators, Freeware, Games, Guide, MMORPG, Software, Tutorials
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 :)
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
hey can you help me with mySQL im at the step where it tell me to configure the mysql server server instance where they are like 4 white spot whrited prepare configuration ,write configuration file , start service , apply security setting … i click on execute and there an X in the white circle beyond de start service and its writed CANNOT CREATE WINDOWS SERVICE FOR MySQL. ERROR: 0
Hello GreekSoul
Did you ever installed mysql before ? btw what is your operating system ? is it windows xp ? if it’s windows xp try typing this at the Run in start menu
services.msc
and look if mysql service already installed there or not
if it’s already installed, try right clicking on the mysql service and choose Start
Hi I have a problem connecting to the Mangos server from another pc. I can connect from if I run WOW on the server PC, but not from another. allready checked the realmlist file. Thanks
hi i have revision 3459 i just wanted to know how i could update from my mangos to revision 3462 or if theres really a big difference or not if not i will stay how i am. mainly wanted to know if there was any new fixes for pets in revision 3462 that there werent in 3459 thanks
Ok Thx For Your help ! i do all the steps and everything seem to had worked without some ERROR but now im wondering ” 6. Run the mangosd.exe and realmd.exe …. and you’re finished ” its ok i run both of it and all seem to work properly but now how can i connect and play on my server ??? ( Sorry for my noobs question but i don’t know , i’m skilled a bit with computer and C++ ect… but first time i create a server and ect… ) thx for your help very apreciated ! ….
# Greeksoul
Im so sorry GreekSoul, i forgot to add the last step which is involved editing the realmlist file (i forgot i wrote it in my previous post) lol
And thank you very much for telling me about this .. and this post has been updated now
# Meza
I dont know much about pet in wow but i didnt see anything related to pet in changelog 3462
btw here’s the changelog of Mangos 3462 (3460 - 3462) from its svn :
-Fixed compiler warning at float->uint32 conversion
- Revert talent related code changes from [3460] until additional research.
-Fixed “When player sends a mail with C.O.D and the mail expires and is returned to sender. And when original poster will take item back he must pay C.O.D and money are send to original reciver” - patch provided by Marty .. thx
-Fixed: talents bonus loading: load auras after spell load and talent initialize. Patch provided by Ianos Gnatiuc.
-Fixed: use special packet instead text notifier for instance warning about forced exit. Patch provided by TOM_RUS.
And changelog for 3459 :
-Fixed: update pet/charmed pvp state at owner player pvp state update.
-Replace function Unit::isInCombatWithPlayer to more useful for neutral city guard scripting Unit::isAttackingPlayer.
# ME24
Ah it seems you’re trying to set up mangos for LAN ? if that’s the case try editing the realmlist table in realmd database, and configure it to use your lan ip address instead of the default 127.0.0.1
ok thanks for the changelog info
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
I Was Asking myself about that , i tryed to Do It But i dont find the mangosd window and i dont know where to enter the commands to create an account
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 :
where i type these lines ? in the mangosd window , but where i can poped out this window ? i don’t find where i can start this window …. sorry its very embarrassing but i don’t find where i can pop out these window!!!!! thx for taking of your time to answer me ! very apreciated !
GreekSoul…..
# meza
Your welcome meza :)
# GreekSoul
dont worry about it, beside that’s what this comment form used for :)
and actually you type it in real command prompt window (type cmd at run) and then continue to type the sql query and you’re finished
but you can also use mysql client to do the same thing if you don’t want to type the whole sql command
Can u make me a server i cant do anything, i tried everything but still nothing. if u could make me a server i wouldnt know how to repay you. i am begging u to make me a server and give me the realmlist
make it a funserver, XP X 1000 Money X 1000 drop X 1000
How can we get some TBC action?
i was wondering how to get the latest verson of WoW onto a private server so it can be just me and a couple of friends?
if you already have a private server using the latest version of WoW can you bring it online so other ppl can play? how do u change the xp/item-drop/gold-drop using this method?
Ok thx i found the window … but now im doing the step to create an account ( step 10 in your other guides ) im writing ( -u GreekSoul -p ) press enter now its asking me for a password , i enter the password then press enter but its writing me ERROR 2003 : Can’t connect to MySQL server on ‘ localhost ‘ :S ( i enter MySQL in the environement system path ! ) and still writing me that , so i tryed to create a GM account but still writing the same error after i tryed this commands ( USE `realmd`; ) and tell me that the commands is not recognized like an internal command ect….. ! :S i just need to create a account to play in my server but im stuck at this stage ! if you could help me or tell me another way to create an account so i can play in my server ( i want a GM account ) ( please note i have entered MySQL in System environement path )
your help is very apreciated !
can u make a new guide for dumbi ppl plz lol, i dont understand
Hey there. I can’t install mysql. I went to the services.msc like you said, but i get the error: ERROR 1067, could not start the process locally. Please, any info would be greatly appreciated. Thanks.
# somi
yes its possible to create high rate server like that because all you have to do is just edit the mangosd.conf and set the XP rate from Quest,etc into 10000 or more ;)
but i do not recommend you to set drop rate higher than 10 (i tested it in 1, 5, 10, 100, and 1000) .. both 100 and 1000 drop rate cause problem with quest
# GreekSoul
hm .. if you cant connect to the mysql server on localhost, im sure the mysql service is not started. try start the mysql service first by using below command (type it in run)
net start mysql
if the mysql service cant be started try searching for *.err filetype in your mysql directory and post the log here :)
# carbon
im sure there’s something wrong with your mysql configuration .. maybe you could try posting the error log here, so i can see it ?
to look for the error message, search for a filename *.err in your mysql installation directory and then open it using your favorite text editor (for example notepad)
# Dhaka2
if you could tell me which step you’re stucked at maybe i can tell you how … or if you could give me a suggestion on how to improve this guide further :)
Sure thing, but unfortunately, I’m rather noobish and don’t know how to access my mysql installation directory. Sry bout this, but I’m learning! Thanks again for your patience.
Carbon.
This suck, When i put the AD.exe in my wow installtion dir and create a dir called maps and run AD.exe it’s just poping up errors, and besides that, I cant run those sql files , This is really a bad tut, You dont explain where i shoeld run it or what program i shoeld use, Really bad :S, I want a more understandable tut, Please ?
Hi!
The thing is great, but I can’t get the coding to work. I have all the files, but the code says it doesn’t exist.
Thanks
Ed
im now trying the first step, but it keep saying it cannot find the file specific. but im sure i typed correctly
do u know why?
I’ve got the server up and running. I just need to know how to let my friends connect to it…
Thanks again.
# carbon
You can use the search function (i mean windows search function) to search your harddrive for MySQL :)
# Helimaster
I believe you’re trying to use the ad.exe with WoW TBC client (i’ve received several email asking this too) .. and the answer to that question is ..
if you use TBC client, you’ll need to get the newest ad.exe first (you can find it in mangosproject forum)
as for running the sql files, all you have to do is install the mysql first and then open the command prompt and do the rest .. there’s no other program involved :)
# Ed & pk-kyo
Which file doesnt exist ? i guess you’re trying to execute the sql files … and if that’s the case try switching the current directory first into where the sql files extracted ;)
# Ghost
Ah .. you can read it on my previous comment about creating public wow server
..okie this is suk….im missing creature_template table..in my files…
”
Using configuration file realmd.conf.
MaNGOS realm daemon /0.7-SVN (Win32)
to stop.
Database: 127.0.0.1;3306;mangos;mangos;realmd
Added realm “ReaperX”.
realmd process priority class set to HIGH
”
Is the realmd.exe suppose to stop here?
# cinnam0nr011
That’s correct cinnamon :)
# pk-kyo
ah .. im sure you didnt import the mangos sql files correctly because the creature template is inside there (open that file using your favorite text editor and search for it)
Hey Reaper-X. Thank you very much for taking so much of your time to write these guides, as well as help everybody out who is having difficulties.
Maybe you could help me out. I have everything downloaded, installed, and configured. I start up my server, and I log in successfully. I see my realm come up. I then try to click on my realm and go to the character page, but that does not happen. I just keep getting stuck on the page that shows me the realm I just made. Any suggestions? Thanks so much!!
Yeah, thanks for the guide. I happen to be having trouble with my Mangos server as well. Everything works locally. The problem is getting others to connect (Not LAN) I tried changing the ip from the default to my public IP - Did not work
Thanks
Oh, update (Sorry for double) - I forgot to add that they CAN login successfully, but when they get to the realm selection and try to accept a realm, it takes them right back to the beginning of realm selection again.
I have server working on my current machine, but I cant seem to connect using my other machine. It goes up to the part where you choose your realm and it keeps on asking even though I’ve pressed okay button many times… Do i have to install mysql for both machines or just the one thats hosting it? (having trouble connecting to the server on the other machine) I’ve setup the realmlist.wtf already. (set realmlist My_IP_Adress[192.168.xxx.xxx]). I don’t know what to do at this point, to make the other machine able to connect to my current one thats hosting the thing.
Hey,
I am pretty sure I have done everything required, but when I try log into WoW, IT comes up with:
unable to validate game version….
That was on my regular account I made, on my GM account it says: unable to connect.
I might just start over again? Also, I find that the detailed guide is alot easier to understand than the new one.
When I run mangosd, it gives me the following error
Error in ‘item_template’ table, probably sql file format was updated .
I’m using 0.6.4 SDB, but I figured a more recent version would work aswell… So that may be the problem.
Steve
unable to validate game version….?
make sure your World of Warcraft Client version is version 1.12.1 and Mangos Revision 3459 and Revision 3462 only (4 on required) i think
# Avalanche, Nincb123 & cinnam0nr011
Im sure you guys already changed the IP address set it realmlist table, right ? so other can connect to your server
but if you still havent changed it here what you should do to change your IP address in realmlist table :
note: adjust the MySQL path accordingly
- open command prompt and type below command
- C:\MySQL\Bin\mysql -u root
- Use `realmd`;
- UPDATE `realmlist` SET `name` = ‘The server name‘,
`address` = ‘Change this to use your public IP‘ WHERE `id`=1 LIMIT 1 ;
- quit;
also dont forget to open port 8085 (the default port used) if you’re using firewall
# cinnam0nr011
Do i have to install mysql for both machines or just the one thats hosting it? (having trouble connecting to the server on the other machine) I’ve setup the realmlist.wtf already. (set realmlist My_IP_Adress[192.168.xxx.xxx]). I don’t know what to do at this point, to make the other machine able to connect to my current one thats hosting the thing
No you dont have to setup mysql on client machine, all you have to do is just change the IP address in realmlist.wtf to use the server address used previously (it’s the sql command)
# Nincb123
Were you able connect to your own server locally (not LAN / Internet) ?
# Steve
I am pretty sure I have done everything required, but when I try log into WoW, IT comes up with:
unable to validate game version…
If you get that message, im quite sure that there’s a problem with your WoW installation
I might just start over again? Also, I find that the detailed guide is alot easier to understand than the new one.
Hahaha .. yes .. actually i made this one dedicated to those who’s keep getting sql error message (quick and dirty fix) by uploading database dump
but i think i should make a screenshot too :)
# Carom
When I run mangosd, it gives me the following error
Error in ‘item_template’ table, probably sql file format was updated .
I’m using 0.6.4 SDB, but I figured a more recent version would work aswell… So that may be the problem.
What WoW Version you’re running ? is it 1.12.1 (Classic) or 2.x (Burning Crusade)
Okay… I got the thing running but for lan it looks like they can’t join it (whenever they logon, they go to the realmlist screen) after clicking on the server and the okay button it repeats on going to the realmlist screen.. can you help me?
Hi
i cant do the thing whith
“C:\MySQL\bin\mysql.exe -u root
Steve: check out this site http://www.gamedaily.com/world-of-warcraft/pc/game-downloads/2475/?dl=success
it has all of the patch files you need to get to 1.12.1
This is the same issue I had. Good Luck
I get stuck at the command part where do i extract the files to.. it keeps saying “the system cannot find the file specified.”
# Caseyk
Try adjusting the path to where you installed MySQL
By default (if you didnt change the installation directory path when installing MySQL 5) the mysql bin can be found in :
C:\Program Files\MySQL\MySQL Server 5.0\bin
# Fredd1
Did you get an error message ? and if you did .. what is the error message ? if its the same error like Caseyk … then adjust the path accordingly :)
# cinnam0nr011
Do you have firewall installed ? also were you able to connect to your own server (and play) it using the LAN ip address ?
Yes I was able to play it, it was using the LAN IP Adress, and Yes I do have firewall (AVG Free Edition). I’ve tested with firewall both closed and opened.. oh and
”
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070512 0:34:36 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
070512 0:34:36 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait…
070512 0:34:36 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070512 0:34:36 InnoDB: Started; log sequence number 0 0
070512 0:34:37 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070512 1:07:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070512 1:07:21 InnoDB: Starting shutdown…
070512 1:07:23 InnoDB: Shutdown completed; log sequence number 0 341071
070512 1:07:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070512 1:11:03 InnoDB: Started; log sequence number 0 341071
070512 1:11:03 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070512 14:07:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070512 14:07:58 InnoDB: Starting shutdown…
070512 14:08:02 InnoDB: Shutdown completed; log sequence number 0 973486
070512 14:08:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070512 14:08:09 InnoDB: Started; log sequence number 0 973486
070512 14:08:09 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 1:15:09 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 1:15:09 InnoDB: Starting shutdown…
070513 1:15:12 InnoDB: Shutdown completed; log sequence number 0 1006520
070513 1:15:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 1:15:17 InnoDB: Started; log sequence number 0 1006520
070513 1:15:17 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 2:20:50 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:20:50 InnoDB: Starting shutdown…
070513 2:20:53 InnoDB: Shutdown completed; log sequence number 0 1229756
070513 2:20:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:24:45 InnoDB: Started; log sequence number 0 1229756
070513 2:24:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 2:24:54 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:24:54 InnoDB: Starting shutdown…
070513 2:24:57 InnoDB: Shutdown completed; log sequence number 0 1229756
070513 2:24:57 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:25:01 InnoDB: Started; log sequence number 0 1229756
070513 2:25:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 2:46:49 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 2:46:49 InnoDB: Starting shutdown…
070513 2:46:53 InnoDB: Shutdown completed; log sequence number 0 1229766
070513 2:46:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 2:47:00 InnoDB: Started; log sequence number 0 1229766
070513 2:47:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 3:01:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 3:01:41 InnoDB: Starting shutdown…
070513 3:01:44 InnoDB: Shutdown completed; log sequence number 0 1229776
070513 3:01:44 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 3:01:44 InnoDB: Started; log sequence number 0 1229776
070513 3:01:44 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
070513 15:45:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
070513 15:45:56 InnoDB: Starting shutdown…
070513 15:45:59 InnoDB: Shutdown completed; log sequence number 0 1229786
070513 15:45:59 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
070513 15:46:40 InnoDB: Started; log sequence number 0 1229786
070513 15:46:40 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: ‘5.0.41-community-nt’ socket: ” port: 3306 MySQL Community Edition (GPL)
”
came out of the .err o.0
”
ERROR 1054 (42S22): Unknown column ‘Change this to use your public IP’ in ‘field list’
”
(in this I changed the thing I used to what it was so that it doesn confuse you) this is the outcome of what you told me to do in the command prompt
- open command prompt and type below command
- C:\MySQL\Bin\mysql -u root
- Use `realmd`;
- UPDATE `realmlist` SET `name` = ‘The server name‘,
`address` = ‘Change this to use your public IP‘ WHERE `id`=1 LIMIT 1 ;
- quit;
my bad meant ‘The server name‘ >.> sry bout that
# cinnam0nr011
I didnt see anything wrong with your mysql installation (it seems working fine)
and as for :
ERROR 1054 (42S22): Unknown column ‘Change this to use your public IP’ in ‘field list’
try typing this first like in real example below and see if the column number are same or not :
C:\Documents and Settings\Someone>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.xx
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use `realmd`;
Database changed
mysql> SELECT * FROM `realmlist`;
+—-+—————–+———+——+——+——-+———-+
| id | name | address | port | icon | color | timezone |
+—-+—————–+———+——+——+——-+———-+
| 1 | The server name | 1234567 | 8085 | 1 | 0 | 1 |
+—-+—————–+———+——+——+——-+———-+
1 row in set (0.00 sec)
mysql> quit
Bye
C:\Documents and Settings\Someone>
forgot to tell you this, if you didnt set mysql in environment variable path … adjust the mysql path accordingly :)
btw if you type the update command correctly it’ll show you something like this (btw you must change the ip address into number first because it cant accept string) :
C:\Documents and Settings\Someone>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.xx
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use `realmd`;
Database changed
mysql> UPDATE `realmlist` SET `name` = 'The server name',
-> `address` = 'Set the IP Address here' WHERE `id`=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> quit
Bye
C:\Documents and Settings\Someone>
as an addition, you can copy paste the command from here (i mean this comment) directly, i’ve encoded the special character to make thing easier :)
I was able to set up my server and create a regular account with no problems and logged in and played. The problem now is that I can not make a GM account. I have entered exactly what I was suppose to in the cmd window and when i type USE ‘realmd’; it says data base changed and then I enter in the next set of things but nothing happens. Then when i type quit nothing happens. I’m not sure what I’m doing wrong but I think I’ve done everything like you said. Thanks for your help.
hey when i run the ad.exe it comes up with a C++ runtime error, what does this mean?
yea im a noob at this ( im sure its a great guid ) but i dont get step 2 ….. little help?
me again :P can u add me on msn or email me to melp me out ?
Okay, Thanks for all your help ^^ Appreciated it. This means that my server is all good now. (all thanks to you :D)
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…
# 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 :)
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
sure, just take a look at the about me page ;) i already put my email address there lol
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
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 :)
OK sent it, basicly i just need a step by step word for word tab by tab description of what to do …goodluck lol
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
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?
# 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 ?
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.
# 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
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.
# 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 :)
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?
Ok sorry I was trying to use it with firefox. It works now. :P
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
NM about the SQL. looked around the site and found the freeby download section sry bout tht
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
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
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
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
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?
# 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 :)
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?
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
: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
I need some help.
In the cmd line i type : “C:\MySQL\bin\mysql.exe -u melon
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 ?
can you tell me how to create my own realm
To robert,theres a guide on how to create your own realm at the top of the page
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
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)
hello is there anyone from europe that can help me using mysql for my server please? or can help me via remote assistance
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!!
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?
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.
# 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 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.
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 :(
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?
ok so i typed in mysql, and now it does nothing, it says C:\blah\blah\blah\cmd mysql
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.
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?
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.
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
# 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
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
Ok, I am a complete noob on this, do i need to reinstall WoW and patch it to 1.12.1 or where ever i need to go. I tried from the beginning and im just plain confused. I am new to this. So im begging for pro help. If you get this please help me :) Im not sure where to extract etc, I have TBC installed so im guessing nuke that. and start over.
This is the bit im stuck at:
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
# UKmania
Actually even if you have TBC installed you can run TBC server too, but you’ll need to get newer version of Mangos and the database itself of course (try visiting their page) because the version posted in this page can only be used on wow classic only (and its my database dump)
cant u make an server and an gm account on that server for me? just send an e-mail to me and i send u the name and pass i would like.
should be fun if u could ;)
denniskerstma@hotmail.co&#