Not tried and tested by me (yet) but I am assured that this is the way to do do this…
AuthName "MySQL Authentication"
AuthType Basic
AuthMySQLHost localhost
AuthMySQLUser accesssecurity
AuthMySQLPassword DBPWD
AuthMySQLDB accesssecurity
AuthMySQLUserTable users
AuthMySQLNameField username
AuthMySQLPasswordField password
AuthMySQLPwEncryption none
AuthMySQLUserCondition "user_status=1"
AuthMySQLAuthoritative On
AuthMySQLEnable On
require valid-user
DirectoryIndex index.html
ErrorDocument 401 /errors/error_not_authenticated.html
ErrorDocument 403 /errors/error_forbidden.html
ErrorDocument 404 /errors/error_not_found.html
ErrorDocument 500 /errors/error_oops.html