怎么查看mysql日志路径

lewis 7年前 (2018-12-07) 阅读数 14 #VPS/云服务器

文章标签 mysql

查看mysql日志路径的方法：

1.登录mysql终端，查看命令如下：

日志文件路径：

mysql>showvariableslike'general_log_file';+------------------+------------------------------------+
|Variable_name|Value|
+------------------+------------------------------------+
|general_log_file|/usr/local/mysql/data/localhost.log|
+------------------+------------------------------------+
1rowinset(0.00sec)

错误日志文件路径：

mysql>showvariableslike'log_error';+---------------+------------------------------------+
|Variable_name|Value|
+---------------+------------------------------------+
|log_error|/usr/local/mysql/data/localhost.err|
+---------------+------------------------------------+
1rowinset(0.00sec)

慢查询日志文件路径:

mysql>showvariableslike'slow_query_log_file';+---------------------+-----------------------------------------+
|Variable_name|Value|
+---------------------+-----------------------------------------+
|slow_query_log_file|/usr/local/mysql/data/localhost-slow.log|
+---------------------+-----------------------------------------+
1rowinset(0.01sec)