ModAuthMysql
in apache config
LoadModule mysql_auth_module modules/mod_auth_mysql.so
in apache config or root dir .htaccess
AuthType Basic AuthMYSQLEnable on AuthMySQLAuthoritative On AuthMySQLHost myhost AuthMySQLUser myuser AuthMySQLPassword mypass AuthMySQLDB mydb AuthMySQLUserTable myauth AuthMySQLNameField Username AuthMySQLPasswordField Password AuthMySQLGroupTable myauth AuthMySQLGroupField UserID AuthMySQLPwEncryption None AuthMySQLNoPasswd Off AuthMySQLUserCondition "ExpiryDate >= CURDATE()" AuthMySQLGroupCondition "ExpiryDate >= CURDATE()"
in protected dirs .htaccess
Require valid-user
REFERRERS
ApacheModules