AzerothCore
Pages (Latest 10 updated) :

Database Installation

Installation Guide
This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps.
<< Step 3: Server Setup Step 5: Networking >>

Creating the Database in MySQL

Creating the Databases and User

First of all you need to create the acore user using the script below.

https://github.com/azerothcore/azerothcore-wotlk/blob/master/data/sql/create/create_mysql.sql

You can perform this with a MySQL client or with the MySQL command-line interface (CLI).

You would need to use one MySQL root account with your MySQL client or with MySQL CLI before starting core to run one of those files (use MySQL root only to import one of those files, never run core as root or administrator).

Tip: You can change the password of the user you are creating for increased security.

Populating the database

You can choose to populate the database in two ways:

  • Automatic Database Updater (default, recommended)
  • DB Assambler tool

If you want to know how the SQL directory works or plan to have custom changes we recommend you read this.

By default the Worldserver and Authserver will check for, and import all new files into the database you specified in the config.

This is the easiest and recommended way to make sure you are always up-to-date with the core.

To edit the automatic database updater you will find the neccessary settings in authserver.conf and worldserver.conf under UPDATE SETTINGS.

DB Assambler (For advanced users that want more control)

This is a tool written before the automatic database updater and essentially does the same thing.

Importing the Database

Note: if you're using MySQL 5.7, first run

mysql -e "SET GLOBAL sql_mode = '';" -u root -p first

(replace root with your mysql user).

Note: If you are using Windows you will need to run the .sh files with git

  1. Open C:\AzerothCore\apps\db_assambler

  2. Run db_assambler.sh bash apps/db_assembler/db_assembler.sh

  3. Select import-all: Assemble & Import all

Changing user or password

If you want to change the user or password you will need to edit the script config.

  1. Copy the file conf/dist/config.sh to conf/config.sh.

  2. Open conf/config.sh with a text editor.

  3. Go to the secion DB EXPORTER/IMPORTER CONFIGURATIONS.

  4. Edit the variables accordingly, e.g. you most likely need to edit MYSQL_USER and MYSQL_PASS variables putting your mysql server settings.


Help

If you are still having problems, check:

Installation Guide
This article is a part of the Installation Guide. You can read it alone or click on the previous link to easily move between the steps.
<< Step 3: Server Setup Step 5: Networking >>