无法启动mysql

chy_111

[iyunv@WZ-ZABBIX-01 init.d]# systemctl status mariadb.service
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled)
   Active: failed (Result: exit-code) since Fri 2015-08-28 14:33:41 CST; 1min 43s ago
  Process: 24465 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)
  Process: 24464 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 24437 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 24464 (code=exited, status=0/SUCCESS)

Aug 28 14:33:37 WZ-ZABBIX-01 systemd[1]: Starting MariaDB database server...
Aug 28 14:33:38 WZ-ZABBIX-01 mysqld_safe[24464]: 150828 14:33:38 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
Aug 28 14:33:38 WZ-ZABBIX-01 mysqld_safe[24464]: 150828 14:33:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Aug 28 14:33:40 WZ-ZABBIX-01 mysqld_safe[24464]: 150828 14:33:40 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
Aug 28 14:33:41 WZ-ZABBIX-01 systemd[1]: mariadb.service: control process exited, code=exited status=1
Aug 28 14:33:41 WZ-ZABBIX-01 systemd[1]: Failed to start MariaDB database server.
Aug 28 14:33:41 WZ-ZABBIX-01 systemd[1]: Unit mariadb.service entered failed state.




解决方法如下：
chown -R mysql:mysql /var/lib/mysql