MySQL Workbench

Note

From DataMiner 10.4.0 onwards, MySQL is no longer supported as the general database. We recommend switching to Storage as a Service.

MySQL Workbench is a tool for exploring MySQL databases and performing administrative actions.

MySQL Workbench SQL Editor

Tip

• You can download this tool from the MySQL website.
• For more information about how to use this tool, see MySQL Workbench.

Logging queries

To log all queries, perform the following action:

SET global general_log = 1;
SET global log_output = 'table'; // enable logging through table
select * from MySQL.general_log; // view the log

To disable the logging:

SET global general_log = 0;