blob: 92953c7a966beeac4947c725494f739631086bbc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
You can setup the database manually or using the automated script.
## Get a Database client
We recommend to get a database client to operate to your DB easily, see [this page](Database-client.md).
## How to setup the AzerothCore DB using the automated script
### Use the default configurations:
The `db_assembler` script and the `acore.sh` dashboard both use by default the **acore** db user for the database connection. Running for the first time the assembler command should create the user for you, however, if you're having permissions error or any other issue with that user, please open your MySQL client with the root user and run the following queries:
```sql
DROP USER IF EXISTS 'acore'@'localhost';
DROP USER IF EXISTS 'acore'@'127.0.0.1';
CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore';
CREATE USER 'acore'@'127.0.0.1' IDENTIFIED BY 'acore';
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON * . * TO 'acore'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit;
```
It will setup the acore user properly to be used by the db_assembler script
### [ALTERNATIVE] Edit script configuration
If you don't want to use the default acore user, then you can change the configuration of the script with the following steps:
- Copy the file `conf/dist/config.sh` to `conf/config.sh`
- Open the `conf/config.sh` with any text editor
- Go to the secion `DB EXPORTER/IMPORTER CONFIGURATIONS`
- Edit the variables accordingly, e.g. you most likely need to edit `MYSQL_USER` and `MYSQL_PASS` variables putting your mysql server settings.
### Run the script
**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're using Windows you must set-up MySQL as an Environment Variable using [this tutorial](http://www.azerothcore.org/wiki/Environment-Variable) and run the commands using **git bash**
- Make sure you are currently located in the `azerothcore-wotlk` directory
- Run `bash apps/db_assembler/db_assembler.sh`
- Select `import-all: Assemble & Import all`
- Once the process is finished, you can exit the script.
## How to setup the AzerothCore DB manually
Alternatively, you could also [set up your DB manually](Database-Manual-Setup.md) but this process is harder and not recommended for beginners.
|
