====MySQL/MariaDB====

The MySQL output module allows you to write data to a MySQL or MariaDB database server.

^Parameter^Default^Meaning^
|**host**|localhost|The host name or IP address of the server|
|**user**||The name of the database user|
|**password**||The database password|
|**database**||The name of the database|
|**sql**|INSERT INTO events (start,end,message) VALUES ('%S','%E','%M')|The sql statement to execute, including [[event codes|event codes]]|
|**timezone**|UTC|The timezone to write date data in.|

===Example (Event)===

<code>
[
   {
       "type": "event",
       "method": "mysql",
       "host": "myserver",
       "user": "myuser",   
       "password": "mypass",
       "database": "eventlog",
       "sql": "INSERT INTO events (start,end,message) VALUES ('%S','%E','%M')",
       "timezone": "Australia/Sydney"
   }
]
</code>

===Other Modules===

Return to the [[event_methods|list of output modules]].