Monitor, add, delete, modify, query, and view log records in MySql.

(Switch) add, delete, modify, query, and view log records in MySql, and mysql log records

Reprint address: http://blog.51cto.com/hades02/1641652

First, enter show global variables like '% general %' in the command line, and then the following window appears. The general_log field is the switch, which is usually OFF by default, so monitoring is not enabled yet, then general_log file

To monitor the file log documentation, you only need to turn on the switch to view the add, delete, modify, and query statements you have written in the log.

The following statements are used to enable monitoring:

Find the WZD monitoring document. log (the name of the log file may vary with each other. Search for the file based on the queried file name, which is usually in the data file directory where you install MySQL ), then, some people install the file in the C drive's programdata directory like me. This file may be hidden;

With win7 viewing hidden file method link: https://jingyan.baidu.com/article/af9f5a2dc1f91243150a4553.html

Attached win10 viewing hidden file method link: https://jingyan.baidu.com/article/acf728fd2853fef8e410a37f.html

Then, you can directly view the hidden file in Baidu's system. This is just for convenience ..

Here is the basics .....