Ascent Private Server Setup, Using Mafiaboys and Hamachi. Guide and downloads inside.

**tarryn** · 01-27-2008

This is my first post and guide. I'm fairly new to this so here goes. =].

Items Needed:
Mafiaboys Repack - http://filebeam.com/7b374e71b0cc0191fc12e4867685fa95
Navicat 7.24 - Filebeam - Free Fast File Hosting
MySQL 5.1 - http://dev.mysql.com/downloads/mysql/5.1.html
Hamachi - https://secure.logmein.com/products/hamachi/vpn.asp?lang=en
WoW 2.3.X TBC

Guide:
Step 1 - MySQL Configuration.
Once you have installed MySQL; Go to Start Menu, My Programs, MySQL, MySQL Server 5.1, MySQL Server Instance Config Wizard.
In MySQL Server Instance Config Wizard do the following:
1) Standard Configuration.

2) Install As Windows Service - MySQL51.Have "Launch the MySQL Server automatically" checked.

3) Modify Security Settings:
"[New Root Password: ***
Confirm: ***]"(This password is used elsewhere, remember it).
Have "Enable root access from remote machines." Checked.

4) Execute. Finish.
There are various problems that occur here;
A) If Start Service doesn't initiate its because you have previous SQL data left over. If so, uninstall MySQL, then go to "C:\Program Files" scroll down to MySQL and delete the folder. After this reinstall and it should work.
B) If Apply Security Settings doesn't initiate its because:
a) You've got previous Data, you need to go to "C:\Program Files\MySQL\MySQL Server 5.1" and delete "my" Config File. Then remove instance and reconfigure, it should work.
b) You need to open port TCP 3306, which is done by going to control panel, security settings, firewall settings, open port 3306 TCP. It should now work.

Step 2 - Hamachi and IP setup
1) After installing Hamachi and signing up, run it, there should be an IP adress at the top, like 5.157.25.86.

2) Record this, you'll need it if you with to go public.

Step 3 - Navicat and database setup.
1) After you've installed Navicat, run it and go to New Connection if it doesn't prompt you. 2) Connection Name: Ascent
Hostname/IP Address: (Your Hamachi IP)
Port: 3306
User Name: root
Password: ***** (Same as you MySQL Password)
Click OK.

3) Right click "Ascent" in the table to the right and click "New Database". Name the database "ascent" (no caps).

4) Right click your new database and go to "Execute batch file". Navigate to your "WORLD_DATABASE" then click execute. (It will start importing the core into the database). It might a take a while depends on your computer, it is a big file, so bare with it.

5) Once its finished, go to "Table" > "accounts" there type in youraccount details.
Acct Login Password GM Banned LastLogin LastIP Email Flags ForceLanguage
auto Name Pass az 0 (auto) (auto) blank *0-8 *enGB or enUS

*0-8 - 0 is non-TBC and 8 is TBC.
*enGB or enUS, this doesn't matter too much just do your home country.

Step 4 -
And Nevermind I Didn't Realise - http://www.mmowned.com/forums/ascent...-s-repack.html