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
I deleted ALL of my older Mango’s, the problem still remains =/
My first attempt was with MySQL but i had this problem: Cannot create Windows service forMySQL. Error: 0
That’s why I tried with other programs :S
Im really sorry for late reply, because i’ve been sick for the past 4 days and just fully recovered today :D
# LnNF
You can kill the mysql process manually via the task manager for the first step
but the next step would be different, and that’s depend on whether the mysql that is previously included in your mangos distribution install / create the mysql service or not
but in most case, deleting the previous mysql directory completely should do the job :)
# Zac
I’d suggest you to uninstall mysql first, and then delete everything from C:\program files\mysql
and then proceed with fresh install :)
# Bongo
since i never tried mysql bundled with any other program, i can’t really give you a solution for that
i’d suggest you to install mysql manually (beside it’ll be a lot easier for anything in the future if you have mysql installed manually) :)
please tell how you did it:((
Reaper, at least now answer me pls :) One my friend gave me VertrigoServ and SQLyog to use it for mangos… there weren’t problems anywhere… But at the end when i try to login and write username and password the connection stop at “Success!” and after that it appears Realm List… I clik OK and after 2 seconds same thing and so on and so on… I disabled my anti-virus software and firewall but no difference… Where is the problem :S Can u advise me something pls :S
Woops its Error 1130
Hey Reaper
Im stumped, I get the Error 1045 Host cant connect. I go into cmd, and when I put in my pass it just gives me an error 1045 aswell.
Im going insane!
Any help will be appreaciated!
Yeah I have the same problem with the error:0 thing, how do I remove the sql from the 3306 port its using, I suppose it’s caused from the older mangos I used?? How to get that out the way to make way for this new MySQL? Thanks.
When the server is working I can work with every other program write? It will not block any other access to the computer’s other programs?
I have a simple question. I know it may sound stupid, but I don’t understand when I install and make the server, is my computer going to function in any other way? I mean is this server going to be like all the other programs? Еverything else will be operational write?
ok not sure when things stopped working but have to back peddle a bit as the mysql is no longer in task manager maybe it never was perhaps I was mistaken but anyhows I whent through followed all steps up to the importer did that and when I got to the 2 mongos files got a error tracked it down to the mysql wich when I try to start is now giving me a error
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: ********
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
I shut down all software firwalls and made sure to allow the port on my router just as a added step am probly doing something small wrong but would love if you would help me with it. also my e-mail addy is stargazer_dragon@yahoo.com in case you want to e-mail me the help instead and thanks a lot
I’m still having the error:0 problem, I’ve looked at all the posts and tryed the deleting the service thing, but everything I try fails.
you’ll need to use dyndns service so you don’t need to change your ip address everytime :)
look at this page for more info
Do you think i’ll need a soft for kepping my ip unchanged? can other users connect to my realm if i setup it in the MaNGOS server?
This is my status for today
http://picasaweb.google.ru/alex.chitan/WOWSERVERPICS/photo?authkey=ikiuCF9Rj9k#5123080453883452450
Thank you reaperx but my second ip is changing evry time i logon the net. i have a PPPoE connection.what i’ve got to do? and please specify my second ip address:) bye bye
# Alex
Actually its because back then mangos still doesn’t fully support 2.2.3 client :) … but you don’t need to worry i’ll release an update for that soon ;)
as for your ip address, you just need to use your second ip address from your screenshot :)
http://picasaweb.google.ru/alex.chitan/WOWSERVERPICS/photo?authkey=ikiuCF9Rj9k#5122616099199278098
in here u have my “ipconfig”
bug in game…when i teleport to orgrimmar i make few steps a the game teleports me to azshara, what’s going on?Please tell me about this bug…
Reaper-X i’ve install your version 4602…it’s very cool…tell me please can i start the server without game instaled on my computer…this ver. of MaNGOS from russian site is to old, i can’t paly with ver. 2.2.3 on it, but i’ve install your ver. and i enjoy it:))).tell me please something elese how can someone eslse from internet connect to my game, now i play from localhost. thanx Reaper u do a great job!!!:)bye bye
# Alex
haha .. i guess that you didn’t see my new post about mangos 4602 with UDB (my previous release use silvermoon db rev 18) ;)
and this guide is just to install the mysql (which is obviously needed for mangos), because some people prefer to use an easy way of installing mangos, i included my batch file since 45xx release so you don’t need to type any sql command anymore :)
sorry you’ll need to download this
“Mangos WoW ServeR 2.1.3 ManGOS 4471 Silvermoon 17 Скачать Filebeam.com”
Reaper-X i think you’ll understand it without konw language…its very easy, look at this link and make a tutorial to this prapared MaNGOS server…so that someone else to understand.
if someone will download this ver. and have questions my yahoo ID:alex_kitsan2004
PS:When u need to do something, make it ease way
Bye Bye all :)))))
Man finaly found what i had look’n for…alrady setup server from russia mother:) i recomand how knows russian language http://mangos.ru/showthread.php?t=8156
it’s very clearly….bye bye all
i do everithing what i must to do whit error 0 i deleted old servers and and… but stil doesnt work
Hi reaper
i reinstalled my Computer but i wanna make my server again bet he gives all the time error 0 when i do execute plz help!
greetings
Reaper, like others I have same problem but nowhere i didn’s see a solution. I made all steps, you said, and i tried to fix the problem in all ways u said… no difference… Pls answer me and here is all information i have:
1. Like others: Cannot create Windows service forMySQL. Error: 0
2. As u said for .err file it writes:
071016 15:18:14 InnoDB: Error: unable to create temporary file; errno: 22
071016 15:18:14 [ERROR] Default storage engine (InnoDB) is not available
071016 15:18:14 [ERROR] Aborting
This appears in “Start service” installation and there is no change after doing what u said as a solution in windows registries… Same problem after all, same problem for all triers :(
# Alex
Don’t worry ;) .. as for your question, actually you just need to have mysql installed and working, and don’t forget to get my latest 4602 :)
ok if it’s so give me please all 4 ingredients…for doing this s***t server on my mail…please dont’n be upset on me, lasta night i did’t sleep becose, i can’t instal this s***t server. thank u again…i’m really sry.
# problem
Ah .. unfortunately it’s not related to mysql :) .. try re-extracting the vmaps once again from start (delete the buildings and vmaps directory first)
# Jim
Did you use your administrator account when installing mysql ? or other username with admin privilege ?
# Alex
actually i put the correct link to the official mysql site directly instead of the direct link to the file (it’s under the community area) :)
i’m very pisedoff, man fuck this private server…here is somthing else fuck him again…bye all.
PS:have fun in your private server, next time try to be more professional.
I think this will help others http://www.soft32.com/Download/Free/MySQL_Windows_Server/4-972-1.html
Mr.Fix it, let me tell u somthing…u put on this site bad download link of mysql…try do it better next time thank you. sorry for my corection.
I keep getting stuck at “Start service” and it always says “Cannot create Windows service for MySQL. Error: 0″… Help?
ok. when i am installing (using 5.1) , it says error 2003. the security could not be applied to the database because the connection has failed. cannot connect to MySQL server on “localhost” (10061)
I have my firewall off and i even put port 3306 as an exception. Retrying is not working :’(. I had done this before, then I removed it using remove programs and am trying again.
Hey i have a problem. I want to create wow tbc 2.2.2 server. I am by step where i must copy vmaps,maps and dbc. I copied all of these folders in a new folder. Than i opened mangosd conf. to changed datadir to my direction. I started the mangosd, and it showed me an error: file missing /maps/0004331.map i looked in the folder maps and there was that 0004331.map. But the mangosd showes me still the error. I reinstalled wow and i copyed vmaps and maps once more time but the there was still that error!!!:,( PLs help me
# HELP
Could you tell me which command prompt is not working for you ?
# shaderade
aah … you’ll need winrar (shareware) to extract it … or you can use 7-zip (freeware and opensource) to extract it ;)
http://www.7-zip.org
lol i feel like a spammer but forget the first 2 posts i made im sure its fine, but you closed the post on next page and ur instructions arnt makin any sesne, im tryin to make a clasic wow server not tbc and i followed you links for magnos but when downloaded they’re a .rar file not zip i cant extract anything?
ok ok ok i think i got it but heres the thing… if i go to command promt(the comps command promt) and do wut u said it dont work. but if i go mysql’s command promt it just asks for my password and when i type it in, it all works. is that right?
OMG IVE DONE THIS OVER AND OVER LIKE 10 TIMES AND NO MATTER WUT I DO OR CHANGE IT JUST KEEP SAYING ERROR 1045 ACESS DENIED FOR USER ‘ODB’@LOCAL HOST USIN PASSOWRD NO! WTF IS WRONG LOL please let me know man this is fustrating and ive already ripped my pillow cover 2ce
plz help me, when you start the command line client you do youre password then it starts. but the CMD code isnt working so whats the problem plz tell!!
# Matt C
you’ll need to use the correct password for root which is asked when installing mysql :)
to make thing easier, uninstall mysql first, and then delete all mysql directory in program files
and then reinstall it again
# Micah
If it’s for me, if i want to write something related to guide, of course i have to be prepared to answer various questions asked by the site visitors :)
Unless i missed your question of course because i didn’t see it (if there’re to many questions asked in a single day) ;)
# kris
No you need mangos and mysql both, because mangos look for the items, data, and such stuff (including your login) in the mysql database :)
# Elliott
Are you planning on running the mangos process from your computer and stored the database elsewhere (in your case the byethost) ?
Because it’s not possible to run the mangos process from a web hosting with mysql support
you’ll need a dedicated server to run process that requires high memory usage (just like i said before)
if you’re sure you want to store the mysql database over at the byethost (which i dont recommend) you need to know what kind of server byethost offers to you ;)
is it Linux server ? and if its a linux server do you have a shell access / ssh access ?
or is it a CPanel server ? Plesk, etc ?
and so on :)
Note : you’ll need to give some more info about your server setup first (like the Operating System,etc) so i can help you :)
# Ashley
Which mysql version you’ve downloaded ? did you get the 40 MB version for windows or the smaller version ? if you’ve downloaded 40 MB version then mysql server instance config wizard already included in the package (tested) but if you’re using the smaller version, i can’t really talk to much about it since i havent tried using the small version :)
# Baah
From the looks of that error message, it seems that you’re not using the correct password for root (unless it says that mysql service can’t be started)
to check whether mysql service already started or not
open task manager -> process list -> and see if mysql process is listed there :)
Lo,i got my wow server running but when i came home today my mysql doesnt start,i tried strat mysql, but it says ERROR 1405 (28000) : Access denined for user root@loaclhost (using password : Yes )in command prompt.Can you help me?
My problem with this is that in the Custom Installation Menu, I have no “MySQL Instance Manager” in the list.
Any way to fix that?
how do u configure mysql or what do u import.. like http://www.bytehost.com will host my server free but what do i import? what mysql file??
ok i read the one guys comment… so u dont need mysql to run the server on ur own… i just want to play by my self… just want to practic some GM commands… so i just need mangos??
i cant get past start server and iv done it just as u have… can u help me?
Kris
Hey Reaper havent tryed this yet but looks good =D great job haha! specialy with actualy answer questions most people make a guide and leave it like it is =/
I’ve gone through all the steps and tried all the troubleshooting suggested in the comments. I get to the very last step, accessing mysql from the command prompt. I typed in mysql -u -root -p and hit enter. I was prompted for my password so I entered my password and hit enter. I get the following error:
ERROR 1045 : access denied for user ‘-root’@'localhost’
is this a problem and if so, how can I fix it?
# Hellboy
Asked for previous password ? well that mean you need to use your previously registered password for your root account
# Bernardo
Your welcome Bernardo, glad you like it :)