CentOS启动MySQL服务失败

时间:2023-03-08 17:15:56
 :: mysqld_safe Starting mysqld daemon with databases from /data/mysql
:: [Warning] Can't create test file /data/mysql/localhost.lower-test
:: [Warning] Can't create test file /data/mysql/localhost.lower-test
^G/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
:: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
:: InnoDB: Initializing buffer pool, size = 8.0M
:: InnoDB: Completed initialization of buffer pool
:: InnoDB: Operating system error number 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.
:: mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

貌似是SELinux的问题,做了以下两步可以了

1. 修改配置文件修改配置文件/etc/selinux/config(未验证不修改是否可以)

  修改SELINUX=enforcing为SELINUX=permissive

2. chcon -R -t mysqld_db_t /data/mysql