Centos7安装 mariadb启动错误解决

本人遇到mariadb 启动错误的故障解决过程分享。

故障现象

Centos7 使用 yum -y install mariadb mariadb-server  安装完成mariadb后启动错误。

错误信息:

[root@iZ882mt6umfZ ~]# systemctl status mariadb.service

[0m mariadb.service - MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: failed (Result: exit-code) since Fri 2019-03-01 09:25:54 CST; 9s ago

Process: 309 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=1/FAILURE)

Process: 308 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)

Process: 32745 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

Main PID: 308 (code=exited, status=0/SUCCESS)

Mar 01 09:25:53 iZ882mt6umfZ systemd[1]: Starting MariaDB database server...

Mar 01 09:25:53 iZ882mt6umfZ mariadb-prepare-db-dir[32745]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.

Mar 01 09:25:53 iZ882mt6umfZ mariadb-prepare-db-dir[32745]: If this is not the case, make sure the /var/lib/mysql is empty before running mariad...db-dir.

Mar 01 09:25:53 iZ882mt6umfZ mysqld_safe[308]: 190301 09:25:53 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

Mar 01 09:25:53 iZ882mt6umfZ mysqld_safe[308]: 190301 09:25:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: mariadb.service: control process exited, code=exited status=1

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: Failed to start MariaDB database server.

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: Unit mariadb.service entered failed state.

Mar 01 09:25:54 iZ882mt6umfZ systemd[1]: mariadb.service failed.

解决方案:

yum install mariadb*

chown -R mysql:mysql /var/lib/mysql/

启动正常:

root@iZ882mt6umfZ ~]# systemctl start mariadb

[root@iZ882mt6umfZ ~]# systemctl status mariadb

[0m mariadb.service - MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: active (running) since Fri 2019-03-01 09:38:58 CST; 13s ago

Process: 1875 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)

Process: 1843 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

Main PID: 1874 (mysqld_safe)


©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 作者:刘墉 阅读时间:2018年3月9-11日 001 说话的声调会带来不同的效果 打电话或接电话...
    散落的曲调阅读 5,281评论 0 0
  • 人生一大幸事之一就是得一知己。 晚上孩子去打篮球,从8点到十点才回家。电话过去,他告诉我妈妈,我在篮球场聊天,遇到...
    策策妈国学育儿阅读 2,241评论 0 1
  • 来到这个世上谁也无法预知明天将会发生什么,乃至下一秒。真的…… 2017年...
    笑看人生xKrS阅读 1,391评论 0 0
  • 概述 UISlider用于从连续范围的值中选择单个值的控件。 当您移动滑块的大拇指时,会将其更新后的值传递给附加的...
    coder小鹏阅读 7,192评论 1 2
  • 在我们班有一位同学,他非常喜欢卷头发、揉鼻子和提裤子,这一点可以从他的动作能看出来,他还有一个习惯就是写字很...
    5548谈金华阅读 1,040评论 0 0