How to connect game server with mysql database server if both not in the same server? in which file do we need to change the path ?
How to connect game server with mysql database server if both not in the same server? in which file do we need to change the path ?
In the auth config file, you need to change the server address there. You also need to make a new user on the other server with the MySQL server on it and give it permissions to access the database.
There are also some settings you need to change in the MySQL config file so it can listen for connections from other servers. By default MySQL only listens for connections on the local server, at least in newer versions.
Also, if you have any scripts that update rankings into MySQL, you need to change the connection and user settings there as well.
Moved to a more appropriate section...
I have check table.xml in authd and change it with requirement information from mysql server database, IP, database, username and password, i just only found the information for accessing database in this file only, not including the website register coz i just want to run game server only in another different server. i'm confusing and still working to find out the problem, i have also disable ufw for trial only, i also find paramater database in file /etc/host and change it also with IP server mysql database, but still the problem, i will chek it later when i have more enough time. tq for reply..Originally Posted by DaMadBoy
You need to open a remote connection to a database on another server.
Reply With Quote