如何在mysql服务器上查看日志文件
1 .首先,在命令行上运行命令以启动MySQL服务; windows:netstartmysqllinux:service MySQL start
2.mysql服务启动后,在命令行中输入mysql用户名和密码,然后登录到mysql; mysql-uroot-p
登录MySQL后,可以使用以下命令查询日志文件:
例)查看日志文件mysqlshowvariableslike‘general _ log _ file’; -------------------------------------|variable _ name usr/local/MySQL/data ------------------------------------------.---------------------------------------------- ------------------------------------------.----------------------------------------------
示例:显示错误日志文件mysqlshowvariableslike‘log _ error’; --------------------| variable _ name|vallable MySQL/data/localhost.err | ------------------------------------------.---------------------------------------------- ------------------------------------------.----------------------------------------------
示例:显示滚动查询日志文件mysqlshowvariableslike‘slow _ query _ log _ file’; ----------------------------| sow _ query _ log _ file|/usr/local/MySQL/data /