差别

这里会显示出您选择的修订版和当前版本之间的差别。

--- 联网 [2023/09/23 20:15] – admin
+++ 联网 [2023/09/23 20:18] (当前版本) – [Setting the auth database realmlist for internet connections] admin
@@ 行 20: / 行 20: @@
 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) or with the MySQL command-line interface (CLI).
+  * 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 the MySQL server.
-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 the MySQL server.
+  * Open the acore_auth database and find the realmlist table. You need to edit the address field according to your needs:
+    * LAN IP (192.168.x.x) - If you are installing AzerothCore on a different computer from where you run WoW, but all the computers involved are on the same network (router) use that computer's Local Area Network IP.
-Open the acore_auth database and find the realmlist table. You need to edit the address field according to your needs:
+    * 127.0.0.1 - Also known as "localhost". Leave this setting alone here and in your configs, if you've installed AzerothCore on the same computer you run WoW on, and only you are connecting to it.
+    * Public IP address – 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.
-LAN IP (192.168.x.x) - If you are installing AzerothCore on a different computer from where you run WoW, but all the computers involved are on the same network (router) use that computer's Local Area Network IP.
+      * If you're hosting it from a home network you'll likely need to set up the proper port forwards, which isn't covered within the scope of this guide. https://portforward.com has guides for most routers, and your Internet Service Provider should be able to assist with this.
+    * Fully qualified domain name - (mydomain.com or warcraft.mydomain.com) Similar to an external IP address, this would be used if you want other people to connect to your server with the added benefit of not needing to track a potentially dynamic IP address.
-.0.0.1 - Also known as "localhost". Leave this setting alone here and in your configs, if you've installed AzerothCore on the same computer you run WoW on, and only you are connecting to it.
+      * Similar to the Public IP address, it's likely that you'll need to set up port forwards if you're hosting from a home network.
+      * Additionally, you'll need to configure DNS to point to the server's public IP address. Setting up DNS is out of the scope of this guide, though your domain registrar or dynamic DNS provider should have this documentation available.
-Public IP address – 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
-If you're hosting it from a home network you'll likely need to set up the proper port forwards, which isn't covered within the scope of this guide. https://portforward.com has guides for most routers, and your Internet Service Provider should be able to assist with this.
+    * You should see a prompt change to mysql>
-Fully qualified domain name - (mydomain.com or warcraft.mydomain.com) Similar to an external IP address, this would be used if you want other people to connect to your server with the added benefit of not needing to track a potentially dynamic IP address.
+    * use acore_auth;
+    * Replace your IP with the one you've chosen to use from above
-Similar to the Public IP address, it's likely that you'll need to set up port forwards if you're hosting from a home network.
+    * UPDATE realmlist SET address = '[your_ip]' WHERE id = 1;
-Additionally, you'll need to configure DNS to point to the server's public IP address. Setting up DNS is out of the scope of this guide, though your domain registrar or dynamic DNS provider should have this documentation available.
+    * exit
-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_auth;
-Replace your IP with the one you've chosen to use from above
-UPDATE realmlist SET address = '[your_ip]' WHERE id = 1;
-exit