怎么查看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)

上一篇：防火墙如何开启外网访问mysql

下一篇：怎么通过外网访问mysql数据库