Antwort
To create a MySQL user and database on the database server, you can run:
CREATE DATABASE game_servers_database;
CREATE USER 'mymulti1v1server'@'123.123.123.123' IDENTIFIED BY 'strongpassword';
GRANT ALL PRIVILEGES ON game_servers_database.multi1v1_stats TO 'mymulti1v1server'@'123.123.123.123';
FLUSH PRIVILEGES;Make sure to change the IP, the username, and the password. You
should probably change the database as well, especially if you already
have one set up you can use.
Schema:
mysql> describe multi1v1_stats;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| accountID | int(11) | NO | PRI | 0 | |
| serverID | int(11) | NO | PRI | 0 | |
| auth | varchar(64) | NO | | | |
| name | varchar(64) | NO | | | |
| wins | int(11) | NO | | 0 | |
| losses | int(11) | NO | | 0 | |
| rating | float | NO | | 1500 | |
| lastTime | int | NO | | 0 | |
| recentRounds | int | NO | | 0 | |
+--------------+-------------+------+-----+---------+-------+