How to Enable General Query Logging in MySQL Windows & Linux - MySQL DBA Tutorial

General Query Logging for MySQL in Windows:
If General Query logs are enabled without providing the location for General Query log file, then by default location for the General Query log will be "C:\ProgramData\MySQL\MySQL Server 8.0\Data" and file name will be "HostName.log".

To make change for General Query log file location and name , you can go to my.ini file on below path
"C:\ProgramData\MySQL\MySQL Server 8.0", Look for

general-log=0
general_log_file="HostName.log"

Change the value general-log=1 to enable it. if you would like to update the location for file, you can change in general-log-file=Folder Path/GeneralQueryLogFile.log


General Query Log File in Linux:

The default location for General Query log file for MySQL installed on Linux is /var/lib/MySQL. If you need to make changes to default location and binary file name, you can go to /etc/my.cnf file and update it.
In case of default location, the name of the file will be "HostName.log". You can add below configuration to /etc/my.cnf to enable or disable General Query log.
general-log=0
general_log_file="/DirectoryPath/HostName.log"

Once you will make the changes, you will be restarting the MySQL service.
To follow step by step tutorial for MySQL DBA for beginner to Advance
http://www.techbrothersit.com/2018/11...

MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Tools for Development and Admin