mysql错误信息 echo_mysql：错误日志log_error:

1、启动错误日志：

在不同的情况下，错误日志会记录在不同的位置，如果没有配置文件指定文件名，则默认为hostname.err

在mysql5.6的RPM发布的方式中，错误日志被放在/var/log/mysqld.log

可以通过my.cnf文件进行配置

[mysqld_safe]

log-error=/var/log/mysqld.log

2、查看错误日志：

mysql错误日志以文本形式存放的

[root@localhost run]# echo > /var/log/mysqld.log 清空mysqld日志文件

[root@localhost run]# cat /var/log/mysqld.log

[root@localhost run]#service myql stop --停止mysql服务

[root@localhost run]# mysqld_safe --skip-grant-tables & 跳过授权进入mysql

[1] 3221

[root@localhost run]# 160328 09:39:08 mysqld_safe Logging to '/var/log/mysqld.log'.

160328 09:39:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

160328 09:39:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[1]+ Done mysqld_safe --skip-grant-tables

[root@localhost run]#

3、查看错误日志：

[root@localhost run]# tail /var/log/mysqld.log

2016-03-28 09:39:09 3398 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)

2016-03-28 09:39:09 3398 [ERROR] Can't start server: can't create PID file: No such file or directory

160328 09:39:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[root@localhost run]# perror 2 --查看错误代码

OS error code 2: No such file or directory/

3、删除错误日志：

错误日志可能会不断的增长，因为有必要的周期性的维护：

推荐的删除方法：

#echo > /var/log/mysqld.log