MySQL Installation and Configuration – Setting up Private WoW Server

Update: Please check the updated post on Installing Apache, PHP, MySQL on Windows XP (for XP users) or Installing Apache, PHP, MySQL on Windows Vista (for Vista and 7 users) instead.

And if you’re looking for an updated wow private server guide, please check the new version on how to create wow private server for better version. Besides the new guide list everything in a single page for easier reading

This is the first part of the Creating your own World of Warcraft Server using Mangos

  1. The First part is all about Installing and Configuring MySQL on your Windows Machine
  2. The Second part is about Configuring the WoW Mangos itself
  3. The Third part is all about Setting up Private WOW Server for Lan Party
  4. 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

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

  1. Start Menu
  2. Run
  3. type CMD

or

  1. Start Menu
  2. Accessories
  3. 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 :)

Comment?

Note: Comment may not appear right away.

425 comments on “MySQL Installation and Configuration – Setting up Private WoW Server

  1. Hi
    I am trying to install my sql 5.1 on win xp sp3.
    I followed all these steps mentioned here but even after following these many times I get error 1405 access denied to [email protected]
    when I uncheck modify security settings box it gets configured but still asks me for a password on starting mysql
    Please help I am stuck since long on this

  2. i am on my laptop with windows 7 home edition and every time i try to install MySQL server 5.5 it freezes when i extract it i was wondering if that was a common thing on windows 7 or i am not installing it right or what… im so confused lol

  3. I had done the mysql and at first i noticed when i got the 5.0 full verson, I didn’t have as much as on the picture provided. however I continued and finished the install and executed the last thing. everything went through. good, but whenever i went to comand prompt and typed in mysql -u and -p, it gave me “error 1045 : access denied for user ‘and’@’localhost’ ”

    I remembered my password but it still gives me this.

    I just got my brand new pc so

    1. well based from your error message it seems that you didn’t provide the username to connect to the mysql server ;)

      try typing:

      mysql -uroot -p

      and enter root password when prompted