![\"How](\"https:\/\/linuxadmin.io\/wp-content\/uploads\/2017\/08\/mod_auth_mysql-installation.png\")
<\/p>\n<\/p>\n
mod_auth_mysql is an Apache module used for authenticating users against a MySQL database. It is commonly used to protect items on a website via a user login prompt. The module is able to authenticate against a MySQL database to check for a valid username and password, it supports various encryption methods. You can view more about it on the project page<\/a>.<\/p>\n This guide assumes you already have a working MySQL installation and Apache is already installed. If you do not have Apache installed please see our guide on How To Install Apache<\/a><\/p>\n The last version of the module was created was designed for Apache 2.0 (we will show you how to patch it for 2.2 and 2.4 as well) First change to a download directory<\/p>\n cd \/usr\/src<\/p>\n Get the package<\/p>\n wget https:\/\/github.com\/linuxadminio\/mod_auth_mysql\/raw\/master\/mod_auth_mysql-3.0.0.tar.gz<\/p>\n Extract the package<\/p>\n tar xfvz mod_auth_mysql-3.0.0.tar.gz<\/p>\n Go into the directory<\/p>\n cd mod_auth_mysql-3.0.0<\/p>\n If you only have Apache 2.0 you can skip the next few steps, if you have 2.2 or 2.4 get the patch<\/p>\n https:\/\/raw.githubusercontent.com\/linuxadminio\/mod_auth_mysql\/master\/mod_auth_mysql-300-apache-22.patch<\/p>\n Patch mod_auth_mysql for Apache 2.2<\/p>\n patch < mod_auth_mysql-300-apache-22.patch<\/p>\n If you have Apache 2.4, you will need to perform one more step. Open up mod_auth_mysql.c<\/p>\n nano mod_auth_mysql.c<\/p>\n Change the following lines<\/p>\n line 908 from<\/p>\n return r->connection->remote_ip;<\/p>\n To<\/p>\n return r->connection->client_ip;<\/p>\n Line 1273 from:<\/p>\n const apr_array_header_t *reqs_arr = ap_requires(r);<\/p>\n To:<\/p>\n const apr_array_header_t *reqs_arr = NULL;<\/p>\n Line 1275 from:<\/p>\n const array_header *reqs_arr = ap_requires(r);<\/p>\n To:<\/p>\n const array_header *reqs_arr = NULL;<\/p>\n Go ahead and compile it<\/p>\n apxs -c -L\/usr\/lib\/mysql -I\/usr\/include\/mysql -lmysqlclient -lm -lz mod_auth_mysql.c<\/p>\n You should now be able to load the module in your httpd.conf<\/p>\n nano \/etc\/httpd\/conf\/httpd.conf<\/p>\n and add the following line<\/p>\n LoadModule mysql_auth_module modules\/mod_auth_mysql.so<\/p>\n Go ahead and restart apache<\/p>\n service httpd restart<\/p>\n It should restart successfully and you should be able to use mod_auth_mysql to authenticate now.<\/p>\n Aug 17, 2017LinuxAdmin.io<\/p>\nInstall mod_auth_mysql<\/h3>\n