This is one of the simpler and must-know methods as a developer. Both MySQL and MariaDB allow us to create a log file where we can track all the steps in connecting, initializing, and executing queries in a database. First, we need to add some configurations to the MySQL/MariaDB ini file. Since we are using WAMP for the development tasks of this book, you can click on the WAMP icon, go to the MySQL section, and open the my.ini file. You can use the same process for MAMP or any other tools that offer MySQL/MariaDB configuration.
In Linux servers, the MySQL/MariaDB configuration file is often /etc/mysql/my.cnf; if you don't find it try to locate it using sudo updatedb ; locate my.cnf.
Next, you can add the following ...
