service mysql start 启动失败，日志报mysqld: File ‘./bin.index‘ not found (OS errno 13 - Permission denied)

解决方式： chown mysql:mysql -R /opt/apps/data/mysqldata
参考博客：

1. mysqld: File ‘./mysql-bin.index’ not found (Errcode: 13 - Permission denied)
2. MySQL启动失败 mysqld: File ‘./mysql-bin.index’ not found (Errcode: 13 - Permission denied)）

服务器因断电停机，MySQL未设置自启动，需手动重启

查看MySQL进程，确定进程不存在

[root@localhost ~]# ps -ef | grep mysql
root      2264 22896  0 09:14 pts/3    00:00:00 grep --color=auto mysql

启动MySQL

[root@localhost ~]# service mysql start
Starting MySQL SUCCESS!

本以为启动成功，然鹅并没有

[root@localhost ~]# ps -ef | grep mysql
root      1083 22896  0 09:27 pts/3    00:00:00 grep --color=auto mysql

并且一系列操作都无法启动，还报错

[root@localhost mysql]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/opt/apps/tmp/mysql/mysqld.pid).
[root@localhost mysql]# service mysql stop
 ERROR! MySQL server PID file could not be found!

查看/opt/apps/tmp/mysql/mysqld.pid文件

[root@localhost mysql]# cd /opt/apps/tmp/mysql/
[root@localhost mysql]# ll
总用量 8
-rw------- 1 root root 5 3月  30 15:18 mysql.sock.lock
srwxrwxrwx 1 root root 0 3月  30 15:18 mysqlx.sock
-rw------- 1 root root 6 3月  30 15:18 mysqlx.sock.lock

并无mysqld.pid文件

备份mysql.sock.lock, mysqlx.sock.lock文件后删除

[root@localhost mysql]# cp mysql.sock.lock mysqlx.sock.lock /home/
[root@localhost mysql]# rm -rf mysql.sock.lock mysqlx.sock.lock
[root@localhost mysql]# ll
总用量 0
srwxrwxrwx 1 root root 0 3月  30 15:18 mysqlx.sock

启动，依然不行

[root@localhost mysql]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/opt/apps/tmp/mysql/mysqld.pid).
[root@localhost mysql]# ps -ef | grep mysql
roo