怎么查看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)
发表评论:
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。