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 :
- Ensure user and group permission on /var/lib/mysql is mysql
- Check SELINUX Configuration : getenforce
- If SELINUX enabled, disabled with command : setenforce 0
- For permanent disable, edit /etc/selinux/config and set SELINUX=disabled
- Try to restart mysql service