summaryrefslogtreecommitdiff
path: root/docs/Database-Setup.md
diff options
context:
space:
mode:
authorWalter Pagani <paganiwalter@gmail.com>2021-01-12 16:29:32 -0300
committerGitHub <noreply@github.com>2021-01-12 20:29:32 +0100
commit71ab373b9c91e91d0cd83dca85e5ea3452da5bba (patch)
treef3f0855db9e2f7ceae26a5406a5586ba103db96c /docs/Database-Setup.md
parent83ab4b9c777ba53e43f741261468fc465588884f (diff)
downloadwiki-71ab373b9c91e91d0cd83dca85e5ea3452da5bba.tar.gz
wiki-71ab373b9c91e91d0cd83dca85e5ea3452da5bba.tar.bz2
wiki-71ab373b9c91e91d0cd83dca85e5ea3452da5bba.zip
Adding SQL syntax (#354)
Diffstat (limited to 'docs/Database-Setup.md')
-rw-r--r--docs/Database-Setup.md5
1 files changed, 1 insertions, 4 deletions
diff --git a/docs/Database-Setup.md b/docs/Database-Setup.md
index 834776e..92953c7 100644
--- a/docs/Database-Setup.md
+++ b/docs/Database-Setup.md
@@ -10,7 +10,7 @@ We recommend to get a database client to operate to your DB easily, see [this pa
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';
@@ -23,7 +23,6 @@ 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:
@@ -44,8 +43,6 @@ If you don't want to use the default acore user, then you can change the configu
- 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.