Mysql服务器无法启动的缘由简析[MySQL防范]

　　Mysql服务器无法启动,错误日记中提醒:

　　^G/usr/local/mysql/bin/mysqld: File './mysql-bin.000013' not found (Errcode: 13)

　　120415 8:59:10 [ERROR] Failed to open log (file './mysql-bin.000013', errno 13)

　　120415 8:59:10 [ERROR] Could not open log file

　　120415 8:59:10 [ERROR] Can't init tc log

　　120415 8:59:10 [ERROR] Aborting www.110hack.com

　　==============================

　　一查看是mysql-bin.000013文件的权限变成了:

　　-rw-rw---- 1 root root 126 Apr 15 00:10 mysql-bin.000013

　　缘由是我上次利用了"/usr/local/mysql/bin/mysqld_safe --user=root &"启动mysqld,所以产生的binlog文件权限变成root.

　　提醒一下启动mysql最好不要利用root用户,官方文档倡导用非root用户启动;

　　作者 rover0