I've been struggling with this in a brand new 8.10 server myself that I
just setup yesterday. Not sure how or why, but i got this magic
incantation to work (do note however, I'm storing the passwords in
plaintext in mySQL):
AuthName "CRiMson -- use: test/test123
SOLVED:
THIS IS STUPID!! The Where clause requires that YOU put an additional
"AND" in there.
Auth_MySQL_Where " AND type = 'Admin' AND enabled = 1
"
So the auth_mysql code must be making a "SELECT * FROM user WHERE
username = 'foo' AND password = 'bar' WHERE 1" or some other c
