From 71ab373b9c91e91d0cd83dca85e5ea3452da5bba Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Tue, 12 Jan 2021 16:29:32 -0300 Subject: Adding SQL syntax (#354) --- docs/Database-Setup.md | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) (limited to 'docs/Database-Setup.md') 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. -- cgit