Poradniki

Install and secure MariaDB on Debian or Ubuntu for AMX Mod X plugins, choose a same-host or separate-host setup, lock port 3306 to your game server, and back it up with mariadb-dump and cron.

Move CS 1.6 bans from flat files into MySQL with AMXBans: create the database, import the schema, configure the SQL file, load the plugins, and avoid the admin-system conflicts.

Enable the MySQL/SQLx module in AMX Mod X, configure sql.cfg, use threaded queries, and fix the connection errors that actually happen.

Why the whole server stalls the instant a plugin touches MySQL, the difference between blocking and threaded SQLX queries, how SQL_ThreadQuery avoids the freeze, and how to spot the offending plugin.

Why errno 111 is connection refused and not a password problem, the bind-address and skip-networking traps, opening port 3306, and proving the path before blaming the plugin.

Reading the access-denied error an AMXX SQL plugin logs, where the credentials live in sql.cfg, the user@host grant trap, and getting a stats or ban plugin to authenticate.

Use SQL_ThreadQuery to run MySQL queries off the main thread so a slow database never stalls the game, with correct handle lifetime and error handling.

Why an AMXBans command appears to work in-game yet writes nothing to the database: the MySQL module, the amxbans SQL config, load order, and table-prefix mismatches.