MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

systemctl start mysqld fails to start;returns"./mysql-bin.index not found (Errcode:13 ...)

theDBAugieApr 8 2019 — edited Jun 21 2019

I am attempting to restart MySQL 5.7.19 on Linux RH (uname -a Linux 3.10.0-957.1.3el7.x86-64). It fails and returns in the log:

2019-04-08T17:52:01.7810250 0 [Note] /usr/sbin/mysqld (mysqld5.7.19.log) starting as process 41374

mysqld: File'.mysql-bin.index' not found (Errcode:13 Permission denied)

2019-04-08T17:52:01.783015 0 [Error] Aborting

binlog end

/usr/sbin/mysqld: Shutdown complete

systemctl status mysqld returns:

mysqld.service - MySQLServer

Loaded: loaded (/usr/lib/systemctl/system/mysql.service, enabled, vendor preset:disabled

Active: activating (start) since Mon 2019-04-08 17.15.26 GMT 1s ago

Docs: man:mysqld(8)

http://dev/mysql.com/doc/refman/en/using-systemd.html

Process: ExecStartPre=/usr/bin/mysqld_pre_systemd (note: EXITED status=0/SUCCESS

CGroup: /system.slice/mysqld.service

-> control

-> 40884 /usr/slice/mysqld -- demonize --pid-file=/var/mysqld.pid

So, my question is, "Where is this mysql-bin.index file supposed to be and what permissions should it have?

This post has been answered by User51642 Yong Huang on Jun 20 2019

Jump to Answer

Added on Apr 8 2019

2 comments

3,105 views