Well to no surprise I came across some problems trying to install mod_auth_mysql.

Specifically:
/usr/sbin/apxs -i -a -n auth_mysql libauth_mysql.so
cp libauth_mysql.so /usr/lib/apache/libauth_mysql.so
cp: cannot stat `libauth_mysql.so': No such file or directory
apxs:Break: Command failed with rc=65536
make: *** [install] Error 1

Now I don't quite get why.

My server has been running apache 1.3.12, php4.0.2 and mysql 3.22.32 fine.
I have DSO support enabled (verified using httpd -l). Mysql is installed in /usr/local/mysql and apxs is in /usr/sbin.

I don't seem to have libmysqlclient.so.6 anywhere on my system or libmysqlclient.so! Could this be because I installed the binary tarball of mysql?

HELP !!!!!!