AzerothCore
Posts (Latest 10 updated) :
Read all

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 and Populating the Database in MySQL with automated script

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.

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 >>