Tech

DBeaver to visualize and edit your databases

Create multiple users for each application on MariaDB to have them separated, never use admin as it will have access to all databases

I can record log files in my.conf

general_log = 1
general_log_file = /var/log/mysql/mysql.log

But I need to make sure to have right file privilages set and that I use something like logroate to compress and move my files. As the logs contain crucial information and saved in plain text.