step1: 進入終端進入mysql：(mysql -uroot -p)

Jason-MacBook-Pro:~ wangying$ mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

step2 : 開啟mysql日志(set global general_log = on)

mysql> set global general_log = on

-> ;

Query OK, 0 rows affected (0.01 sec)

step3 : 查看mysql的日志文件所在位置(show variables like'general_log_file')

mysql> show variables like'general_log_file';

+------------------+---------------------------------------------+

| Variable_name | Value |

+------------------+---------------------------------------------+

| general_log_file | /usr/local/mysql/data/Jason-MacBook-Pro.log |

+------------------+---------------------------------------------+

1 row in set (0.01 sec)

step4 : 在終端中用tail -f 命令打開該日志文件：(sudo tail -f 上面查到的sqllog日志路徑)

Jason-MacBook-Pro:~ wangying$ sudo tail -f /usr/local/mysql/data/Jason-MacBook-Pro.log

Password:

/usr/local/mysql/bin/mysqld, Version: 8.0.19 (MySQL Community Server - GPL). started with:

Tcp port: 3306 Unix socket: /tmp/mysql.sock

Time Id Command Argument

2020-07-16T10:05:24.931239Z 9 Queryshow variables like'general_log_file'

2020-07-16T10:08:27.838478Z 9 Queryshow databases

本文地址：https://blog.csdn.net/Jason_WangYing/article/details/107389505

如您對本文有疑問或者有任何想說的，請點擊進行留言回復，萬千網友為您解惑！