MySQL PAM Config set up database table and column name for username and password # vim /etc/pam.d/nginx auth required pam_mysql.so user=USERNAME_HERE \ passwd=PASSWORD_HERE \ host=HOSTNAME_HERE \ db=DATABASE_HERE \ table=TABLE_OR_VIEW_NAME_HERE \ usercolumn=USERNAME_COLUMN \ passwdcolumn=PASSWORD_COLUMN \ crypt=0 sqllog=0 # repeat …. with config above account required pam_mysql.so user=USERNAME_HERE \ …….. crypt=0 sqllog=0 # alternatively, to external config file …
