On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,629 Users
  • 2,269,769 Discussions
  • 7,916,800 Comments

Discussions

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

theDBAugie
theDBAugie Member Posts: 3
edited Jun 21, 2019 9:42AM in MySQL Community Space

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?

Best Answer

Answers