Custom Search
MySQL Installation and Configuration – Setting up Private WoW Server
Posted by Reaper-X Jun 27 2007 8:22 pm
This is the first part of the Creating your own World of Warcraft Server using Mangos
- The First part is all about Installing and Configuring MySQL on your Windows Machine
- The Second part is about Configuring the WoW Mangos itself
- The Third part is all about Setting up Private WOW Server for Lan Party
- The Fourth part is all about Installing and Setting up Apache Webserver with PHP
Since i’m still getting lots of email asking me on how to set up a private wow server using mangos and including from the comments i received on my previous guide and that’s including here. I’ve decided that it’s best for me to explain it again but this time i’m going to use image instead of text only (previously someone ask me to write guide using images so here goes the guide) btw i had to set up virtual machine just to wrote this guide lol
Also i’d like to say many thanks to all the site visitors and to all who leave comments on this site especially at my wow mangos guide because your suggestion helps me to make this site better
Note : Since there are lots of images used, i think it’s better if i split this guide in two part. And at this part, i’m going to tell you how to install and configure mysql
As a sidenote, you can also use mysql for many things as well instead of just as WoW Private Server only. This means this is a general purpose mysql installation
Okay without further ado, let’s start the guide :
Requirement :
At the time i wrote this, the latest stable mysql version is MySQL 5 Community Edition
And don’t forget to download the 40 MB MySQL (Full MySQL) instead of the small version ;)
Installing MySQL :
After you’ve downloaded and saved the MySQL Setup into your harddrive, run it and choose Custom Installation and continue until this part and adjust it according to image below
And choose to install it
Feel free to register with mysql.com although it does not have anything to do with your mysql installation. I put this, because some people think they need to register with MySQL.com first in order to use mysql program on their computer
After finished with the previous step, choose to configure mysql now (it’ll automaticaly run the mysql server instance config wizard)
That’s it for the installation process, now we need to configure it
Configuring MySQL :
If at the previous step you choose to configure it now, you’ll get below screen … or if you did not choose to configure it now, you can run it using the mysql server instance config wizard shortcut from the start menu
and then
and then choose the Multifunctional Database
And now you need to set up a directory where the InnoDB data shgould be saved (it’ll be created automatically if the directory does not exist so you do not have to worry about creating it first)
In this example the InnoDB directory located at C:\Mysql InnoDB Datafiles
As for the next step, you can adjust maximum concurrent connection depend on your need but most of the time you do not need to set the value to high unless you’re planning on creating public server and you have busy server (if you do this you already violated Mangos Terms of Use)
As for the next step you need to configure on what port should mysql listen to incoming connection (default is port 3306) and it’d be better if you do not change it (you do not need to worry about security because by default root account can only be accessed from local machine or in the other words from your own computer)
Now you need to configure the default charset mysql should use. In this example i’m using UTF8
This is the most important steps because if you forget to check the Include BIN Directory in PATH you need to start all over the mysql configuration process again (or you can edit your windows environment variable manually)
Btw this is one of the many problems many people had before (to those who’s allowed me to connect to their computer via remote assistance know this) … it is the Command Not found / Not Recognized error message from the command prompt ;)
Now here goes another important part, the root password. And you need to remember it or else you will need to reset your mysql root password. Also keep the enable root access from remote machines unchecked as security purpose
Note : This is different that mysql.com account if you decided to register with them or already registered with them
Now you just need to continue and let the instance config wizard do the rest for you and you’ve finished installing mysql on your computer :D
And now we need to make sure MySQL already running and can be accessed directly from the command prompt … so open the command prompt by typing CMD in the run command
- Start Menu
- Run
- type CMD
or
- Start Menu
- Accessories
- Command Prompt
and then type like below image (when prompted for password, type your root password)
If you can type the above command without problem, this means you just configured mysql to work properly on your computer … congrats :D
as for the next part, i’m going to write about Configuring the Mangos itself … stay tune :)
Note : This is a quick and dirty installation, i didn’t write about mysql query cache and any other optimization related configuration. So you’ll need to play around with it by yourself :)
Trackbacks/Pingbacks
Leave a response
Connect with me
Thank you man! This tutorial is awsome, i really appreciated that.
Hi @ all!! This question may seem a bit strange, but when “MySQL Server Instance Configuration Wizard” ask for the root password, i donno what to type in? Which password is it i have to enter? Or, where can i find it?
OK so I got my server running and I can login on the same computer as the server. But when I try to login in from another computer on my network it goes to logging into the server. Then it just loops back to the realm list
My client version is 2.1.3 (6898)…and the mangos version is unknown.
Help would be greatly appreciated.
~TBSKira~
# Neo
Unfortunately i haven’t tried using Vista yet :( … so i can’t give anymore info about it
# Kris
Just in case you didn’t notice, i just posted my own compiled mangos, for more info just click here
can any1 tell me where i download mangos from?
If i do PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin
it says:
Too many parameters.
if i do mysql -u root -p then still same error.
I checked system variables and Path is there.
Any more ideas?
I got Vista
I assume that you’re installing mysql to it’s default path
now just you need to type this from the command prompt
PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin
and then type mysql -u root -p
NOTE : The above is just a temporary solution which mean you’ll need to retype PATH whenever you close the command prompt window
To make it permanent, use below instruction
and to make sure mysql already written the BIN path into your windows directory
open System Properties, then go to advanced tab, open the Environment Variables and look under your system Variables for :
PATH
and then see if mysql bin directory is listed there
If it’s not there, add the mysql bin directory manually
I dont know why i got that recognize error im 100000% sure i checked Include BIN Directory in PATH.
I configured again and checked it.
still the recognize error
I am getting the 1045 error but when I cmd prompt it and put in the password I installed it with it works ie. mysql -u root -p gives me the prompt for password I use my password and all works but the end of the install still gives the error.
Yes i get an error then.
MYSQL am not recognized as an internal or external task, program or batchbestand
I translated it with a program maybe some words are not rlly good( im not english )
is it also normal in mangos everything closes instantly after i pressed.
and the other buttons al go to a non existing website?
# Neo
Did you receive any error message when typing mysql -u root -p ?
and by default mangos is going to make a beep noise when launched, but if you don’t like it you can change the mangosd.conf (configuration file) so it doesn’t make a loud beep noise when started
since if i press start apache & SQL on MaNGOS
i get a loud beep noise and the window closes
But in command prompt
if i type
mysql -u root -p nothing happens
cant enter my pass..
Is it working or not?
You rock!
THANX!
Deleted all
Process closed
Deleted Amrican93 repack(to make priv server but never worked for me)
Installing
Configuring
Setting Password (i wont forget i use it for everything)
Executing…
YES
It works
never been so far now..
Thanx Reaper u rock!
to make thing easier, uninstall and then delete your mysql installation directory (default location can be found at)
C:\program files\mysql
and then reinstall mysql again
also if you previosly had mysql installed from any other program (if you’re using WoW Repack from somewhere that includes everything), make sure that mysql process is not running
you can check if the mysql process is running or not by looking for mysqld process via task manager
Only thing i can do is retry or skip >.>
Error 1045 / Access Denied message mean (in your case), you’re not supplying the correct password for the root username
to fix it … simply use the correct password for the root username
the default password for root (if you haven’t changed it) is blank … or in other words without any password
what the fak
how much errors you can get
now i got 1045 error
acces denied for user ‘root@localhost
i already did everything with port 3306
pls what to do now ?
I cant believe it.. again i only get that dam lil blue box!
It works now, thanks to ur link above guess i wasnt downloadign good one ;S
hey,
when i open Server instance config i get a lil blue screen and then nothing happens ?
whats wrong?
Direct Link to mysql 5.0.45 win32 version :)
click here
I can’t even find a MySQL to dl! I found one for a mac computer but nothing else. Did they stop hosting it? If they did is it possible still to get ahold of it for free?
# Pool
Argh, It was all going so well until i got into the game. I was unable to create a character due to SQL ERROR: Unknown column ‘pending_honor’ in field list
it seems that you’re using patched mangos that is using honor system, to fix it you need to execute the sql file included with that release
# Goblisleez
just in case you want to import the scriptdev2 sql file, you can type this at the command prompt
mysql -u root -p -D mangos < scriptdev2.sql
and if you take a look inside the scriptdev2.sql file, actually it’s just updating the creature_template table to make the monster cast spells
Well .. after a few hours of playin around in the mangos database .. i discovered that a small amount of creatures do cast spells. Seems that most creatures in the database do not have a script attactched to them.
Heres what i did …
Charlga Razorflank eg : had no script or spell casting caps enabled (which we know is rediculous as in the real version he does cast things).
I added the line “generic_creature” to scripts (as other creatures that do cast have this script) and aded 2 spells into spell1 and spell2 (spells were of my choice). Whoila .. Razorflank now casts spells.
Im just curious .. is there a way to find more scripts .. seems it would take a millenium to hand edit the whole damn database O.o …
Anyways , just wanted to say once more … great article Reaper .. helped alot … and if u do know of anything about these scripts .. would be appreciated.
TY :D
As far as gettin stuck at the Service Started status …. i had this happen once .. i just uninstalled MySQL and manually removed all left over traces from the program files dir… as well as the InnoDB folder … delete it all and freshly install it. Worked for me. Just make sure you uninstall and remove every last left over peice of data from yer machine.
Ok , well i have studied a bit on this thing called ScriptDev and i have the sql files … i am not sure i understand how to import them into the exsisting mangos database … the only option i see is to restore from SQL … i have done this and it seemed to affect nothing … maybe it has added speech abilities to the silvermoon guards … but otherwise , not one mob casts any spells .. no boss’s either … i dont understand. Any ideas?
Yo reaper , awesome stuff here … one thing … Have you heard about anything or way to initiate a mob AI to the data …. cause i have tried about 5 different DB’s and not one of them has workin spell casting mobs…. all mobs in all DB’s i have tried just physically attack. Im searchin around right now … but if u know of anything , be appreciated m8.
Argh, It was all going so well until i got into the game. I was unable to create a character due to SQL ERROR: Unknown column ‘pending_honor’ in ‘field list’
Any suggestions?
I pressed execute and its currently stuck on “Start Serivice” please can i get some assistance?
Hello. Well i downloaded the MySQL, but now im currently stuck at “Start Service” its not going farther then that. The buttons are greyed out also, idk what to do!
Actually you can install any version that fit you best (or any version that is available for download from mysql website) :)
as a side note, i’ve tested mangos with MySQL 4.1.x , and mysql 5.0.xx without problem
OK Im just wondering what would happen if i get a higher version of MySQL?
Here’s the Solution for mysql service problem
I got “Cannot create Windows service for MySQL. Error:0″ which stopes at “Start service” like everyone else. E-mail me at meintein@earthlink.net with details on how to fix this ASAP.
help,, iit always stops at the 3rd spot and says error 0,, help plz
When I execute it always stops at Start Service and
says cannot create windows service for MySQL. error:0
i tried to uninstall the Program but it doesn’t help
please some1 can help me?
Coming from a previous post on the older guide in which Reaper-X asked me if I had the realm loop problem…
This post should go here, as I followed this guide.
I’m not sure what the realm loop problem is exactly…because it connects to the realm and sits there and displays the message “Retrieving Character List” and gives me the cancel option. It just sits there.
I followed your guide to the letter with no problems and I know my version of mangos is compatible because I checked that before I started the installation (Revision 4344 which is supposed to be able to run TBC 2.1.3 which is what I have installed). I also got the correct SDB files from the link you provided.
hey when i try to do the command promp thing it says it’s not recognized
you just need to run the mysql server instance config wizard and don’t forget to add mysql bin directory to windows path when asked :)
btw do u need mySql to run ur own private server?
of course :) because that’s where your character data, game database (weapon, warp, etc), and your realm information stored
when i go to enter my password it makes a loud beep noise and says its wrong! i already got a account, help?
loud beep noise ? from mysql or from mangos window ?
Ok got it all up and running. It’s working well although the following bugs I was wondering if anyone could help me with:
1) Can’t use any of the chat channels at all and nothing is displayed in the chat windown when I type something.
2) XP bar missing.
3) Most importantly my cash is set to 0 copper and no matter what cash I add or stuff I sell I do not receive the money.
4) Grsphical glitches like some models are hold little blue and white boxes.
I hope you can assist in this as right now I possess 5/5 Dual Wield Specialisation but unfortunately my whole skill page is empty, which means I cannot dual wield at all, despite specialising in it. Wierd huh? Help peoples!!
from your description, it seems that the mangos you’re using is not compatible with your WoW installation. I can only suggest you to get another mangos revision (preferably newer release, or the latest one that is compatible with the full SDB you’re going to use)
as a note, if you look at my previous wow mangos screenshot, you’ll see that im using Dual Weapon (i think the weapon name is DeathBringer or something, IIRC) because im just guessing weapon name lol
and im not experiencing chat, or money issue as you described even with the old mangos revision (3462) for wow classic only
uh and i tried doing it in command prompt, i enter he password and it still gives the erro, btw i already have mangos downloaded and my server is up and runnin g, i am just using mysql to get my friends online
uh, error 1045, i dont even have a firewall, i dunno what is up
i seem to be having the same problem as most people regarding the startup services but i have yet to see a fix on here….here is the error i get…
InnoDB: Error: log file .\ib_logfile0 is of different size 0 177209344 bytes
InnoDB: than specified in the .cnf file 0 25165824 bytes!
070826 16:50:16 [ERROR] Default storage engine (InnoDB) is not available
070826 16:50:16 [ERROR] Aborting
…i would love to get past this error so i can run into another one
that error message means, the InnoDB Storage / Logsize has different size compared to the specified value in your my.cnf
the easiest way to fix it, delete the ib_logfile0,ib_logfile1,etc from your mysql data directory and restart the mysql service to force mysql to recreate the data again
or you can also choose to disable InnoDB completely if you aren’t going to use it by :
1. adding skip-innodb into your my.cnf
2. comment (#) all innodb configuration in your my.cnf
3. restart mysql
Hey, I followed all the steps before and it work. So i switched computers on my LAN becuase this one ran better. Now when i follow the steps I get to the Execute part of the Instance Configure Wizard and it gets to the Apply Security Settings and it give me this message:
Error Nr. 2003
Can’t connect to MySQL server on “localhost” (10061)
I opened the port and everything but it just wont work. Please help me
kylemcbr@gmial.com
Have you tried checking the process list (Task Manager -> Process List) and see if the mysqld process is listed there ?
Im sorry to make this question. Maybe you already said somewhere but i dont see it…
If i’m going to do the classic wow server… i need to install wow without patchs? or up to what patch?
same with TBC server, till what patch?
Im so sorry but i dont have a idea :(
hmm when i klick execute nothing happend and the program aint answer what shall i do!?