MysqlConnection for players failed [127.0.0.1]!

[glitchygeorge]

When i start my server it says this: MysqlConnection for players failed [127.0.0.1]!

I have seen some people say it needs to be fixxed by allowing the port 3306 through the firewall, and i did that, but nothing changed the problem persists.

[oktiexe263]

you need to instal XAMPP (for windows), create the database, and for every config.json (for battles and server) add line:
"Connection String": "Server=127.0.0.1; Database=clashroyale_db; Uid=root; Pwd=;",.

The information of tables for the database I have from gemini deep research (which works well), in text file you have the report, every tables for database (in report) you should create. for example: database name: retro_royale

Finally you need to make clash royale server access to the db, create user in db (ex. root, which is default), set password (I removed password because the server will only run local, and eliminate any access problems), and give root (if not have) all premissions for db

report.txt

IMPORTANT EDIT!!: the report is in polish language, to avoid commands translations, i gave you original, translate the descriptions, but not the tables and commands. also you dont need to add comments in db tables

[JONATHANGABR]

or try start your MYSQL server