I've loaded mod_auth_mysql in the httpd.conf file and it shows up as loaded in phpinfo()
LoadModule mysql_auth_module modules/mod_auth_mysql.so
This is my .htaccess file. I already created a database called 'webauth' with table 'user_pwd' containing corresponding name/pass fields.
AuthName "Realm Name"
AuthType Basic
require valid-user
Auth_MYSQL On
Auth_MYSQL_DB webauth
Auth_MYSQL_Username root
Auth_MYSQL_Password rootpassword
Auth_MYSQL_Password_Table user_pwd
Auth_MYSQL_Username_Field name
Auth_MYSQL_Password_Field pass
Auth_MYSQL_Empty_Passwords On
Auth_MYSQL_Encryption_Types Plaintext
When I try to access http://localhost/mysql/content.html, I get a server error, along with this in the error.log
[Tue Sep 19 08:49:29 2006] [alert] [client 127.0.0.1] C:/Program Files/xampp/htdocs/mysql/.htaccess: Invalid command 'Auth_MYSQL', perhaps misspelled or defined by a module not included in the server configuration
I tried changing Auth_MYSQL (which I believe is correct) to Auth_MySQL, but I get the same error.
Any ideas? Thanks in advance.