差别

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

--- 联网 [2023/09/23 20:16] – [Setting the auth database realmlist for internet connections] admin
+++ 联网 [2023/09/23 20:18] (当前版本) – [Setting the auth database realmlist for internet connections] admin
@@ 行 21: / 行 21: @@
   * 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.
+  * Open the acore_auth database and find the realmlist table. You need to edit the address field according to your needs:
-  * 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.
+    * 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.
-    * 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.
+    * 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.
+      * 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.
-    * 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.
+    * 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.
+      * 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.
-    * 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.
+      * 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.
+  * MySQL CLI Commands (This step is not needed if you used a MySQL Manager like HeidiSQL)
-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.
+    * $ sudo 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.
+    * You should see a prompt change to mysql>
+    * use acore_auth;
-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.
+    * Replace your IP with the one you've chosen to use from above
-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.
+    * UPDATE realmlist SET address = '[your_ip]' WHERE id = 1;
-MySQL CLI Commands (This step is not needed if you used a MySQL Manager like HeidiSQL)
+    * exit
-$ 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