[Help] Connecting to MYSQL?

[Deamie]

I want to setup my server (that i am making a repack out of) to MYSQL, but i would love to know how to do it. Please can some help?

+Rep x2 for the person who cracks the question for me.

[Deamie]

Anyone going to help? >.>

[Kcquipor]

[MaNGOS][UDB] Setting up the latest UDB based MaNGOS! - GamerzPlanet - For All Your Online Gaming Needs!!

here you find what to do

[Deamie]

I Spoke to soon, that didnt help me one bit =/

+rep x 2 up for grabs still >.>

[guitargod218]

This is extracted from a guide made by j9sjam3:

MySQL
Open the MySQL installer.
It, by defult is located in /Needed Files V4/Needed_files/mysql-essential-6.0.4-alpha-win32.msi
Double click on it, and make sure the little circle labeled 'Typical' has a dot in it.

Wait for it the install. Once it has done, click next, then next again.
After that, make sure ‘Configure the MySQL Server now’ box is ticked and click next.
NOTE: Vista users, please refure to the FAQ if this part doesn't work

Once that box has opened, click next. Click ‘Standard Installation’

Make sure the ‘Install As Windows Service’ box is ticked.
Also make sure the ‘Launch MySQL Server automatically’ box is ticked and make a password.
I would personally use root for the time being, until you get your server running sucsesfully.

Click next.

Click execute, then finish and your done!


Navicat
Install Navicat, its really easy. /Needed Files V4/Needed_files/navicat8lite_mysql_en
Just click next a few times.
Once you have installed Navicat, open it.
There will probably be an icon on your desktop.
Click on New connection.
In the connection name, type anything you want E.G Ascent
The Hostname/IP should be localhost.
The port should automatically be 3306; if not change it.
Make your username root.
Use your password you used from the MySQL installation.
I reccomended using root
Click next when you have filled everything in.
It should look like this...

Once it has loaded, you should see something called ‘Ascent’ or whatever you called it on the left hand column. Right click on it, and click ‘new database’.
Call the database ‘logon’ or anything you want to call it.

Create a new database called 'char' or anything you want.
And a new one called 'world'.

INSERT DATABASE FILES HERE, IF YOU ARE UNSURE ON HOW TO DO THIS, LET ME KNOW

Making an account
This is simple. Just click on the table accounts, and enter the data required there
Just enter all the information you want.
If you want to be root admin (access to all commands) you will make the admin column az
If you want to have Burning Crusade enabled, you will have to make the flags column 8



Configuration
Go to your Ascent folder (SpartanWOWrepackascent3353) and find ascent.conf (also may be ascent-world.conf).
Change the things in red (here they are capitalized):

Ascent-world.conf
<WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "MYSQL_PASSWORD" Name = "DATABASE_NAME_E.G_ASCENT" Port = "3306" Type = "1">

<CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "MYSQL_PASSWORD" Name = "DATABASE_NAME_E.G_ASCENT" Port = "3306" Type = "1">

Logonserver.conf

<LogonDatabase Hostname = "127.0.0.1"
Username = "root"
Password = "MYSQL_PASSWORD"
Name = "DATABASE_NAME"
Port = "3306"
Type = "1">

See the entire .conf file here:
http://www.mmowned.com/forums/ascent...tml#post592558 ([Guide] How to make an Ascent Server: The Noob way)
When you have done that, you are nearly done.
Just open your World of Warcraft folder (Usually C:Program FilesWorld of Warcraft)
Then open your realmlist.wtf file. Change it to 127.0.0.1

Open logonserver.exe and then ascent.exe
Wait for it to load until it says ‘connected with X ms’

Open World of Warcraft, and log in with the account you made before.
Well done! You made a Ascent Private Server!

That should help you. Once again, I DID NOT make this guide, I only copied and pasted an except of it.

[novaprosp3kt]

Ah I think I know what you want to do, if I can read this right, you want to take your SQL database on your current server, and include it into your repack...

There are 2 ways to do this, first you can take an SQL dump of your DB for people to import into their own SQL, I use heidiSQL but Navicat etc should be roughly the same...



Just right click your world database and Export as an SQL file/SQL Dump.


What I do in my repacks is copy the "bin" "share" & "data" folders from your MySQL install, that way the person can just run mysqld-nt.exe from the bin folder and your entire MySQL install is copied to them


(EDIT: This is what I think you meant, that you HAVE a mysql DB that you want to easily include in your repack, but dont know how)