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

How to view mysql log files? This problem may be our daily study or work often see. I hope you learned something from this question. The following is the reference content brought to you by Xiaobian. Let's take a look together!

To view the mysql log file: first open the mysql log, remove the comments in front of lines 68 and 69; then restart mysql [sudo service mysql restart]; finally listen to the mysql log.

How to view mysql log files:

Open MySQL Log

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

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

Find lines 68 and 69 and remove the comments before them.

Then restart MySQL.

sudo service mysql restart

Listen to mysql logs

sudo tail -f /var/log/mysql/mysql.log

Thank you for reading! After reading the above, do you know how to view mysql log files? I hope the content of this article is helpful to everyone. If you want to know more about related articles, please pay attention to the industry information channel.

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.