This is what I use, you'd have to adapt it...

Code
# Start Authentication
AuthName "Auth Name"
AuthType Basic

# Database settings:
AuthMySQLHost localhost
AuthMySQLUser [username]
AuthMySQLPassword [password]
AuthMySQLDB [db]

# User table
AuthMySQLUserTable ubbt_USERS
AuthMySQLNameField [user]
AuthMySQLPasswordField [pass]

# User Roles tables
#AuthMySQLGroupTable data_staff
#AuthMySQLGroupField group
#AuthMySQLGroupCondition "access_cp=1"

# Where clauses
#AuthMySQLUserCondition "access_cp=1"

# Do it to it!
AuthMySQLPwEncryption md5
AuthMySQLEnable On
require valid-user

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!