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
就解决的
632019-08-25 -
Geely
2017-09-03
这个步骤真是赞!!赞同学!!
00 -
qq_雲爲衣風爲裳_04358368
2017-09-03
卸载之前安装的mysql yum remove mysql mysql-server mysql-libs compat-mysql51
yum install -y mysql-server mysql mysql-deve 重新安装mysql
对比老师视频里面安装语句 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。感谢楼上提醒卸载重新安装。
00 -
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的日志,里面能看出来是具体是为什么启动失败。
032017-09-03
相似问题