diff options
| -rw-r--r-- | docs/Database-Setup.md | 2 | ||||
| -rw-r--r-- | docs/Environment-Variable.md | 26 |
2 files changed, 28 insertions, 0 deletions
diff --git a/docs/Database-Setup.md b/docs/Database-Setup.md index 5685ef7..30fc259 100644 --- a/docs/Database-Setup.md +++ b/docs/Database-Setup.md @@ -13,6 +13,8 @@ You can setup the database manually or using the automated 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) + - Run `bash apps/db_assembler/db_assembler.sh` - Select `import-all: Assemble & Import all` - Once the process is finished, you can exit the script. diff --git a/docs/Environment-Variable.md b/docs/Environment-Variable.md new file mode 100644 index 0000000..b6f306f --- /dev/null +++ b/docs/Environment-Variable.md @@ -0,0 +1,26 @@ +### Introduction +To use MySQL server on the command line, you must have the correct system path. This is usually done automatically. + +How to check if the MySQL server is a Environment Variable: +* Press `Windows + R` and type cmd +* In the CMD opened type `mysql` + +If the MySQL server is not a Environment Variable you will get an error like : `Not recognised command` + +### Requirements +It is a must to have MySQL server already installed, if you don't have MySQL server installed follow [this tutorial](http://www.azerothcore.org/wiki/Requirements) + +### Procedure + +* Locate `mysql.exe`. For example: `C:\Program Files\MySQL\MySQL Server 5.6\bin` +* Search for `Edit the system environment variables` +* Click `Environment Variables` and locate `User variables for $USERNAME` +* Select `Path` variable and click Edit +* Press the `New` button and insert the path to `mysql.exe` you located earlier +* * Example: `C:\Program Files\MySQL\MySQL Server 5.6\bin` + +Now everything is set-up and you can acces `mysql` from the command line. + +To check if the set-up was done correctly press `Windows + R` and type cmd, when you will type `mysql` in the console you will see all the options. + +[Click here to return to the Database Setup](http://www.azerothcore.org/wiki/Database-Setup) |