mysql daemon failed to start

来源:2-23 mysql数据库安装与配置实操(linux系统同学看这节)

凌晨四点D洛杉矶

2017-09-02

老师我在2-23中按照视频里的步骤修改完my.conf文件,设置开机自启动(到此之前的和视频完全一致)之后,执行sudo service mysqld start命令,显示mysql daemon failed to start  下面的状态是failed 我尝试过重启 但是发现mysql并未自启动

写回答

4回答

隐姓埋名的姓严的

2017-11-21

我也是一样的情况,重装了没用

最后解决是vim /var/log/mysql.log查看日志

复制里面【error】的部分在百度里搜索

我的百度出来解决方案是直接运行

mysql_install_db

就解决的

6
3
mdc430
根本没有这个日志文件啊。。
2019-08-25
共3条回复

Geely

2017-09-03

这个步骤真是赞!!赞同学!!

0
0

qq_雲爲衣風爲裳_04358368

2017-09-03

  1. 卸载之前安装的mysql  yum remove mysql mysql-server mysql-libs compat-mysql51

  2. yum install -y mysql-server mysql mysql-deve 重新安装mysql

  3. 对比老师视频里面安装语句  sudo yum -y install mysql-server 进行安装之后一直启动失败,提示

    This probably means that your libc libraries are not 100 % compatible
    with this binary MySQL version. The MySQL daemon, mysqld, should work
    normally with the exception that host name resolving will not work.
    This means that you should use IP addresses instead of hostnames
    when specifying MySQL privileges !
    Installing MySQL system tables...
    170903 21:18:23 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.

    Installation of system tables failed!  Examine the logs in
    /var/lib/mysql for more information.

    You can try to start the mysqld daemon with:

        shell> /usr/libexec/mysqld --skip-grant &

    and use the command line tool /usr/bin/mysql
    to connect to the mysql database and look at the grant tables:

        shell> /usr/bin/mysql -u root mysql
        mysql> show tables

    Try 'mysqld --help' if you have problems with paths.  Using --log
    gives you a log in /var/lib/mysql that may be helpful.

    Please consult the MySQL manual section
    'Problems running mysql_install_db', and the manual section that
    describes problems on your OS.  Another information source are the
    MySQL email archives available at http://lists.mysql.com/.

    Please check all of the above before mailing us!  And remember, if
    you do mail us, you MUST use the /usr/bin/mysqlbug script!

                                                               [失败]

    后来重新用 yum install -y mysql-server mysql mysql-deve 重新安装mysql之后mysql启动成功,是否是因为系统不同造成这个问题,老师是mac,本人用win10虚拟机安装centos 6.8。

  4. 感谢楼上提醒卸载重新安装。

0
0

Geely

2017-09-03

你好t同学 mysql daemon failed to start 

这个有具体相关截图没,一期发上来。 看起来是启动失败了。

你的版本和课程一致么?

http://www.jb51.net/article/36187.htm

http://blog.csdn.net/lanxe/article/details/8108614


特意给你找了两个文章。


看看mysql的日志,里面能看出来是具体是为什么启动失败。

0
3
Geely
回复
凌晨四点D洛杉矶
我给大家整理了这个,有问题可以来看看先找一下。 肯定有你想要的哈 http://www.imooc.com/article/20193
2017-09-03
共3条回复

从0开始 独立完成企业级Java电商网站服务端开发

前后端分离,数据库接口设计,架构设计,功能开发,上线运维

9430 学习 · 8789 问题

查看课程