• AMX Guide Home
  • Step 1: Installing AMX
  • Step 2: Enabling AMX
  • Step 3: Configuring AMX
  • AMX by File:
    • amx.cfg
    • mysql.cfg
    • clcmds.ini
    • cmds.ini
    • configs.ini
    • cvars.ini
    • maps.ini
    • modules.ini
    • paths.ini
    • plugins.ini
    • speech.ini
    • users.ini
  • AMX by Topic:
    • Creating Admins
    • Commands Guide
    • Plugin Installation
    • Plugin Compiling
    • Module Setup
    • Menu Use
    • Language Setup
    • Language Install
    • Weapon Restriction
    • Stats Setup
    • Custom Map Configs
  • Misc. Resources
  • Credit
AMX Mod 2006 Setup Guide
Half-Life server administration

mysql.cfg - Using MySQL to store settings

The mysql.cfg file in your addons\amx\config folder stores the information AMX needs to connect to a MySQL database. This is what the default mysql.cfg file looks like:

// MySQL access configuration file
// File location: $moddir/addons/amx/config/mysql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost"
// instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

amx_mysql_host  "127.0.0.1"
amx_mysql_user  "root"
amx_mysql_pass  ""
amx_mysql_db    "amx"

Then you will have to create your table with the same fields as in usual users.ini: auth, password, access and flags, all as VARCHAR(32) fields. Of course you can tweak this all if you feel like you can modify the admin.sma plugin source.

Anyhow we recommend using phpMyAdmin, which is a great MySQL database administration tool written in PHP.

Half-Life is a registered trademark of VALVe Software and Sierra
AMX Mod was created by OLO and is not affiliated with VALVe.