Configuring a MySQL Server

Configuring MySQL on Windows

Firmware: 5.1.20

Collectors: Advanced Windows Collector or WinLog Collector

On a Windows system, MySQL logs events in the Windows Event Viewer. To collect log messages from an Axon Agent with the Advanced Windows Collector, you must install and configure Tripwire Axon Agent for TLC software on the MySQL Server. For instructions, see Installing Tripwire Axon Agent using a Pre-Shared Key.

No additional configuration on the Windows system is required at this time.

Next

If you are performing initial configuration of your TLC environment, see Configuring your TLC Environment.

Otherwise, see Adding a Monitored Asset for a new Log Source.

Configuring MySQL on UNIX or Linux

Firmware: 5.1.20

Collector: Network Collector - Syslog

To configure a UNIX or Linux MySQL server to send log messages to TLC:

1. On the MySQL host system, configure the Syslog to send log messages to TLC (see Configuring a Syslog or Rsyslog Module).
2. Open the MySQL configuration file: 

/etc/my.cnf

3. In the mysql_safe section of the configuration file, enter: 

[mysqld_safe]

syslog

4. Save the modified file.
5. To close and restart the mysqld service, enter the following command:

system mysqld restart

Next

If you are performing initial configuration of your TLC environment, see Configuring your TLC Environment.

Otherwise, see Adding a Monitored Asset for a new Log Source.