How to Enable General Query Logging in MySQL Windows & Linux - MySQL DBA Tutorial скачать в хорошем качестве

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