MySQL Installation and Configuration – Setting up Private WoW Server

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 :

MySQL Community Edition (free)

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

Feel Free to install the documentation if you want it

And choose to install it

Please remember where you've installed the mysql program

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

You can register with mysql.com but it doesnt have anything to do with your mysql installation

After finished with the previous step, choose to configure mysql now (it’ll automaticaly run the mysql server instance config wizard)

It's better if you configure it now ;-)

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

Choose Detailed Configuration

and then

Choose the Developer Machine

and then choose the Multifunctional Database

Choosing multifunctional db

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

Setting up the innodb data directory

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)

Setting up maximum concurrent connection

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)

MySQL-Config-Wizard-6

Now you need to configure the default charset mysql should use. In this example i’m using UTF8

Choosing mysql default charset

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 ;)

Adjusting MySQL Listen port

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

Setting up root password

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

Start Menu
Accessories
Command Prompt

and then type like below image (when prompted for password, type your root password)

Testing mysql if it's working or not

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 :)

Comments Navigation « Previous 1 ... 6 7 8

frank said Jul 18, 2009 at 11:54 am

mysql wasnt 40 mb. it was 21. did i do sumthin rong?

Link to this comment Reply to this comment
Rhae said Jul 14, 2009 at 10:11 pm

The execute always stop at ’start service’
You know what the problem is?
Please help.

Link to this comment Reply to this comment
Need Help said Jul 14, 2009 at 6:02 pm

I Got the same please give me the anwser.

Link to this comment Reply to this comment
Helpneeded said Jun 24, 2009 at 3:56 am

Hey

I need help real bad,it gives me error 0,so I did what most users suggest and deleted all sql and old sql services but I STILL cannot get the setup past ‘Start Service’

Help would be truly appreciated>doomer16@gmail.com

Link to this comment Reply to this comment
Hurdler said Jun 3, 2009 at 10:09 am

If anyone is having trouble with vista try using SQL 4.1, I spent 2 hours trying to get the 5.0 working and in about 3 mins 4.1 worked.

Link to this comment Reply to this comment
weakbody said Apr 12, 2009 at 10:24 pm

hey, myself and a few other marines in iraq would like to set up a private server but all we have is a switch and no internet. Is it possible and how

Link to this comment Reply to this comment
Jason said Apr 7, 2009 at 4:43 am

*eh hum*

Welp, this is rather embarrassing…

Nothing a reboot wouldn’t fix.

I’ve gotten too used to Linux systems.

For those of you getting error number 1045, make sure you forward the port you are trying to use in your firewall. Including any NAT-like firewalls your router has.

Link to this comment Reply to this comment
Jason said Apr 7, 2009 at 4:25 am

Alright, So… First time server configuration for SQL. I had a few of the same errors up there and none of the above worked. Eventually, I fixed the Security errors by disabling my Firewall, and forwarding the ports MySQL uses through my router NAT. It got so bad that I had to make a DMZ, then work backwards. In the end, I ended up downgrading the MySQL version from 6.1 to 5.0.

Now I’ve got another issue. I don’t use the root access from a remote machine, and I made sure to check the PATH check for the batch, but, for some reason, every time I use the command “mysql -u root -p” in the command prompt, I still get an error message. For some reason, the installation isn’t adding the PATH value. Which File do I add to the execution path?

Link to this comment Reply to this comment
Desperate for help! said Apr 5, 2009 at 5:21 am

well, i have been running a Arcemu server for a while, and a little while ago i get an error while in the configuration on the applying security settings: The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 2003. Can’t connect to MySQL server ‘localhost’ [10061]

if a personal firewall is running on your machine, pleas make sure you have opened the TCP port 3306 for connections. otherwise no client application can connect to the server. after you have opened the port please press [retry] to apply the security settings.

if you are re-installing after you just uninstalled the MySQL server please not that the data directory was not removes automatically. therefore the old password from your 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 have had MySQL before but what do i do about it? and i put the pass root, its public, and i really need help, nobody i know knows what the problem

Link to this comment Reply to this comment
Sigh :'( said Mar 6, 2009 at 2:20 pm

I wonder if anyone could please possibly help me. I downloaded MySql from the link provided. When I installed the first time, it worked and ran fine. Then I had to uninstall it for some reason lol. So when I tryed installing it again it simply didn’t work. It installs fine, but when I configure the server and try and start the service it simply stops. It doesn’t give a error or anything in that regard. It simply says “Can’t start myql server.” I have uninstalled it, deleted all the files and cleared my registry of mysql files, but it still doesn’t work. Does anyone possibly know how I can fix it?

Thanks.

Link to this comment Reply to this comment
JD said Mar 4, 2009 at 8:00 am

Mysql 5.1/Windows Server 2008 “cannot start service: error 0″

Looks like this happens when the services management window is open. closing this and rerunning the configuration wizard fixed it for me.

Link to this comment Reply to this comment
GZAsmodean said Feb 22, 2009 at 4:26 am

For those of you who reinstall mysql and still get error 0; and are using XP, this solution may work.

1. do what wrath says above me.

2. Delete the following folder C:\Documents and Settings\All Users\Application Data\MySQL

Application Data is a hidden folder, therefore you must check under tools/folder options/advanced and check off show hidden files/folders.

For a really good resource site on how to fix mysql errors, check out their site

http://dev.mysql.com/doc/refman/5.1/en/
use the search button.

Link to this comment Reply to this comment
wrath said Feb 21, 2009 at 12:25 am

@petay pan

I would delete the my sql through the control panel fist. Once that is done go to to your c drive root and look for a mysql_InnoDb folder and delete it. after that go to c:\progrma files\ and look for a folder called mysql and delete the folder. What we have done is got rid of the mysql all together. Now reload the my sql and do not steer away from reaper-X steps above. try that and let me know. Thanks wrath

Link to this comment Reply to this comment
Petay Pan said Feb 20, 2009 at 10:33 pm

still getting the “mysql error 0″ iv tried wat reaper said to do but it doesnt do anything and the command prompt jus asks for my password n no matter wat i type it jus closes.

can someone help plz?

mushroom_man_249@msn.com

Link to this comment Reply to this comment
Petay Pan said Feb 19, 2009 at 10:52 pm

“cannot create windows service for MySQL.Error:0″

Help!! if you could email me or sumthing my email is mushroom_man_249@msn.com

thanks

Link to this comment Reply to this comment
matchstick said Feb 19, 2009 at 8:31 pm

i didnt use this guys guide but since im not getting any responce from the dude who made the one i used im chking out around here.
check your arcemu-world prompt, is it repeating an error line really fast?

Link to this comment Reply to this comment
rex said Feb 12, 2009 at 12:25 pm

i stoped mysql and it wont start back up in err file it says 090212 5:06:17 InnoDB: Started; log sequence number 0 1658857
090212 5:06:17 [ERROR] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table ‘.\mysql\db’ is marked as crashed and last (automatic?) repair failed
090212 5:06:17 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘.\mysql\db’ is marked as crashed and last (automatic?) repair failed. how do i fix it ?

Link to this comment Reply to this comment
wrath said Feb 5, 2009 at 8:31 pm

@ragnarok

Hey because loading MYSQL is a very quick and easy install, what I suggest you doing is uninstall mysql properly through control panel. Once you have done that look on your root c: drive and delete the folder that mysql loads. and then go to your c:\program files and delete the mysql folder. This will get rid of all remenants (except for registry but dont worry about them) of mysql. then reinstall MYSQl according to the guide.Also make sure the proper ports are open on your router if you are using one. I believe 3306 is one you need to open.Thanks wrath

Link to this comment Reply to this comment