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
hi reaper,
got a dumb question
i went to install the mysql version 5.0
and as i get to the finish part with the tick button “configure mysql now” i have that ticked click ‘finish’ button but nothing happens, and it doesnt create a .err file or any log file,
give us a reasonable reason why this may be hapening,
thanks dude
Hi Reaper-x Can you please send me the more detailed tutorial on how to make an ofline server Becuase i cant seem to get anything right Please send it as fast as posible. Email at evo284@gmail.com
I started all over again this morning, brand new WoW, Mysql and mangos. I ran through all the stuff and I cant figure this out. Still getting error 1045. I have no firewall or anything like that.
But as a side note I could get Mysql to work without a password but i still got the same error message.
Somebody help me please, im pulling my hair out over this ;_;
Still getting error 1045, can anybody help out with this, i’ve been looking ALL DAY for some sort of answer.
I was really looking forward to getting this WoW server software running. It’s too bad it f***’in requires MySQL – it has issues with Vista, PERIOD. After spending a few hours just looking at workarounds to get MySQL -CONFIGURED-, I don’t even want to know about the hassles I’ll run into after it’s running. All this, to do something that WoWEMU has done without a database service?? I’m done with it. Looking elsewhere…
I have the same problem as Totally Stucked except my error 1045 and i cant fix it i think mysql is just retareded
I really need help too
I have the same problem
now if i try to configure the mysql, it doesnt even let me do that. i cant run the server instance config wizard.
Ok im installing MySQL 5.0. when its applying the security settings, i get error 1045. i have no idea what to do.
How did you fix this problem?
i have the same eror massege
Odd, cannot find anything to do with what the error msg. is telling me to do…
Whenever I try to run the Config Wizard It gives me the error saying
This file does not have a program associated with is for performing this action. Create an association in the Set Assoications control panel.
so that is saying I need to go to that place and associate it with WoW?
what if i lost my root pass?
AWSOME! thanks that did help :)
Hey, i’m trying to download this.
I get the thing installed just fine everytime.
When it gets done and it asks me if i want to configure it now? i click that, and it just stops. nothing works after that. not even the configure wizard. i am running vista. i dont know what to do.
MySQL server instance config won’t load on windows vista :/ i wonder if anybody has a solution
hey mate, i did as guide said, installed it but ut wont load the configuring page, no error messages nothing, i just doesn’t load….
any suggestions???
email me at: popcornhead123@aol.com
Hey ,
could you please answer on the issue about vista ?
“the application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.” I’m getting here ..
Plx answer.
Grtz , Cowie
Hi there !
i just want you to know that this is a very easily understandable guide.
Very good job !
// Erik from Sweden :)
oh never mind i see my error now
I’ve installed and configured the sql but when i open the cmd and type -u root -p it tells me -u is niether and internal nor external command
i assume you’ve disabled your firewall software, so try running this command through command prompt :
1. net stop mysql && net start mysql
2. mysql -u root -p
and enter your password when prompted
if you can connect to your mysql via command prompt, that mean mysql is working
When I type in the first step i get System Error 5. Any help?
If ure stuck at execute “start service”, make sure u dont allready got a servise named mysql.
I had that problem, just choose service name “mysql5″ or something in the dropdown list in the window before u execute =)
Hope u understand my english
I Get this error
C:\Documents and Settings\Windows XP>mysql -u root -p
Enter password: **********
ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)
C:\Documents and Settings\Windows XP>
i have no idea why the password is correct any ideas???
it’s same “Error 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)” too what now ?
Wtf is wrong whit my instalation of mySQL?
i tryed tomore times but nothink. when i execute it comes an error up. it’s about the “Apply security settigs”. and it’s a long error. soo i can’t install it and do next step. =,( please help
Install MySQL to C:\MySQL
as a side note: MySQL won’t stay running in my services list on Vista. As said earlier this used to run quite well, my entire squadron plays on our private server.
I’m having the issue with the following error:
“Error 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)”
if you could respond ASAP that’d be great, I’ve got my entire dorm waiting for me to restart our private server.
im getting error number 1045 on the instance config wizard :/
i have a problem, everytime i enter the mysql server instance config wizard, an error comes out:
(this file does not have a program associated with it for performing this action. create an association in the set associations controll panel.) please tell me what to do. and i need answer quickly, im eager to play!! =D
reply to: masew911_kazim@hotmail.com
hi there i encounter a problem im getting error 2003 : can’t connect to mysql server on ‘localhost’ can u please help me
solution (for me)
http://forums.mysql.com/read.php?11,195569,195569#msg-195569
One has to go at the MySQLInstanceConfig.exe with a ressource hacker.
Eventlog says:
Activation context generation failed for “C:\Program Files\MySQL\MySQL Server 5.1\bin\MySQLInstanceConfig.exe”.Error in manifest or policy file “C:\Program Files\MySQL\MySQL Server 5.1\bin\MySQLInstanceConfig.exe” on line 6. The value “asAdministrator” of attribute “level” in element “urn:schemas-microsoft-com:asm.v1^requestedPrivileges” is invalid.
I’m experiencing the same as the above posts, “side-by-side” error.
reaper if you have time could you comment on the vista situation.
My experience:
I encounter the problem of ‘cannot start windows service, error 0′, which I think might be caused by the XAMP 1.6 developer set I previously installed on my computer. Got no problem after I deleted it and run the wizard again.
hope this can help.
i am on vista for my comment above does that make a difference?
help i cant open mySQL server instance config wizard it says “he application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail?
Ya im havign the same problem as the two people above me, i also have vista
i’m getting an error when trying to configure mysql… it says “the application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.” does anyone know how to fix this problem?
Hey reaper
i tryed to configure mysql but when the finish mysql came up i checked the configure msql and when i finished nothing popped up i tryed to go into the folder and do it and i got this error: The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.
Please help me.
Ps. I am on windows vista if that has a problem
SOLVED !!
The MySQl version was blocking me.
I used the mysql 6 version.
I installed the previous one, Mysql 5 , and all is right now.
It was only the mysql version ^^
Mangosly yours,
Didier
…how do i make wow server to play on? i used to play panex but i dont know how to make custom weapns in it haha, im downloading the mysql thing now
Ok me and a Friend are trying to set up Cross Faction Parties, Chat, and etc….. Can anyone help us out with this….We just can’t figure it out and don’t know how it is set up exactly, if anyone could help with this, it would be greatly appreciated thanks
Thanks.
well,
No error message, all is perfect except when I attempt to create a second character in my
realm (in the same account or in another). With one character existing in the realm, all ok, i
play, gm commands ok, world ok.
BUT, when I create a second (or third, …) character, my character selection screen is empty (on all my accounts no matter who creates the second character).
however, the characters exists, I see them in the database and in the realm selection screen !
If i erase character(s) in the sql database except wich one i want, i have my character in my character selection screen and i can play.
I have reinstalled all (database, ReaperMangos5116), the situation remains the same.
All logs (file and console) are ‘3′, but i don’t have errors except :
SD2: WARNING >> Loaded 0 Localized_Texts. DB Table ‘Localized_Texts’ is empty
SD2: WARNING >> Loaded 0 EvantAI_Scripts. DB Table ‘EvantAI_Scripts’ is empty
P.S:
[I do my tests with the same computer running server and client to eliminate all network
problems even if all computers of LAN have correct access to my server.]
I hope you’ll have an idea,
Regards,
Didier
i did install it before and thought i did it wrong so i reinstalled it and now it gives me error 0 when i execute.
Reaper-X please help i did everything you said and still have same error 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
OK,
could you help me out again?
which mangos should I download?
btw i made sure i checked path but still same prob :)