Mysql Problem, Operating system error number 13 in a file operation

Posted by cikul | Posted in Linux, SQL | Posted on 31-07-2017-05-2008

0

Mysql Fail to start, check in /var/log/mysqld.log :


170731 16:56:50 InnoDB: Initializing buffer pool, size = 8.0M
170731 16:56:50 InnoDB: Completed initialization of buffer pool
170731 16:56:50 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
170731 16:56:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

Cause :

Permission problem in /var/lib/mysql

Solutions :

  1. Ensure user and group permission on /var/lib/mysql is mysql
  2. Check SELINUX Configuration : getenforce
  3. If SELINUX enabled, disabled with command : setenforce 0
  4. For permanent disable, edit /etc/selinux/config and set SELINUX=disabled
  5. Try to restart mysql service

Interesting Article :

  1. Repair Mysql Error – The server quit without updating PID file –
  2. Change & Reset Mysql Password
  3. Repair Internal Server Error Cpanel account
  4. How To Optimizing MySQL server
Read More

Write a comment

CAPTCHA

*