|
## login as root user
mysql -uroot -p
## e.g. show variables that end with log
MariaDB [(none)]> show variables like '%log';
+----------------------------------+-------+
| Variable_name | Value |
+----------------------------------+-------+
| back_log | 50 |
| general_log | ON |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_recovery_update_relay_log | OFF |
| log | ON |
| relay_log | |
| slow_query_log | OFF |
| sync_binlog | 0 |
| sync_relay_log | 0 |
+----------------------------------+-------+
|