mysql.cfg - Using MySQL to store settings

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_mysql.sma plugin source.

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