summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWiZZy <bilucristian25@gmail.com>2019-09-23 19:56:16 +0300
committerFrancesco Borzì <borzifrancesco@gmail.com>2019-09-23 18:56:16 +0200
commit7108c0889c3c3d8c9e52f61e831454443e245db4 (patch)
tree47d8277d1c202c6e2d630feeff75d1ee6c2118fe
parent421d237e293c8ea8aea1e929e9667ba1038a9981 (diff)
downloadwiki-7108c0889c3c3d8c9e52f61e831454443e245db4.tar.gz
wiki-7108c0889c3c3d8c9e52f61e831454443e245db4.tar.bz2
wiki-7108c0889c3c3d8c9e52f61e831454443e245db4.zip
MySQL.exe Environment Variable documentation (#126)
-rw-r--r--docs/Database-Setup.md2
-rw-r--r--docs/Environment-Variable.md26
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)