mac 开启Mysql日志并查看

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 Query	show variables like'general_log_file'
2020-07-16T10:08:27.838478Z	    9 Query	show databases

 

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