1
edit
Changes
no edit summary
This should also be enabled from the server side too.
* What are the exact sequence of steps that you need to take so that Apache logs can be read in from MySQL:
Install mod_log_sql module and issue following commands.
mysqladmin CREATE apache_logs
mysql apache_logs < access_logs.sql
mysql alache_logs
GRANT INSERT,CREATE ON apache_logs.* TO 'root'@'localhost' IDENTIFIED BY 'password';
Add following lines to httpd.conf:
<IfModule mod_log_sql.c>
LogSQLLoginInfo mysql://webserver:password@mysqldb.example.com/apache_logs
LofSQLCreateTables on
</IfModule>
* Name two security measures that MySQL recommends: