Need some help in local network server setup💬 [Support Request]

[rmzV]

Core Version

mangos-wotlk

Support Request Details

Hello! i decided to organize server in my small local network, created by kinetic router. All of the PCs have static ips, i replaced in mangosd.conf and realmd.conf ip and in DB "realmist" ip value to 192.168.1.36 (with is main PC with server)

and i get error: 2022-03-31 13:00:03 ERROR:Could not connect to MySQL database at 192.168.1.36: Host 'XXXXX' is not allowed to connect to this MySQL server

2022-03-31 13:00:03 ERROR:Cannot connect to database.

May be in some places i must keep local host ip?

PS i am on some old server version(

Steps to Reproduce

1. mangos.conf (part that changed) LoginDatabaseInfo = "192.168.1.36;3306;mangos;mangos;wotlkrealmd" WorldDatabaseInfo = "192.168.1.36;3306;mangos;mangos;wotlkmangos" CharacterDatabaseInfo = "192.168.1.36;3306;mangos;mangos;wotlkcharacters" LogsDatabaseInfo = "192.168.1.36;3306;mangos;mangos;wotlklogs"
2. realmd.conf (part that changed)
3. LoginDatabaseInfo = "192.168.1.36;3306;mangos;mangos;wotlkrealmd"

Crash Log

No response

Core SHA1 Commit Hash

18b5072f084939cf7ccfef5cf40e6c871be3575e

Database SHA1 Commit Hash

b2707d740b6784e48db65ad1747ce136ea6915fc

Server Operating System

windows 8

Client Version

3.3.5a (Wrath of the Lich King)

Client Operating System

windows 8

[celguar]

@rmzV Hello, if your mangos server and MySQL is on the same PC, keep it 127.0.0.1, e.g. 127.0.0.1;3306;mangos;mangos;wotlkrealmd

[rmzV]

@celguar thank you! i keep 192.168.1.36 values in my Mysql DB and in game-client file, and it works. (all other i switched back to 127.0.0.1) If i will have static ip from my provider, will it be possible to host game not only locally?

is it possible to have several realmists inside "realmist" table for local and external networks?