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
ugh this one
# CoolZero
could you tell me what is the error message ? (look at the .err file inside your mysql directory) :)
# Cody
it seems that your message was cut off .. could you repost it again ?
# Magnesium
Do you mean my previous old wow mangos installation guide (before creating my own repack) ? or the recent one (i’d appreciate any input) :)
UCD and TCP – sorry, my mistage again…
no windows path needed on Vista* – made a typo
now,well i pressed the wrong button:
so, install MySQL, and one thing more: UNINSTALL EVERY PACKAGE OR SQL EDIOR B4 INSTALLING MYSQL!!!!!!
sir.mihkel@hot.ee 4 problems, ima crazy man with a crazy talk…
Ugh, Reaper, mby you should change the whole guide:
h t t p : / / w w w . g a m e r z p l a n e t . n e t / f o r u m s /wow-emu/213482-help-how-make-your-own-server-how-make-public-add-items-etc.html That works, BUT INSTALL MYSQL BY REAPERS WAY(but now windows path needed on vista…)
Well, yeah, um i kinda have a problem –
Im useing Ascent install, and that has worked the best yet( i have got into the game, others logged in) BUT here’s the story:
1st- i got error of: Error 0(opened ports) – FIXED
2nd- ive got an error of 2003 – cant connect (10061) I have taken down( yes forgot : runnin’ on Vista Home Basic.) windows firewall and bitdefender v10 but i reallly cant connect. + there are no processes of MySQL or services exept of the conf. wizard. i hope you understand.
1 mroe thing: create both ports: UDP and TDP ;) shee ya
guh(im Not the other aaron) but It says it cant find 001_33_39.vmdir when i start mangosd yet i can find the file easily! help!,
this might help: the same error as someone else .while running the mangosd.exe.
it couldnt find me the “001_33_39.vmdir” file
I checked and the file is in the right place
It s Hard to create your own serve!!!!:(
Hey, having a little trouble i cant get my command
propt to look like yours it just wont let me, instead of it saying C:\Documents and Settings\beta>mysql it says C:\Documents and Settings\jeff….PLZ HELP ME REAPER!:)
hey please help me with instalation i do all and come to excute it stop on start sevice please help me
Hey just wanted to say thanks. You helped me get it running :). Deleting those folders helped me out a lot. Now for the next step.
i’m also getting the error 1045
access denied for ‘root’@’localhost’ (using password:YES)
i’ve made the port 3306 an exception on my firewall and even tried turning off the firewall, but it still comes up with the same thing
each time im checking if i did it right on cmd is saying : ERROR 1045 access denied what to do?
hey i get in the .err file and says
071213 22:17:14 [ERROR] Default storage engine (InnoDB) is not available
071213 22:17:14 [ERROR] Aborting
071213 22:17:14 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
uummmm, can u assist me everytime i download it it never takes me to that screen it always comes up with modify repair or remove, never the custon download, please assist. Am i not downloading the right thing or what? plese respond
After all the setup, i get this error:
The security settings could not be applied to the database becouse the connection has dailed with the following error.
Error Nr. 2003
Can’t connect to MySQL server on ‘localhost’ (10061)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no cient application can connect to the server after you have opened the port please press [Retry] to apply security settings.
If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.
I turned off my “Firewall” and my antivirus software (Kaspersky Internet Security) which has his own firewall. I cheked ports for both firewalls, and they were open (but im not totaly sure) I tryed uninstall it, and delete the folder. I reinstalled and used my password from last istallation. Btw this isint my first time installing this program. I think from last istallations, the port 3306 is still in use but i have no idea where it could be.
I BEG YOU! HELP ME REAPER!
ppl with error 0 !!
scroll up, reaper already solved that problem
(lol)
Please help, I’m getting error 0 windows service thing… >_>
I don’t know how to fix it…
reif.larsen@gmail.com
getting it to work on vista isn’t that differnt, CMD was where it changed for me.
I’m sorry to err triple post, but I believe smething might be wrong w/ my MySQL I’ve tried everything that I’ve seen it gets to teh execute page and has 2 checks then appears and X and it says Could not start the service MySQL. Error: O and everything else works including mangosd.exe and realmmd.exe If you have any ideas about what to do please tell me I have reinstalled about 3-4 times ><
MySQL will not start service*
MyDQL will not start the service for some reason any ideas why?
xenon are you typing in the whole command? including the mysql
Ok i got the configuration to work now, but when i go to the cmd it says
“‘-u’ is not recognized as an internal or external command, operable program or batch file.”
Please help me
When i was at the last part of the configuration i got this error:
“The security settings could not be applied.
Error Number 2003.
Can’t connect to MySQL server on ‘localhost’(10061)”
What do i do to fix this?
I’ve a problem… When i install the MySQL, in the custom install there are only MySQL Server (required 22mb), client programs (28kb) and include files/lib files “deactivated”. Where’s “MySQL Install Manager”?
Thx you
Ok thanks for your help.Fixed my own problem :)
I ve installed mysql but when i run it, it doesnt apper the image u pposted above, i try to write commands, but they doesnt work
Hey, I’m experiencing difficulties with my mysql i can’t get the program to connect to the port(3306). first i made an exception, didn’t work, closed the firewall down, not working. what did i do wrong and how do i fix it
thx,
btw great guide
Restoring.Thanks
# Chris
Could you restart the mysql service by typing :
net stop mysql
net start mysql
from the command prompt ? and see if you got any error message or not
# Jeff
No, root password is actually typed when you install mysql to your computer not from other website
btw could you try restarting the mysql service ?
# Edward
it seems that you’re using my mangos mod, btw are doing fresh installation or restoring / upgrading from old version ?
Because if you choose to fresh install, you won’t be seeing that message since the mangosmod username automatically created in the installation process
Hi Great Reaper-X your tutorial is awesome,but I met a problem.
Everything is fine except the last step where you launch magosd.exe and realmd.exe.
I get “Could not connect to MySQL database at 127.0.0.1: Acess Denied for user ‘mangosmod’@'localhost’ (using password: YES)for realmd.exe and the configuration for the bin works.
Do you put anything in for the Root password on the last step? i followed the steps above but i keep getting the Error: 0. Do i need to sign up on another website to get the root pass or somthing?
hey, love the work btw..
worked fine for a day, had massive lags every hour or 2 that lasted around 10 mins…
during one of these, i kinda switched the pc off by the socket.. got it mixed up with the other socket.. >.<
and now when i try to run again, nothing works, i tried command prompt..
mysql -u root -p
then enter password, and…
lost connection to mysql server at ‘reading initial communication packet’ system error: 2
woops, shoulda read ahead. Nvm. >.<
Hey, when i was trying to download MySQL, i got all the way to the part where you hit “execute” and then it does its Processing Config. It goes through those 4 check points, but mine Reads (The Service could not be started. Error:0) and wont let me complete it. If anyone has an idea, thanks.
SO i have windows Vista and im not sure if this program will even work with windows vista… in other words i got to the point to where u have to type in the comand prompt and i cant seem to get it.
Whoa .. calm down ;) you know that i’m the only person that manage this site, and if there is a lot of question asked simultaneously … there’s 99% chance i will miss that question :)
btw to those who’s experiencing mysql error 0 try doing this :
1. Make sure there’s no mysql process in task manager process list tab (if you use repack that include mysql)
2. If you still have mysql installed, try running the server instance config wizard and choose to REMOVE THE INSTANCE
3. Now exit from server instance config wizard, and then go into add/remove program and uninstall MySQL
4. Now delete everything from the previous mysql installation directory (default C:\program files\mysql)
5. Reinstall mysql once again
To those who has uninstalled MySQL and still getting the same mysql error 0 message :
1. open command prompt and type like below :
services.msc
and it’ll open another window, and see if there’s mysql service listed there and Make note of that service name (the default service name is MySQL)
2. Now close the services window
3. at the command prompt type :
sc delete MySQL
or adjust the mysql service name as shown previously
and then make sure that the mysql service has been deleted, if it’s not you’ll need to restart your computer
4. Uninstall MySQL via add remove program
5. Delete everything from your mysql installation directory
6. reinstall mysql
that’s it :)
reaper u ***hole why cant u just tell us how to fix that fuckin error 0 thing ?!
Alex, welcome to the club :D
Its not only you, we are not the only… Its a mass problem but nowhere i can find answer… :)
nvm lol
Oki know ill sound like a looser but anyways i cant get mySQL started, it’s downloaded but but i cant run it like it says in the guild so can you help me to fidn where to go
071030 14:02:40 InnoDB: Operating system error number 123 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File name C:\C:\Mysql InnoDB Datafiles\ibdata1
InnoDB: File operation call: ‘create’.
InnoDB: Cannot continue operation.
i just dont get a thing can someone plz explane me how to get pass start service if i have error:0
What I did last time was when I deleted the folder, I didn’t remove it first. Opened the Task Manager and ended the process of mysql-nt, if it’s not there don’t worry about it. I had my port opened previously and I removed MySQL with add/remove programs and THEN deleted the folder of MySQL and the InnoDB, and installed it freshly and it worked.
hey , how did u fix your problem caus i got same problem and cant fix it
I checked out what your answers to all the others said with error 0; error 1045 but nothing has helped,, Should add our problems into your tutorial its piSSSing me off =[
Man i got no hope of ever doing this,, I get through error 0; then comes up with the error 1045.. Do help
Woot I got it!!! xD hellz yay
I got by the error: 0 thing, I didn’t know I had to specify the InnoDB everytime :P I ran through the config again, but now I’m stuck on the error: 1045 about a port thing n firewalls, I’ve tried putting my firewall down and opening the port (I think I opened it right??) but it still does the same 1045 error’zorz >.<