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
ok but now when i come to using mangos i can’t do the things you’ve written down to do in the command promp
are you planning on using Reaper Mangos ? if so you don’t need to add path to your mysql bin directory but if you want the mysql command to be accessible from any directory (in command prompt)
you need to make sure to check Include BIN Directory in PATH (from mysql server instance config wizard)
there is no error it just says that “mysql” is not recognized as an internal or external command, operable program or batch file.
any ideas?
:)
# scott
actually you dont need to type the c:\Documents and Settings\Beta> :)
# silas
Could you describe it more ? for example what is the error message you get :)
# Didier
Could you tell me did you get any error message ? and if you’re doing fresh installation could you try reinstalling it again to make sure everything has been installed properly
PLease help me, cause i keep on trying it really doesn’t work.
ok this is what is says exactly:
C:Documents and settings\User>mysql -u root -p
‘mysql’is not recognized as an internal or external command, operable program or batch file
that is what it says
windows xp is that what u mean service pack 2
to those who keep getting mysql error 0 :
http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/#comment-30226
and to those who still having problem with mysql installation, could you tell me what is your operating system ? :)
UHm,
I got this problem when I run the command promp but I tried to run the mysql server like 200 times again and it still doesn’t work
please help me!!!!!!!!!
ok i give up i cant get this crap to work can some one assit me plz if u will email me @ blade3861872006@yahoo.com i would be greatly thankfull if some one can help idk what my computer is doing but its not working
what do i do
i keep geting this message
C:\Documents and Settings\Owner>c:\Documents and Settings\Beta>mysql -u root -p
‘c:\Documents’ is not recognized as an internal or external command,
operable program or batch file.
Hello,
First, congratulations for yours tutos and tools.
I have just a little problem.
The server seems to work fine, BUT, when i log in my account, i arrive in an empty character selection screen.
Even if i create a character, the character exists, BUT, no character visible in my screen.
[The server is on the same machine than the client. the situation doesn t change if i use a remote computer (LAN)
I work with a client 2.3.3 and ReaperMangos5116
(sorry for my english, i’m french)
Any idea , please ?
Thanks
man i tried a million times and wont work (when im going t hit execute at the really end of MySQL Server Instance Configuration Wizard it says.. “Cannotcreate windows service for MySQL. Error: 0 -.-
thanks ben will do =)
Sweet, this did it. thanks man.
It keeps saying, ‘-u’ is not recognized as an internal or external command, operable progam or batch file.
Wow, for some reason I couldn’t spell MythicalArcher, lol.
#MysthicArcher, Shawn, and Michael
I realise that we all shared the same problem with running the configuration wizard.
With some help from the forums, I found out that there is a bug in MySQL version 5.0 that prevents the wizard from running on Vista.
Simple Solution: Go to the site listed in the guide where you download MySQL. Search around for the more recent version 5.1.22 and download it. This worked for me, so it should work for you.
i have no clue to y my pomputer does this only thing i can figure is that i have vista and it is making it messup in someway.
after i install MySQL like the guild says, where it is supposs to automatically pop the configure MySQL up, it doesnt. when i try to run the MySQL Server Instance Config Wizard it says either “The file does not have a program associated with it for performing this action. Creat association in the Set Associations control panel.” or “The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more details.”
ive remove the program and reinstalled it 3 times now and its the same problem each time ><
if u can help me plz send me a message at cargo1001@msn.com
It Says Error Nr.2003 Can’t connect to MySQL server on ‘localhost’(10061)
Yeah, I was also having the same problem as Shawn until I ran it as admin. Now I just get the side-by-side configuration problem like MythicalArcher.
Hey hows it goin, I have been recieving a few errors…I found some solutions throughout this page though..but I am still having trouble with this error that I recieve when trying to run MySQL Server Instance Config Wizard:
“This file does not have a program associated with it for performing this aciton. Create an association in the Set Associations control panel.”
Thanks in advance.
oh btw, one more thing out of curiousity… How did you fall into this sort of stuff’?
I seem to be having the same problem as MythicalArcher. I have been trying to fix it for the past 2 days, but I can’t find a solution. Help is greatly appreciated.
Jeremy,
Had the same problem with mine, it was driving me nuts and finally figured it out! Getting bounce backed into the realm list that is…
You have to run the ManGos server configurator again (if using reaper it will be the “reaper-x-mangos.bat”) and choose the Configure LAN party option. Then when it says to put in your IP, you need to put in your EXTERNAL IP address. (The address assigned to your router or firewall by your ISP).
Hope that helps,
Shinzon
Hi. I’ve searched all over the internet for my problem but it seems to be more rare than other people’s.
I had tried to install the mangos but was getting that “‘mysql’ is not recognized as an internal or external command. So I tried to reconfigure my instance since I already had one running from using the program SAM Broadcaster.
It didn’t seem to work so I tried to reinstall the program but when it asks to start the configuration wizard it doesn’t start. So I go to it manually from the start menu and I get the error:
“The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.”
Can anyone help me please? If I can’t get mangos running I at least need the database back so I can continue to use the other program SAM.
The MySQL forums suggest getting 4.1 and I’ve tried that but I get the same error when installing mangos as I did in the first place. Also SAM won’t work because it can’t find the database.
Can someone make me a private server lol im not getting this…
or can i join someomes and get GM power i no every command there is
Hi Reaper, I’m having trouble with the run command “CMD” the window that pops up says
C:\Documents and Settings\Owner>
and on your picture it says
C:Documents and Settings\Beta>mysql -u root -p
Is this a problem? Please respond, thanks. (ps, its very hard to type what you have in your picture >.<)
Says “Could not start the service MySQL”
MAN I LOVE YOU. i works perfect for me unlike other emulators with which i had big problems.
keep on doing what you are doing cause i think you’re the best.
Thanks again!
man y`m in desparate need for some helt .. how do y find out the name of my database? … the damn regristation page doesen`t link to the mysql because y don`t have the name of the database ..
It blocks my localhost! Look!
2008-01-23 15:27:02 Using configuration file realmd.conf.
2008-01-23 15:27:02 MaNGOS realm daemon /0.10.0-SVN (Revision 5054 ) (Win32)
2008-01-23 15:27:02 to stop.
2008-01-23 15:27:02 Database: 127.0.0.1;3306;mangos;mangos;realmd
2008-01-23 15:27:04 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user ‘mangos’@'localhost’ (using password: YES)
2008-01-23 15:27:04 ERROR:Cannot connect to database
Can someone help?
I’m having a trouble same as Cody.
When I’m opening C:\WINDOWS\system32\CMD.EXE
Is shows me C:\Documents and Settings\Owner>
In stead of C:\Documents and Settings\
What shall i do?=)
Thanks!
Well, I got a problem. I done everything and i click on excute. It says when it comes to service. Unable to install Apply service for computers :SSS
Help me.
MSN: Ismail.channouf@hotmail.com Add me and help me :P
OK, i have tryed the following to fix this,
Makeing port 3306
Disableing firewal
disableing anitviuris
anyone else that can help me
Bowser-dog@hotmail.com
Ok, i’ve been trying to setup a private server, because lovely blizzard lost my password or something, but i can’t use my retail acct. Well, i get to the part where i am to test and make sure MySQL is working, but i always get Acess denied for user ‘root@’localhost’ error number 1045, anyone that can help email me at Bowser-dog@hotmail.com
OK reaper, I was wondering if u cud help me with a problem. I’ve been trying to make a private server for about 6 months now and i am never successful. But, this site has proven the most promising for me and makes a lot of sense. I installed MySQL according to your instructions…but when i get to the end and press “Execute” it stops responding. So i do Ctrl+Alt+Delete and end the program. For some reason it was installed i guess and i go onto SQLyog to connect and it gives me error 2003. “Can’t connect to ‘localhost’. PLZ help me!
I Got to step 1 in installing mysql where it showed showed me what custom features i want installed and it didn’t show the option “MySQL Instance Manager” Anyone know whats going on?
ok i did the whole thing apart from i dont know where do open command prompt via Mysql
= /
PLease msg me here or send an email at
Barneyskater@hotmail.co.uk
**************************************
@INFORMATIVE
Thanks for the information mate. Unfrtunatly, This did not solve the issue.
They can see my realm, they accept it, it flashed the create character screen and bounces back to my realm list.
here are my settings to be sure.
in my actual realmd database file, I have altered the table called address from 127.0.0.1 to my “Internet IP” as told to me from http://www.whatismyip.com or something similar.
I changed the ManGOS.CNF file to this.
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “68.110.87.134;3306;root;12w23e34r;realmd”
WorldDatabaseInfo = “68.110.87.134;3306;root;12w23e34r;mangos”
CharacterDatabaseInfo = “68.110.87.134;3306;root;12w23e34r;characters”
I changed the realmd.CNF (config)
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;root;12w23e34r;realmd”
I still have the same issues.
Please, any suggestions would be greatly appreciated
@BOB
Thanks a ton, I’ve been racking my brain about this editing weapons, your tutorial got me my first personalized weapon, only thing is, the graphics didn’t come w/ it, makes my fist look like a disco cube, lmao.
Thanks all the same.
PLEASE HELP! I’m having a drunking wow party this friday to celebrate this new private server, don’t let us down, super please!
Hello,
First off, I’m so thrilled your taking the time to make stuff like this for bus like me. Thank you.
Second. If I go into the CFG files on your batchs the ones labelled RealmD and MangosD, if I edit the IP address in those files, they don’t run, I think I learned that the MangosD one just needs to know my local IP, but the RealmD one needs to know the one I wish to have people connect to, my Net IP. If I change that, then I get an Error Starting RealmD which says something like this.
Using configuration file realmd.conf.
MaNGOS realm daemon /0.10.0-SVN (Win32)
to stop.
Database: 5.78.178.110;3306;root;12w23e34r;realmd
Could not connect to MySQL database at 5.78.178.110: Host ‘XASUS’ is not allowed
to connect to this MySQL server
Cannot connect to database
ok, so here is the thing, I’m using a net IP program, so that I’m not bumping into port forwarding issues, no router, just my provider’s modem is in this mix.
When I start mysql, it prompts for password and I enter, it goes to the ready prompt,
I start mangosd and it worked fine.
I start the realmd, and bam, it’ll say that message above.
Please help. = )
Feel free to e-mail me anything, maybe look at my files I’m using, or explain the IP’s in the files and also I noticed this line here
What is that?
# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;root;12w23e34r;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;root;12w23e34r;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;root;12w23e34r;characters”
The part that used to say mangos;mangos;realm, I changed that because i was hoping that was the localhost error I was getting’s problem, didn’t seem to make a difference at all.
Hey i read all these posts and just cannot find this .err file. what should i do ?
Please Reaper help me! I want to make custom items and i don’t know how to add them to my database. I have the SQL script files with the data for the items, but I don’t know how to add them! Please tell me how to put them in my database so that I can spawn them in the game.
Reaper, per your advice to Mike
“1. adding skip-innodb into your my.cnf
2. comment (#) all innodb configuration in your my.cnf
3. restart mysql”
I did those steps, but each time I try to restart it recreates the my.cnf and disreguards my changes. Any more ideas?
ok, well i’ve cought up to where i was. but in one of you steps (in the next guide, you disabled comments for it.) i cannot find “DBFilesClient folder” I’ve downloaded everything on your lists and still nothing, not even when i search my computer for it. please help. if you get on MSN messenger or Yahoo, Ect. then i can maybe let u remote acsess it for me. please respond,
Hey, i had a very bad tornado storm yesterday and had to cut off on my progressso i decided to restart and its not working for me now, if you could just add my msn that would help alot more, it is loves2sk8@hotmail.com thanks.
ya i have the same problem and the only .eer file wont open whenever i try it just closes and i cant open it in a notepad file so i just keep getting the message:Could not start the service MySQL.Error:0
i have no clue what to do now :( plz help
Fixing mysql error 0 ? see my previous comment :)
http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/#comment-30226
and btw of course, you can write guest post .. just send it to me via email (look at my about page) ;)
but now im back in squire one – getting error 0 msg……
damit, if i ever complete this, can i post my own guide on your website?
now i am uninstalling everything, AND starting alllll over again………
but yet how to beat that problem? :(