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
- Goodbye Repacks … » Reaper-X .:[ ID ]:.
- Erytheia Trinity Core Repack Release V1 for WoW 3.1.3 » Reaper-X .:[ ID ]:.
- Darkened Linux Trinity Core Repack for World of Warcraft 3.0.9 V2 » Reaper-X .:[ ID ]:.
- Darkened Linux Trinity Core Repack v1 for WoW 3.0.9 » Reaper-X .:[ ID ]:.
- Reaper Trinity Core Installation Guide » Reaper-X .:[ ID ]:.
- "Arcane-Fire" UR1 MaNGOS (2.4.3) » Reaper-X .:[ ID ]:.
- MaNGOS 6245 (UDB + PSDB), ScriptDev2 r474 » Reaper-X .:[ ID ]:.
- Reaper MaNGOS 5953 with ScriptDev 414|Server Compatible With 2.4.2 (UDB ONLY!) » Reaper-X .:[ ID ]:.
- Reaper MaNGOS 5931 with ScriptDev 412|Server Compatible With 2.4.2 (UDB ONLY!) » Reaper-X .:[ ID ]:.
- Reaper Mangos Installation / Upgrade Guide » Reaper-X .:[ ID ]:.
- Reaper Mangos 5082 - Easy WoW Private Server for WoW 2.3.3 » Reaper-X .:[ ID ]:.
- Reaper Mangos 5005 - Easy WoW Private Server for WoW 2.3.2 » Reaper-X .:[ ID ]:.
- Reaper Mangos 4875 - Easy WoW Private Server for WoW 2.3.0 » Reaper-X .:[ ID ]:.
- Making a WoW Server using Reaper-x Mangos - Gamerz Needs - For All Your Gaming Needs!
- Making a WoW Server using Reaper-x Mangos - Gamerz Needs - For All Your Gaming Needs!
- Reaper Mangos Mod 4703 - Easy Custom WoW Mangos Private Server » Reaper-X .:[ ID ]:.
- Reaper Mangos 4703 - Easy WoW Mangos Private Server » Reaper-X .:[ ID ]:.
- Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database » Reaper-X .:[ ID ]:.
- Reaper Mangos 4651, ScriptDev2 151 with Project Silvermoon and Unified Database » Reaper-X .:[ ID ]:.
- Mangos 4629, ScriptDev2 150 with Silvermoon 18.5 and UDB 0.8 323 support 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4535 ScriptDev2 137 work with WoW 2.1.3, 2.2, and 2.2.2 » Reaper-X .:[ ID ]:.
- Frequently Asked Questions about WoW Mangos Error Message » Reaper-X .:[ ID ]:.
- WoW Mangos 4524 modified to work with WoW 2.1.3 and 2.2 » Reaper-X .:[ ID ]:.
- WoW Mangos 4505, ScriptDev2 136 with Project Silvermoon Rev18 » Reaper-X .:[ ID ]:.
- WoW Mangos 4488, ScriptDev2 134 with Project Silvermoon DB Rev17 » Reaper-X .:[ ID ]:.
- Creating WoW Private Server the easier way (perhaps) » Reaper-X .:[ ID ]:.
- How to Configure MaNGOS the World of Warcraft Emulator » Reaper-X .:[ ID ]:.
- Installing and setting up Apache Webserver with PHP - Setting up Private WoW Server » Reaper-X .:[ ID ]:.
- Creating Public Server for LAN Party - Setting up Private WoW Server » Reaper-X .:[ ID ]:.
- Configuring Mangos for TBC Server or WoW Classic Server - Setting up Private WoW Server » Reaper-X .:[ ID ]:.
Leave a response
Connect with me
back to 1045…
ok, i deleted all of it and tried reinstalling again, now i get that “Could not start the service MySQL.Error:0″ umm
wth lol
my firewalls are bugged
if it says port 3306 is already in use, is that a problem?
When I am in the command prompt and I type in my password, it says “ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)”
does that mean it is blocking it somehow or I don’t have the ‘rank’ to do it??
ok, i download the Msql version 5.0 and the 40 mb full version, my installation skips the step with the regestring at Msql thing, and then it stops at Start Service saying Error #0…
i have checked to err file and it came up weirdly in code…
any ideas how to fix this it said data drive is full got heaps of space…..8gig left.
thanks
Errm one problem
ive downloadsed mysql – 5.045 – only one i could find
Ive extracted it cose i had to and now i cant find how to install it anyone know why?
Wait that was my fault im in such a rush to get my kick ass gm powers woo! that i downloaded linux version not windows version – im an idiot i know
I just checked in my run if it worked and it did.
Ah that mean mysql is working, now try importing all the mangos database and then run the mangos process and see if it’s working or not (if you’ve imported the database correctly, you can see mangosd window and realmd window displaying status message)
Yeah, reaper…my ports are still closed and i dont even understand what the SQL did…i turned off all my fire walls on my comp and my firewall bellsouth is hosting for me…know what i should do?
I get the same error about a firewall blocking port 3306. I’ve tried to install both with that port as an exception and with the firewall turned off completely. The error always occurs without fail.
Does anyone know what is really causing this error and how to fix it?
I can not find any working solutions via google or by searching the MySQL forums or help files.
Thanks
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
I have a server if any one needs help or wants to join you can get a hold of me at fullmetalxxxnx@aol.com or use xfire fullmetalnx use xifre its the best way to get a hold of me and the only thig wrong that really big about my server is one kill gets you to lvl 70 and one kill drops 234523 gold lol will be fix
wow 1 kill goes to 70 ? that’s an extremely high rate wow server :P
I followed your instructions as best as i could but MYSQL still doesnt seem to want to work properly, im sooo lost..help?? :(
Your best bet is to look for .err file in your mysql installation directory (unless you’ve modified the default path of mysql data directory)
I’ve been getting problems with some BS about a fire-wall. Any help?
Same here error 1045 iv tryed to ass the port 3306 TCP but it still came up so i turned off my firewall and tryed and it still came up whit ” Access denied for user ‘root’@'localhost’(using password : YES) this comes up when i execute on the ” Apply security settings” any idear’s? cause im all out
thnx!
ok error 1045 someone got any idea how to fix it? i turned off my firewall to see, didnt work im not sure what to do
Where did you get that message ? from the command prompt or .. ?
Sorry for asking this but i didnt see it anywhere unless im blind but if we meaning 10 of us wanted to play TBC via LAN this way do we all need to install WoW and TBC or could we just copy the whole thing from 1 computer and run it that way Please reply ASAP we want to play this weekend comeing up
yes, you’ll need to install the WoW client (wow installation cd to each computer)
Anyone made a server they want tested by me? i am a very responsible GM. email me at jb95@hotmail.co.uk
When configuring MySQL I can’t seem to get around the Error: 0. I have reinstalled it and deleted the mysql program folder before installing and it still seems to give me that error. Is anyone else having this seemingly unfixable problem?
also my friends cannot log in to the realm.
I cannot enter any instances now that I have set up my private server, can you help me?
brent – you actually dont have to redown load it as long as you still have all patch versions saved on your computer, use the repair.exe in the world of warcraft folder itll take you back to first version of tbc then just add patchs back in. its a little quicker then completly reinstalling
the tags didnt gone in the last message =[
i’l write again the sintax
– Update realmlist set address = (Old Ip), address = (New Ip) where id = 1;
Just a tip…
in some mysql clients, the string variable of IP may have to be used with (double)” not single.
In my Pc i had to use the sintax
– Update realmlist set address = , address = where id = 1;
Okey donkey?!
Cya!
o if you want to get a hold of me im at zztt37861@yahoo.com
i cant get it to work i get to the step where i have to click the exicute button and then the starting services one fails so i cant finish plz helpo ill let you do that remote assistance thingie if you need to
now it says service caould not be started error: 0 ;(
skeloman yea u did help me ;)
thankyou
holy sh*t i helped someone? two people? man i wish my firewall wasnt gay and could add ports, id be on my own server livin the good life!
Will I have to re download WoW and TBC in order to create my own server? I don’t want to get deep into this and then it all be for not because I had the wrong patch.
Awe kk, thanks=)
yes ur ip adres goes there, skelomon thanks for the help ;)
Ok just wanna say awesome job showing everything but I got 1 more question…
What would I put for realmslist if I didn’t want it to be LAn enabled or public at all? My own IP?
Nevermind..I didn’t change anything but I clicked retry and it worked that time=)
this is Also my first time installing MySQL…
Can I just skip it and it’ll still work?
I have same problem as maker..but no firewall>
*maker103 hey this may work for you, go into your firewall options if you have one, and make a port for 3306 name it whatever you want, and that should work. if it doesnt you can try reconfuguring it, but when it gets to the security information, uncheck the box that says “change security info” that may bypass it
ok i got past that one error now i have
The secruity settings could not be applied
error Number 1045.
Access denied for user ‘root’@localhost’(using password: Yes)
Anyone know how i can fix it please, i have been trying to get a server for ages now.
I would really appreciate the help.
Can’t start service? | Jul 3, 2007 | Reply
says cannot create windows service for MySQL. error:0 .. help meh
Can’t start service? | Jul 3, 2007 | Reply
nevermind I got it
i got the same prob how did u fix it?
anyone know?
i was wandering wat u did to get the service to begin working get back to me at T_Bone717@comcast.net ty
hey thanks for the place to download these things and stuff i like the pictures u put in, but i have the same problems as others says cannot create windows service for MySQL. error:0, possible to tell us some reasons it may be broken or not working and how to fix them, i know u gave us a link on troubleshooting it, but sorry i dont get alot of this computer stuff
I believe this link will give you a solution to the can’t create windows service error message :)
# Shadow
did you previously installed mysql on your machine ? or is there any other program use the same port as mysql ? (port 3306)
I tried to make a private server for a game and during the configuration of MySQL, at the part where you click the checkbox to include the Bin Directory, the top part with the checkbox to install as a window service, is completely greyed out. I continued and found I could not open 3306. I use windows XP… any idea what I’m doing wrong?
I am getting the same problem as they are cannot create windows service for MySQL. error 0
Also i am getting the port cannt not be accessed not sure how to change that or what i messed up
email is: Ripit901@cox.net
I found out how to fix it. If you still have this problem maybe its because there are some files and folders in the path you chose to install you SQL
So first you need to remove(from the installer) your sql and then manualy delete the remaning folders(C:MySQL InnoDB Datafiles\ and C:Program Files\MySQL\) then to not get the “port can not be accessed” could be coz of your firewall so i closed it. This worked for me :)
Just in case after you removed the sql and deleted the folders, exe—> CMD and type “sc delete sql” and reinstall sql.
ok i got farther, but not by much, on the next stage of the execute on configuring mysql, it says it cannot access the log because either a firewall is blocking it or the password is wrong…
please help asap once again my msn is skeloman64@hotmail.com
im getting teh cannot create windows service for MySQL. error 0
I posted on a different guide as well, but figured i should post here too since this one is more recent, so whenever i do the execute step it tells me it cant start mysql errror:0 on the starting mysql phase, can you please tell me what to do to fix this, you can message me at skeloman64@hotmail.com
nevermind I got it :)
says cannot create windows service for MySQL. error:0 .. help meh :)
thanks for help, i had to my the “MySQL InnoDB Datafiles and “MySQL InnoDB Log Directory”
Same problem as above, stops on start service.
Only .eer file I found said error 123, which I looked up and it said
(ERROR_INVALID_NAME)
The filename, directory name, or volume label syntax is incorrect.
Tried diff dir and still wont work, help plz? thx
go to where you’ve installed mysql (for example C:\Program files\MySQL) and search for .err file and open it using notepad or any other text editor and you’ll know the reason it wont start :)
everytime i try to execute it always stops at “Start Service”, any ideas why please?