Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of dynamically viewing mysql log files in the Linux terminal. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The method of dynamically viewing mysql log files in Linux terminals:

Step 1: use the following command to open the configuration file for mysql, remove the comments on line 68, and save it.

Sudo vi / etc/mysql/mysql.conf.d/mysqld.cnf

Step 2: restart the mysql service and the mysql log file will be generated.

Sudo service mysql restart

Extra: location of log files for MySQL

/ var/log/mysql/mysql.log # is the location of the mysql log file

Step 3: use the following command to view the log file of mysql in real time

Sudo tail-f / var/log/mysql/mysql.lo on the Linux terminal to dynamically view the mysql log file method to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.