How to make a WoW Private Server

[krual1]

Hello D3scene!
I'm new here and wish to contribute to the community.
Here is a guide to create your very own WoW private server using a great repack I found made by "Johved"
First you will need:
Johved's Repack 3.0.9
MySQL :: Select a Mirror
SQLYOG (community Edition)
NET Framework 3.5

------------------------------------
setting up MySQL
------------------------------------

Once you have downloaded MySQL, go to where ever you saved it and double click the icon.

Follow these steps through the installation:
[] Next [] []typical,next[] []install[] []next[] []next[] []configure server now, finish[]

Now follow these steps to set up the server:
[]next[] []standerd,next[]
[]install as windows service[]
[service name:MySQL]
[launch the server automaticly]
[]next[]
now this part is important.
make the password "Root" (without the " ") (you can change the password later)
click next
click Execute.

If it didnt execute successfully, i suggest you go through these steps again.
--------------------------------

AD.exe
Go to your wow folder (c:/programme files/world of warcraft
make a new folder in there called "Maps"
open your repack folder.
go to "TOOLS"
copy AD.exe
Paste it into your wow folder
run AD.exe
let it finish
open maps folder in your wow folder
it should have lots and lots of maps in there.
now copy and paste the maps folder into your repack folder
And there you go. AD.exe is done.
--------------------------
Setting up your database
--------------------------
This part has been made VERY simple and saves ALOT of time simply because of the repack (if you are using the repack i linked.)
If you are not using the repack i linked, you should find a differant guide. But not all is lost, for setting up any server you needed to go through the steps i went through above.

Anyway to set up your database you need to open SQLYOG and create new connection.
Call it ROOT
password: the same password you used when setting up MySQL server (root)
___
Now open up the repack and open "[start database]"
Let it run for about 5 mins and BAM! you have a database!
right click "root@localhost" click refresh object browser
then you should have a new database called "world"
Congratulations! you have set up your very own WoW server!
No need to worry about the Config files because they are already done!

To connect your private server do the following:
open arcemu-logonserver
open arcemu-world

This will turn your private server online.
To play you private server do the following:
open your WoW directory
C:\Program Files\World of Warcraft
look for "Realmlist"
Delete everything that is in there (save it to another place if you wish to keep playing the server currently on there.)
copy and paste the following:

set realmlist 127.0.0.1
set patchlist 127.0.01

Note: 127.0.0.1 stands for your localhost which means your server is private.

Credits:
Me for making the guide
Johved for hes Awesome repack!

THANKS FOR READING AND GOOD LUCK!

[krual1]

How to create an account on your server

Now that you have your server all set up.
You might want to beable to log in xP
And to log in obviously you will want an account.
to create an account do the following:

1) Open SqlYOG and sign into your database
2) Open Characters
3) Searth for the Table called: "Accounts"

This is where you create players accounts.

Ok lets make an account.

usethis in rows:

acct | login | Password | GM | banned | Flags |

1 user pass az 0 24

(everything i left out, leave it as it is)
____________________________________

Ok let me explain a few things

first let me explain about "Acct"

This is the account number.
For each account made it must be a differant number or you will get errors.
It usually goes 1,2,3,4,5,6 etc.

Now about the "login"
Says it all really, your login is what you use to log in the server

now, "password"
Same as above but your password ofcourse

Ok now "GM"
This is the commands that account will have access to.
AZ means A,B,C,D,E etc.
If you look at the commands, they are all in sections.
So to have access to all Commands you would but "AZ"
If you want that account to have no commands, leave it blank.

Now "banned"
Simple,
Want an account banned, put "1"
dont want it banned put "0"
simple as that.

Ok "flags"
This is weather the account is TBC or WoTLK or just normal WoW.

Lets start with the amount of flags each one has.
WoW: 0
TBC:8
WoTLK: 16

Now, to make the account just WoTLK without TBC you would put "16"
But to have TBC and WoTLK, you would put 24 (because 16+8)
Pretty simple.

Hope this helped ^^

[IllidanStormrage]

I will see if all this is successful.

EDIT: Johved Repack is not a virus. Successful Download. Next Download...
EDITAGAIN: MySQL is not a virus. Successful Download. Next Download...
Ok everything is good until i get to Let it run for about 5 mins and BAM! you have a database!
right click "root@localhost" click refresh object browser
then you should have a new database called "world".. what it supposed to happen in the 5 minutes? anything? I just have
starting mysqld-nt in background
C:\Program FIles\Johved's/ArcEmu
Press any key to continue... If that is what is supposed to happen then good... but world does not pop up even when I refresh

EDIT AGAIN: Ok, all i needed to do was install microsoft .net framework 3.5 lolz THANKS +REP! You might want to add that you must copy the ad.exe file in the TOOLS folder of the repack to the WoW folder and run it.

[krual1]

Yeah, i kinda rushed the guide
added AD.exe and net framework 3.5
Thanks for your feedback and for the +Rep ^^
Glad i helped.
Also did you get a WoW server working from this?

[IllidanStormrage]

I am at the part of starting world and logonserver, it all happens, but then at the bottom it says connecting failed due to 'Access denied for user 'root'@'localhost' using password: YES main database initialization failed. Exiting. Holy mather I got world and logonserver to work!

Lemme recommend a new link YouTube - How to make a WoW WoTLK private server for 3.0.9 (easy)
It basically spells it out, and you do not have to download the second and third things that you have krual1. What is great is that he brought the llink for the repack to us :-) thanks This is by johved himself too.

[krual1]

Originally Posted by IllidanStormrage

I am at the part of starting world and logonserver, it all happens, but then at the bottom it says connecting failed due to 'Access denied for user 'root'@'localhost' using password: YES main database initialization failed. Exiting. Holy mather I got world and logonserver to work!

The " 'Access denied for user 'root'@'localhost' using password: YES main database initialization failed. "

Basicly means the config file's username and password in your repack folder does not match your MySQL username and password.
Double check you did everything right in your config if you edited it.
But if you dont edit it for the time being, it should work on its own.
Also i cant remember wether you need to create the new connection on sqlyog or if the repack does it for you. :/
try creating one with:
username: root
password: root

Hope i helped!

[IllidanStormrage]

Originally Posted by krual1

The " 'Access denied for user 'root'@'localhost' using password: YES main database initialization failed. "

Basicly means the config file's username and password in your repack folder does not match your MySQL username and password.
Double check you did everything right in your config if you edited it.
But if you dont edit it for the time being, it should work on its own.
Also i cant remember wether you need to create the new connection on sqlyog or if the repack does it for you. :/
try creating one with:
username: root
password: root

Hope i helped!

Actually the problem was pretty weird.. if it says that (This is to everyone not just krual) press
ALT+CTRL+DEL and if you see any JohvedUserControl, mysqld-nt.exe, arcemu-world.exe, or arcemu-logonserver.exe, CLOSE THEM ALL. then reopen the usercontrolpanel and go from there.

Bump (Because this is a great guide, and I want everyone to be able to have a chance to see this).

[krual1]

Thanks IllidanStormrage

[heathy95]

Hmm guys, i dont get it. I want to make a p server for me nd some of my mates at school nd have followed all of the video but i still get The " 'Access denied for user 'root'@'localhost' using password: YES main database initialization failed. " please help me.

[Morphex]

this means that you already have a mysql running. So try to just start the server. If it don't work then look above your post.