MYSQL auth with apache .htaccess

MySQL authentication provides a more flexible and powerful system than Basic or Digest authentication. All the username's and passwords can be in database which provides capability to standardize among all web servers.

Module: mod_auth_mysql

Configure following parameters at .htaccess file

AuthType: This need to be Basic.
AuthName: This is the name (realm) you want to give to your password protected site.
Auth_MYSQLhost: Your MySQL database hostname.
Auth_MYSQLusername: Your MySQL database username.
Auth_MYSQLpassword: Your MySQL database password.
Auth_MYSQLdatabase: This is your database with the member's info.
Auth_MYSQLpwd_table: The members info table containing (Apache username/password).
Auth_MYSQLuid_field: The username field.
Auth_MYSQLpwd_field: The password field.
Auth_MYSQL_EncryptedPasswords: Are the password MySQL encrypt. [onoff].
require valid-user

Ref:
https://www.widexl.com/tutorials/htaccess.html