From a43d4746c0c240e9adc2a006a3d6a9e69e0d43aa Mon Sep 17 00:00:00 2001 From: XSNomad <60951221+XSNomad@users.noreply.github.com> Date: Sat, 24 Sep 2022 12:12:14 -0400 Subject: Adds MySQL CLI (#812) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit * Adds MySQL CLI Adds MySQL CLI command line since the CLI was used from https://www.azerothcore.org/wiki/database-installation * Update docs/networking.md * Update docs/networking.md Co-authored-by: Stefano Borzì --- docs/networking.md | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'docs') diff --git a/docs/networking.md b/docs/networking.md index 569cb34..1f87a90 100644 --- a/docs/networking.md +++ b/docs/networking.md @@ -19,7 +19,7 @@ This is where you have to use your internet IP so clients from the internet can You need to make sure that your **authserver** application directs incoming connections to your realm. -- Run your chosen database management tool (ex. SQLYog or HeidiSQL) +- Run your chosen database management tool (ex. SQLYog or HeidiSQL) or with the MySQL command-line interface (CLI). - If you need to connect to your database from one external machine, read https://www.enovision.net/mysql-ssh-tunnel-heidisql instead open ports to mysql server. @@ -31,6 +31,13 @@ You need to make sure that your **authserver** application directs incoming conn - External IP – If you want other people to connect to your server, use your external IP. Visit http://www.whatismyip.com/ to find your external IP address. + - MySQL CLI Commands (This step is not needed if you used a MySQL Manager like HeidiSQL) + - `$ sudo mysql` + - You should see a prompt change to mysql> + - use acore_world; + - **Replace your IP with the one you've chosen to use from above** + - `UPDATE realmlist SET address = '[your_ip]' WHERE id = 1;` + - exit
## Help -- cgit