pureftpd-mysql.conf

# https://github.com/jedisct1/pure-ftpd/blob/master/pureftpd-mysql.conf

MYSQLServer     db
MYSQLPort       3306
MYSQLUser       pureftpd
MYSQLPassword   asupersecretpassword
MYSQLDatabase   pureftpd

MYSQLCrypt      crypt

MYSQLGetPW      SELECT Password FROM users WHERE User='\L'
MYSQLGetUID     SELECT Uid FROM users WHERE User='\L'
# MYSQLDefaultUID 1000
MYSQLGetGID     SELECT Gid FROM users WHERE User='\L'
# MYSQLDefaultGID 1000
MYSQLGetDir     SELECT Dir FROM users WHERE User='\L'

# MySQLGetQTAFS  SELECT QuotaFiles FROM users WHERE User='\L'
# MySQLGetQTASZ  SELECT QuotaSize FROM users WHERE User='\L'
# MySQLGetRatioUL SELECT ULRatio FROM users WHERE User='\L'
# MySQLGetRatioDL SELECT DLRatio FROM users WHERE User='\L'
# MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User='\L'
# MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User='\L'

# MySQLForceTildeExpansion 1
MySQLTransactions On